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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
