Question: 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

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 relationships (binary, ternary, many-many, many-one, or one-one).

A) Design a genealogy database with one entity set: People. The information to record about persons includes their name (an attribute), their mother, father, and children.

B) Modify your people database design of Exercise 4.1.6 to include the following special types of people: 1. Females. 2. Males. 3. People who are parents. You may wish to distinguish certain other kinds of people as well, so relationships 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!

LST2BSL Introduction to Business Law and Ethics Common Law Assignment INSTRUCTIONS 1. This assignment is worth 20% of your final mark for this subject. 2. All questions must be answered. 3. With...

Which type of Medical Service (type 1, type 2 etc.) brought the most revenue in Birmingham? In addition to the pivot table, provide a pie chart that displays the total amount billed by the different...

Exercise 4-1 Create the Movie List app This exercise guides you through the development of the Movie List app that's presented in this chapter. This will give you a chance to generate a database from...

a)Explain the difference between an ERP and an AIS? b)A small business operates from home, producing children's clothing. They currently sell their product through local retail shops in the same city...

This case study assignment is based on (but not the same as) the Queen Anne Curiosity Shop (QACS) Case Questions at the end of Chapters 5 and 6. Since there are important differences between the...

please only help with the questions that I have titles "only help with these questions" I have already completed the questions in the book but I need to know if I am doing it correctly. Please show...

important to show your work. Write down each step of the solution and show how you arrived at your answer. This not only helps you keep track of your progress, but also makes it easier to check your...

may not be immediately obvious. Keeping an open mind and considering different approaches can help you find a solution. Learn from your mistakes: If you mistake, don't get discouraged. Instead, use...

Compute 2011 interest expense for the following note: face, $4,000; 12 percent interest; date of note, April 1, 2011.

The flex-headed ratchet wrench is subjected to force P, applied perpendicular to the handle as shown. Determine the moment or torque this imparts along the vertical axis of the bolt at A. Given: P =...

If a company misses three consecutive dividend payments before it then decides to pay dividends, which of the following investors would receive four quarters' worth of dividends? A Common...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Communicate for buy-in. Employees need to know what is occurring. Use briefings, newsletters, Web pages, informational meetings.

2. Identify possible solutions. Ask managers and employees to suggest courses of action to deal with the problem or capitalize on an opportunity. Do not ask for ideas or suggestions if they are not...

Use of multimedia tools, including audio, video, Webcasts, and live action.