From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Join today to access over 24,700 courses taught by industry experts.
Final project: The Brainery - SQL Tutorial
From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Final project: The Brainery
- [Instructor] Well, here you have it. This is my solution to the final project. As you can see, I've added a couple of more tables, including those associative entities that I referenced in the previous lesson. I have the BrainiacFollowerList, as well as the BrainiacFriendList. I've also made a quick update to the DirectMessage where I've added a DirectMessageId. Remember, I also told you about those post reactions? Well, I also added a reaction table as well. That includes the reaction name, ID, and of course, the emoji. Since a repost is either you repost it or you don't repost it, I just added a quick attribute inside of each of the tables. PostReactionByFriend and PostReactionByFollower. I've included this solution file in the exercise files if you'd like to review it.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.