Question: Develop a list that includes all the major entities (tables) needed for your propose Database System. You also need to provide a brief discussion for

  1. Develop a list that includes all the major entities (tables) needed for your propose Database System. You also need to provide a brief discussion for each entity. You need to have at least 7 and no more 12 tables for the project. See example below:
  2. Entity

    Entity Attributes

    Description

    Customer

    Customer_ID

    The customer entity captures information about the customer attributes. The entity attributes contain detail information about the customer identity which allows the company XYZ to better understanding of who they are working with.

    Customer_FirstName

    Customer_MiddleName

    Customer_LastName

    Customer_CompanyName

    Customer_CompanyTitle

    Customer_Address

    Customer_City

    Customer_Region

    Customer_PostalCode

    Customer_Country

    Customer_Phone

    Customer_Email

  3. This is just an example, depending on the database systems you are designing your entities will be different.

  4. Provide information about how these entities relate to each other. Refer to entity relationships (one to one, one to many, many to many). Example:
  5. A customer can have many orders and an order can have only one customer.
  6. Create an ERD Diagram.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!