Example of ancestry database , Database Management System

Assignment Help:

Ancestry database records information about family trees. Following information is recorded about each person:

FIRSTNAME first name

SURNAME surname

MNAME maiden name (if applicable)

DOB date of birth

BPLACE place of birth

DOD date of death (if applicable)

DPLACE place of death (if applicable)

SEX male/female

Spouse details:

FIRSTNAME first name

SURNAME surname

MNAME maiden name (if applicable)

DOB date of birth

BPLACE place of birth

DOD date of death (if applicable)

DPLACE place of death (if applicable)

SEX male/female

Father details:

FIRSTNAME first name

SURNAME surname

DOB date of birth

BPLACE place of birth

DOD date of death (if applicable) 3

DPLACE place of birth (if applicable)

Mother details:

FIRSTNAME first name

SURNAME surname

MNAME maiden name (if applicable)

DOB date of birth

BPLACE place of birth

DOD date of death (if applicable)

DPLACE place of birth (if applicable)

Part B: Normal Forms


Related Discussions:- Example of ancestry database

Serialisability, Serialisability: Any schedule that makes the similar resul...

Serialisability: Any schedule that makes the similar results as a serial schedule is known as a serialisable schedule. But how can a schedule are determined to be serialisable or n

Structure of client server systems, Structure of Client Server Systems: In ...

Structure of Client Server Systems: In client/server architecture, clients show users who require services while servers give services. Both client and server are a combination of

Extended star schema, Why did SAP introduce the extended star schema? Expla...

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

Draw entity relationship diagram, Draw entity relationship diagram for the ...

Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui

Explain physical and logical independence, Define Physical and Logical inde...

Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Speedup query processing, Speedup Query Processing: A query that includes d...

Speedup Query Processing: A query that includes data at various sites can be split into sub-queries. These sub- queries can be implemented in parallel by various sites. Such parall

Explain the uses of deadlock, Explain the uses of deadlock It will lea...

Explain the uses of deadlock It will lead to deadlock since this is the only place where incoming acknowledgements are processed. Without this code, sender will keep timing ou

What is the difference between serial and sequential files, What is the dif...

What is the difference between serial and sequential files? How searching is applied on both?    Ans: A serial file is one where the records have been stored in the order where

Write short note on events, Write short note on Events Events consist ...

Write short note on Events Events consist of inputs, interrupts, decisions and actions performed by any external device or users. Every event always has a sender and receiver.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd