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
- 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:
-
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
-
This is just an example, depending on the database systems you are designing your entities will be different.
- Provide information about how these entities relate to each other. Refer to entity relationships (one to one, one to many, many to many). Example:
- A customer can have many orders and an order can have only one customer.
- Create an ERD Diagram.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started