Question: Please answer the second question (the one worth 10 points) I have solely posted the question before as a reference so that the next question

Please answer the second question (the one worth 10 points) I havePlease answer the second question (the one worth 10 points) I have solely posted the question before as a reference so that the next question can be answered. Thank you.

[15 Points] Design a genealogy database that include a single entity set only: PEOPLE. The database should contain all the information that exists about each individual, including his/her name, mother, father, and children. (1) Present the conceptual database design as an E/R diagram. (2) Convert your E/R diagram into a relational database schema. Show the schema of each relation in this database and identify its key. [10 Points] Modify your database design of "People in the previous question to include the additional information about each individual like gender and whether being a parent or not. Use sub-classes of people (isa relationships) to present these additional information

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!