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 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
Get step-by-step solutions from verified subject matter experts
