Assignment $3$

Instructions:

For the following problem:

Write the purpose$/$mission statement for the database. Though this should not be long, it should be concise and complete as to the purpose of the database.

Identify and list the initial entities from the provided requirements.

Pare down the entity list based on duplication and other factors resulting in the final entity list that the database will be built.

Write the relationships between each entity.

Do not combine the above. Meaning, provide a list for #$2$ and a final list for #$3.$ For #$4$ you can develop a ERD using the cheat sheet that was provided in Week $2$ resources. Or you can simply write the relationships between the entities. For example:

STUDENTS has a MANY$-$TO$-$MANY relationship with COURSES

COURSES has a MANY$-$TO$-$One relationship with INSTRUCTORS

Problem $($requirements$)$:

Getemtobuyit Company wants you to develop a customer database. They want to store all purchasers' orders and the products on each order. Shoppers of their company should be able to see all of their orders and every item on each order including the vendor of each product. Getemtobuyit would love to know via this database who their favorite product suppliers and best$-$selling products are at any point.