From the course: MySQL Database Administration

Unlock this course with a free trial

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

Database normalization demo

Database normalization demo - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Database normalization demo

“

- [Instructor] All right, so continuing on our discussion of database normalization, I wanted to walk you through a concrete example here. So from our Maven Fuzzy Factory mini database, which you have in your schemas tab, I've selected all data from website page views non-normalized. So as you can probably guess from the name, this table has not been normalized, and I want to walk you through the process of normalization here. So it's a website page views table, and what this table is trying to represent is when a customer comes to the Maven Fuzzy Factory website, what are all the pages on the website that they see? So in the page view URL column, you see a lot of homepage. You see the products page. You see this page called the Original Mr. Fuzzy, one of the products. You see the cart, the shipping page, billing page, some more homepages. So this is basically serving as a log of the pages that a customer sees on the website. And the table here we have website page view ID, and we can…

Contents