You are to select an online web site that includes a significant use of a database. Some well-known examples to help your thinking are Amazon, ebay, and Facebook. For your selected web site, you are to do the following tasks:
- 1.Identify at lease five entities (or table) that are likely needed by that company for their database.
- 2.Draw an Entity-Relationship Diagram (ERD) of those entities and the likely relationships between them.
- 3.State your recommendation on the primary key for each of those entities (tables).
- 4.State your recommendations on the foreign keys needed to support the relationships shown in your ERD
- 5.Identify the non-key fields or columns that are likely included in those tables.
Categories: