Design a database for your model in question, Project 3, part B.

Design a database for your model in question, Project 3, part B. Your design should include a specification of tables and attributes as well as primary, candidate, and foreign keys. Also, specify how you will enforce minimum cardinality. Document your minimum cardinality enforcement using referential integrity actions (See Figure 6-29 in chapter 6 in the textbook or the lecture ) for a required parent, if any, and for a required child, if any.

here is how was project 3 A

i will include the pic in the attacment

A . Create a model with one entity. Specify the identifier and attributes.

B. Create a model with two entities, one for customer and a second for subscription.
Specify identifiers, attributes, relationship name, type, and cardinalities.

C. Under what conditions do you prefer the model in A to that in B?

D. Under what conditions do you prefer the model in B to that in A?

and I will attach my answer in a Word document, and this is the professor’s comment in Part A. “Good work! Notes: The identifier should uniquely determine the instances. In part A, make the subscription number the identifier in the Subscription entity. In part B, make the customer number the identifier in the Customer entity. The minimum cardinality would be M-O. The maximum cardinality would be 1:N. Identifying data types in the data model stage (conceptual design) is not needed. We specify the data type in the next stage.”

i need you to use the answer from project a and use the professor’s comment to fix it and based on this you will be able to answer part B