From the course: MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Solution: Final project

Solution: Final project - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Final project

“

- [Lecturer] All right, this is the solution video for your final course project. Again, we have the questions here and underneath the question numbers we have the timestamps. So if you're interested in a certain question solution, feel free to jump right to that point in the video. We've got questions four, five and six here similarly. Let's jump into Workbench and we can walk through the solution. All right, so the first thing you'll see here is I have simply listed out these six questions into Workbench so that we have them in front of us and we can get going. So first, here's an overview of what Bubs wants us to do. He wants us to track information on his customers, including first name, last name, and email. His employees also first name, last name, start date, and position held. His products and the purchases that customers make, which customer, when it was purchased, how much money, et cetera. So think about how many tables you should create and which data goes into each of the…

Contents