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

Illustration of implementation of inheritance, Illustration of implementati...

Illustration of implementation of inheritance Let us take the illustration of implementation of inheritance. Suppose that we are about to implement the Stack class and by now w

Define weak and strong entity sets, Define weak and strong entity sets?  ...

Define weak and strong entity sets?  Weak entity  set:  entity  set  that  do not  have  key  attribute  of  their  own are  known as weak entity sets.  Strong entity set

What are the physical characteristics of magnetic disks, What are the physi...

What are the physical characteristics of magnetic disks?   Ans: A magnetic disk is a circular plate or platter of plastic or metal that is coated with magnetizable material lik

In the architecture of a database system which external leve, In the archit...

In the architecture of a database system which external level used? In the architecture of a database system view external level used.

What are audit trails, What are audit trails? An audit trail is a log o...

What are audit trails? An audit trail is a log of all alters to the database along with information like which user performed the change and when the alter was performed.

Define null values, Define null values. In some cases a certain entity ...

Define null values. In some cases a certain entity may not have an applicable value for an attribute or if we do not know the value of an attribute for a certain entity. In the

What are the types of indices, Normal 0 false false false ...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Architectural standard, Architectural standard: Designation : Archit...

Architectural standard: Designation : Architect , Consultant Job Profile : As a part of Oracle Fusion Middleware at Satyam, I am involved with Presales, Delivery, A

boyce codd normal form relations, Create centralized relational database u...

Create centralized relational database using bottom up method.   (a) Recognize a single un-normalized relation for the above scenario.          (b) Recognize the primary key for

List the data structures implemented by the storage manager, List the data ...

List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices

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