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
What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d

(a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh

what is attribute is attribute inheritance in dbms?

What Is Sql?  Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition. All the re

Explain the Static or conservative Two Phase Locking: Static (or conservative) Two Phase Locking: In this type of scheme, all the data items are locked earlier than any opera

Illustrate the collaboration and relationship diagram A collaboration is the society of interfaces, classes and other elements which work together to provide some cooperative b

create an e-r diagram usuing graphical dipicted software that could theoritically be used in resturant application

What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base

Question: (a) What do you meant by content management and briefly describe four major components of a Content Management System? (b) Explain key benefits of a Content Manage