Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases In Networked Information Systems 6th International Workshop Dnis 2010 Aizu Wakamatsu Japan March 2010 Proceedings Lncs 5999

Authors: Shinji Kikuchi ,Shelly Sachdeva ,Subhash Bhalla

2010th Edition

3642120377, 978-3642120374

More Books

Students also viewed these Databases questions

Question

b. What groups were most represented? Why do you think this is so?

Answered: 1 week ago

Question

3. Describe phases of minority identity development.

Answered: 1 week ago

Question

5. Identify and describe nine social and cultural identities.

Answered: 1 week ago