Example of ancestry database , Database Management System

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

Posted Date: 2/22/2013 1:00:56 AM | Location : United States







Related Discussions:- Example of ancestry database , Assignment Help, Ask Question on Example of ancestry database , Get Answer, Expert's Help, Example of ancestry database Discussions

Write discussion on Example of ancestry database
Your posts are moderated
Related Questions
The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

project on dbms

Write short notes on extension and intension? In any data model, it is significant to distinguish among the description of the database and the database itself the description


Project Description: We have purchased facebook style chat software which we are using with our site. It is prepared in PHP but the rest of the site is developed asp.net. Iss

how to prepare a data dictionary for online examination system for certified courses?


Explain the two types of participation constraint. 1. Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates i

read-set(T) : Each data items that are read by a transaction T Timestamps : for all transaction T, the start-time and the end time are reserved for all the three phases.