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 aggregate functions? And list the aggregate functions supported by SQL? Aggregate functions are functions that take a collection of values as input and return a one va

Home based assignment Consider an ORDER table with the following attributes: • Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quant

Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

Relationship between Security and Integrity: Database security usually refers to access, while database integrity refers to avoidance of accidental loss of consistency. But usually


What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

Concurrency Identification While designing analysis, model we map real world model into our analytical model. Real life objects are simultaneous in nature, but all the design

Explain Network Model in DBMS? Network Model - It was formalised within the late year of 1960s through the Database Task Group of the Conference on Data System Language (DBTG


1. Explain different addressing modes of 8086 Explanation of all addressing modes 2. Write a sequence of instructions to exchange two register contents using stack