MIT114 - Database Design Assignment - IT Computer Science Assignment Help

Assignment Task

Assignment Part - A

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

This MIT114: IT Computer Science Assignment Help has been solved by our IT Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.