Draw a relational schema for your 3nf relations

Assignment Help Database Management System

Reference no: EM132369672

Assignment

Task			Subject Outline
Meeting	Meeting	Meeting	Meeting	Meeting	User	Rating	User	User
ID	Date	Time	Venue	ID	ID		ID	Availability
1	24/1/2019	11:40 am	Library	1	IA	3	KC	Yes
1	24/1/2019	11:40 a	Library	1	DD	4	YA	No
1	24/1/2019	11:40 a	Library	1	KC	2	DD	Yes
2	25/1/2019	10:30 am	Trail St	2	IA	5	IA	Yes
2	25/1/2019	10:30 am	Trail St	2	DD	4	AK	Yes
2	25/1/2019	10:30 am	Trail St	2	KC	2
2	25/1/2019	10:30 am	Trail St	2	AK	3
3	26/1/2019	9:00 am	Blessed	3	DD	3
			Bean
3	26/1/2019	9:00 am	Blessed	3	IA	2
			Bean

Using above table

1. Draw a dependency diagram to show the functional dependencies in the relation

2. Decompose the relation into a set of 3NF relations

3. Draw a relational schema for your 3NF relations and show the referential integrity constraints

NOTE

For guidance on how to normalise database relations from a dependency diagram.

Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

Reference no: EM132369672

Questions Cloud

Review the analysis of the healthcare issue : Review the national healthcare issue/stressor you examined in your Assignment for Module 1, and review the analysis of the healthcare issue/stressor.

Identifying the proponents-opponents of the bill : NURS6050 - Many nurses encounter daily experiences that motivate them to take on an advocacy role in hopes of impacting policies, laws, or regulations.

Describe improvement to existing service : Describe improvement to an existing service, different to one you used in Assignment. For this second assignment you should identify significant service gap.

Compute the returns and coefficient of risk variation : Analyze the risk and return patterns and diversification benefits.What are the advantages and disadvantages of including international stocks in the portfolio

Draw a relational schema for your 3nf relations : Draw a dependency diagram to show the functional dependencies in the relation. Decompose the relation into a set of 3NF relations.

Effects of globalization on strategic management planning : Evaluate the effects of globalization on strategic management planning. Identify three Organizational Structures best suited for optimal global operations.

Present-past company view on corporate social responsibility : Research your present or past company's view on corporate social responsibility. Comment on their effectiveness to community and organization and the company.

Describe the effect of new generation therapies : Write a 350- to 700-word analysis of the summaries to describe the effect of new generation therapies on the field of counseling.

Would you discuss a possible diagnosis with carl : Explain how using the cross-cutting measure would add to the information gathered. Would you discuss a possible diagnosis with Carl at time point in time? Why?

User Account

All Pages