You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, ﬁrst name, customer ID, street address, customer star rating (a rating on a 1 – 5 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 ﬁrst and last name, there will just be a supplier company name). The database should maintain the data on products that are oﬀered. Information about which product is oﬀered 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 RulesAssumptions for the business model are as follows: • 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. Create an ERD

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, ﬁrst name, customer ID, street address, customer star rating (a rating on a 1 – 5 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 ﬁrst and last name, there will just be a supplier company name). The database should maintain the data on products that are oﬀered. Information about which product is oﬀered 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: • 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.

Create an ERD

Expert Solution