Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

roblem Statement You are the CTO of a startup based out of Acon, PA that needs to setup a database to keep track of the

roblem Statement You are the CTO of a startup based out of Acon, PA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 15 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track of similar information for suppliers as well (although instead of supplier first and last name, there will just be a supplier company name). The database should maintain the data on products that are offered. Information about which product is offered by which supplier should also be maintained. Finally, which customers have purchased which products should also be tracked (note that we are only interested in which customers bought which product, but not concerned about the date or how many were bought).1.1 Business Rules Assumptions for the business model are as follows. These assumptions should help you design the ERD: Only customers that have purchased one or more products will exist in the database. Only products that the company sells will be stored in the database. Products will have been purchased by one or more of the customers. Suppliers may be potential suppliers (i.e., they may not have necessarily supplied any products yet). If a supplier provides a product, it is the exclusive supplier of that product to your company. Make sure you are marking the relationships correctly. 2 Requirements Create an ERD based on the requirements and business rules stated above. Make sure to do the following: 1. All primary keys should be marked clearly by a solid black line. 2. All foreign keys should be clearly marked by a solid dashed line. 3. All relationships should be resolved, i.e., make sure you dont have any unresolved many-to-many relationships. 4. If you assume any attribute is composite or multi-valued, make sure to mention that in your submission.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions