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.

Challenge: Normalization

Challenge: Normalization - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Normalization

“

- [Instructor] All right, we're ready for your assignment on database normalization. For this assignment, you'll be working with Emily, the owner of the Online Learning School. She needs your help understanding if her database is already normalized or if it has room for improvement. If you find anything that you think could be improved in terms of the database normalization, figure out how you would explain that to Emily, and bonus points if you can go ahead and execute the normalization yourself before watching the Solution Video. Feel free to either create new tables in the schema or alter the existing tables, whatever seems easier for you. The most important concept here is that you understand and can identify which of the tables don't follow good normalization principles, and then think about how to restructure the tables. Secondary, it would be great if you can actually create the tables on your own or alter the tables to get to a normalized state on your own, but focus mostly on…

Contents