Creating a Database and Tables in MySQL with Dummy Data

Logging in MySQL and Creating a denormalized_db database

Use the denormalized_db database and create employeeData table with needed variables

Insert all the needed data in the table

Select the table employeeData to see all the data inside the table

Use the denormalized_db again and create studentData table with needed variables

Insert all the needed data in the table

Select the table studentData to see all the data inside the table

Use the denormalized_db again and create a productData table with needed variables

Insert all the needed data in the table

Select the productData table to see all the data inside the table

Use the denormalized_db again and create a orderData table with needed variables

Insert all the needed data in the table

Select the orderData table to see all the data inside the table

Use the denormalized_db again and create a salesData table with needed variables

Insert all the data in the table

Select the salesData table to see all the data inside the table