List the functional dependencies and create a database

Assignment Help Database Management System

Reference no: EM131324533

Database In-class Assignment Normalization

For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF.

Movie	Rating	Showtime	Theater
The SpongeBob Movie	PG	4:00	1
The SpongeBob Movie	PG	7:00	1,2
Focus	R	4:00	3,4
Focus	R	7:00	3,4,5
Focus	R	10:00	1
Kingsman: The Secret Service	R	7:00	6
Kingsman: The Secret Service	R	10:00	6
McFarland, USA	PG	3:00	7
McFarland, USA	PG	7:00	7,8
McFarland, USA	PG	7:30	9
Hot Tub Time Machine 2	R	7:00	11
Hot Tub Time Machine 2	R	9:00	2
Jupiter Ascending	PG-13	7:00	12

Hints: In this case, it might be best to first check in the table is in 1NF, and then put the table into 1NF before trying to list the functional dependencies. To find the functional dependencies, ask yourself, if I know a value in this column (or these columns) do I logically know the values in the other columns (examples: If I know the movie, would I always know the rating? If I knew the Theater and the Movie would I know the Showtime?, etc.). There are two functional dependencies.

You may complete this assignment in Word, Excel, PowerPoint, or on Paper and email a picture of the completed assignment (as long as it is a standard, readable file format).

Reference no: EM131324533

Questions Cloud

How buddhist beliefs and practices received in east aisa : How were Buddhist beliefs and practices received in East Aisa and how did they change over time? What was the "silk road" and how did it affect the economy and culture of China in the Tang dynasty

What is the short-run price elasticity of supply : If these salaries are expected to remain high, will more people enter doctoral programs in economics? How would such entry affect the longrun price elasticity of supply? V

Escape the proofreading and repair process : What percentage of the DNA changes that occur and one cell in one year escape the proofreading and repair process calculate this in both cases: if one mutation accumulates in one sale per year and if five mutations accumulate in one sale per year?

Thesis on the significance of current role of us military : Write a thesis statement that is one to two (1-2) sentences long in which you state your thesis on the significance of the current role of U.S. military, as exemplified in the two (2) real-life international incidents that you have researched. J..

List the functional dependencies and create a database : For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF.

World events that could impact the businesses : Include any relevant current event information, news that has affected financial statements, or world events that could impact the businesses. Ratios and Discussion - List what ratios you think are relevant to your companies and industry. In one to t..

Disposal for conservation biology product : Imagine that you had 1/1000 of the worlds gross domestic product available at your disposal for conservation biology product? Is it a sound conservation decision to protect just 4% of the earth's living habitat? Why or why not? What other decision..

Issues surrounding the first time adoption : For each of the following topics, please describe how it would be handled with both sets of standards, and provide a minimum of 2 examples of issues surrounding the first time adoption of IFRS:

Presence of air bubbles a sign of contamination : 1. For what specific purpose was gram staining developed for? what is it used for today? 2. Why is the presence of air bubbles a sign of contamination? 3. Why is a gram stain helpful when monitoring bacterial contamination in food or investigating a ..

User Account

All Pages