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:
- Identify at lease five entities (or table) that are likely needed by that company for their database.
- Draw an Entity-Relationship Diagram (ERD) of those entities and the likely relationships between them.
- State your recommendation on the primary key for each of those entities (tables).
- State your recommendations on the foreign keys needed to support the relationships shown in your ERD
- Identify the non-key fields or columns that are likely included in those tables.