Question: a) Design a genealogy database with one entity set: people. The information to record about persons includes their name, social security number. The people entity

a) Design a genealogy database with one entity set: people. The information to record about persons includes their name, social security number. The people entity set has three different roles: mother, father and children.

b) Modify your diagram to include the following special types of people: Females, Males, and people who are parents. Use proper relationships to connect appropriate subclasses of people .

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!

There is no existing database scheme. This is the start of the question... DO ONLY B!!!! SHOW A IF NEEDED TO EXPLAIN PROBLEM B. Make sure to appropriately indicate constraints and the type of...

a) Design a genealogy database with one entity set: people . The information to record about persons includes their name, social security number. The people entity set has three different roles:...

hi I need answer ER d Exerciss2.1.6: Suppose we wish to keep a genealogy We shall have one entity set, People. The information we wish to record about persons includes their name (an attribute) and...

Need help filing out the Form 706 that goes along with the Estate Tax Problem. Specifically, what is the amount entered in line 10, part 5 of the Form 706? Estate\tTax\tProblem...

Problem 2. has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2)...

of 6 Instructions: Please complete the Urban Lifestyle Interiors, Inc.'s 2020 book tax income reconciliation and Farm 1120px 1. based upon the information provided below. If required information is...

San Marcos Manufacturing, Inc. ( SMMI ) has hired your team as consultant for a project to design and implement a database to support their operation. As part of this project, you need to review and...

Database Management Problem 2. (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment...

(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2)...

Consider the events (not J), (H & I ), (H or K), and (H & K) discussed in Problem 11. a. Find the probability of each of those four events, using the f/N rule and your answers from Problem 11. b....

Consider as a system the Sun with the Earth in a circular orbit around it. Find the magnitude of the change in the velocity of the Sun relative to the center of mass of the system over a period of 6...

What is meant by socializing risk and privatizing benefits ? Group of answer choices Expanding public services to offset the downsides of corporate expansion Individuals bear more financial...

Required Rate of Return Stock R has a beta of 1.4, Stock S has a beta of 0.35, the expected rate of return on an average stock is 8%, and the risk-free rate is 5%. By how much does the required...

(Appendices) PURCHASES, SALES, AND COST OF GOODS SOLD. Printer Supply Company sells computer printers and printer supplies. One of its products is toner cartridges for laser printers. At the...

(Appendices) PRESENTATION OF SALES REVENUE AND COST OF GOODS SOLD. The accountant for Sneva, Inc., collected the following data for 19x: LO3 REQUIRED: Assume that Sneva uses the periodic system and...

(Appendices) ADJUSTING ENTRY AND PREPARATION OF FINANCIAL STATEMENTS. Michaels Hardware has the following unadjusted trial balance at the end of 19x3: The following data are also available for...