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 the purposes of dbms in details

Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap

What Command You Use What Day of the week were you born

What is NULL? Give an example to described testing for NULL in SQL? The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a re

What are the aggregate objects in the data dictionary? Views Match codes Lock objects.

What are the different integrity constraints in RDBMS? The various integrity constraints in RDBMS are as: Primary Key: primary key is a grouping of one or more attributes

Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

Explain Alternate key? Alternate Key - All the candidate keys except primary key are known as alternate keys.

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.