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: Mid-course project

Solution: Mid-course project - MySQL Tutorial

From the course: MySQL Database Administration

Solution: Mid-course project

- [Lecturer] All right, this is the solution video for your Midcourse project. As a reminder, you'll be helping the owner of the Maven Movies DVD rental business restructure their database. So you'll be working with the Maven Movies Mini schema and you'll be transforming that into another schema that will be more effective for them to store their data and scale their business. Hopefully as you're watching this video, you've already gone through this assignment on your own. If you haven't, I would really encourage you to try to attempt this problem on your own before just watching me. You're going to learn much better doing the work yourself and then checking your work by watching my video. If you just watch my solution video without actually attempting this on your own, the knowledge is not going to stick as well. Alright, let's jump into workbench and we can walk through it. So I've copied down the six questions that the owner of the DVD rental business is asking us in this…

Contents