1. Identify the entities and their attributes.
2. Construct an ER model.
3. Normalize the data model to its third normal form.
4. Design a Relational Database Model.
5. Draft a data dictionary.
Assignment Part – B
1. Create a MySQL file representing your data dictionary from step 5 (Assignment part A). Name it definition.SQL.
2. Prepare another file Tasks.SQL that performs the following tasks:
- Insert 10 outfits into the database.
- Add 5 customers into the database.
3. Register 6 employees. Two of each role.
4. Record a minimum of two sales transactions per customer.
5. Modify the price of outfit 5 to 150$.
6. Update the email address of customer 4 to your email address.
7. Add a new customer with your tutor’s details.
8. Display the outfits purchased by the customer 2.
9. List the names of customers who bought the “Elegant Evening Gown”.
10. Using a JOIN, display the customers’ names and the total amount they have spent at the boutique.
11. Using a JOIN, list all outfits purchased by