What is the highest normal form r is in

Assignment Help Database Management System

Reference no: EM13191104

Question 1:

Research the definition of a "minimal cover". Explain it in your own words and give an example.

Question 2:

Consider the following relation R with sample data where names are unique:

MOTHER	CHILD	GIFT	DATE	OCCASION
Linda	Jim	Bike	1-20-2009	Birthday
Linda	Jim	Sweater	12-25-2008	Christmas
Linda	Jim	CD	3-8-2007	Grade Report
Linda	Mary	Game	12-25-2008	Christmas
Linda	Mary	Book	2-20-2006	Birthday
Susan	David	CD	7-20-2009	Birthday
Susan	David	Shoes	8-30-2009	Back to School

1- What functional dependencies can you conclude from the data above?

2- What is the highest normal form R is in?

3- If R is not in BCNF, then decompose R to become in BCNF and show that all functional dependencies still hold.

Reference no: EM13191104

Questions Cloud

Describe the research of two ethical approaches : research two ethical approaches: virtue ethics (value) and deontology (principle) and apply these theoretical perspectives to ethical dilemma that leaders and/or managers at ECG (Expert Consulting Group) may encounter when providing consulting ser..

Define information calculate the molar volume at stp : The density of the hydrogen peroxide solution is 1.01 g/mL and the solution contains 3.40% H202 by mass. The vapor pressure of water at 24C is 22 mmHg. Based on this data and information calculate the molar volume at STP.

Mean number of degrees awarded by u.s. department : The U.S. Department of Education reported the following number of bachelor's degrees awarded now what is the annual arithmetic mean number of degrees awarded?

What are the opportunity costs of the decisions : Gourmet coffee houses tend to open in high-rent areas and cater to higher income consumers. Because of the change they created for taste and preferences and the higher income market, the gourmet coffee houses had a win-win in a period of falling w..

What is the highest normal form r is in : What functional dependencies can you conclude from the data above and what is the highest normal form R is in?

Define partial derivatives for a diatomic ideal gas : Obtain expressions for the following partial derivatives for a diatomic ideal gas, assuming that its translational, rotational, and vibrational motions all behave classically.

Where gourmet coffee houses tend to open : Because of the change they created for taste and preferences and the higher income market, the gourmet coffee houses had a win-win in a period of falling wholesale prices and increasing retail prices

Relation schema about teaching classes : Suppose you have a relation schema about teaching classes that has the following attributes: Class, Instructor, Time and Room

How will the firms optimal input choice change : What are the current prices of capital and labor, based on the graph b. Suppose that the price of labor increases, if the firms wishes to continue to produce the current level of output how will the firms optimal input choice change

User Account

All Pages