DBA 1. Provide five reasons for creating a conceptual data model. • • Take into

Question

DBA

1. Provide five reasons for creating a conceptual data model.
• • Take into account regulations and laws governing this industry
     1.
     2.
     3.
     4.
     5.

3. Read the business scenario of a fast-food restaurant below:
We are a small Chinese food restaurant. Our menu features food items that can be ordered by a customer to dine in or take out. A customer places an order at the counter and indicates what food items he/she would like on that order.
Lately we've noticed that we have some regular customers, so we started asking them for information -- such as name and address, so we can mail them coupons when we have specials.

a.   Using the restaurant entities ORDER, MENU, AND CUSTOMER -- identify the attributes for each entity
b.   Where possible, indicate whether the attribute is mandatory or optional
c.   Where possible, pick out the UIDs for each entity

Explanation / Answer

Conceptual models like ER diagrams are used to gather information from business requirements.

Conceptual data model is created to :

3.

a,b and c

underlined attributes are IDs for the tables

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.