Draw a dependency diagram to show functional dependencies

Assignment Help Database Management System

Reference no: EM131471904

Assignment: Modelling & Normalisation

Task

Normalisation

Using the given table/relation, do the following:

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

2. Decompose the following table into a set of 3NF relations

3. Draw a relational schema for your 3NF relations and show the referential integrity constraints. Manually drawing the dependency diagrams is not acceptable.

Trainer_ID	Trainer_Name	Room_No	Room_Seats	Class_Session	Class_Name	Class_Day	School
101	Alana Fredrick	54A	36	9:00	ITC114	Mon	Computing
102	George Edwards	22	28	9:00	ITC333	Mon	Computing
103	Lilly Nelly	59	38	12:30	BUS350	Tues	Business
104	Eddy Brown	53	30	12:30	ITC114	Thurs	Computing
102	George Edwards	59	38	4:00	ITC504	Fri	Computing
103	Lilly Nelly	18	24	12:30	BUS360	Wedn	Business
102	George Edwards	53	30	9:00	ITC201	Wedn	Computing
105	Sam Wang	22	28	4:00	ITC556	Tues	Computing
106	Yifeng Chong	58	38	9:00	ITC556	Thurs	Computing

Reference no: EM131471904

Questions Cloud

How might the company use secondary research : Briefly describe your company. Identify potential problems or issues (current or future) that your company might address with a research study.

Planning process within the context of leadership : Explain the planning process within the context of leadership. Explain the decision-making processes used by health organizations.

Were warranties properly excluded : By means of long-distance telephone conversations, Ace, Inc. agreed to buy an airplane from Unified Technologies of Texas, Inc. subject to a test flight.

What need did the development of negotiable instruments meet : What need did the development of negotiable instruments meet? Is the law exactly the same in all states that have adopted Article 3 of the UCC? Explain.

Draw a dependency diagram to show functional dependencies : Draw a dependency diagram to show the functional dependencies in the relation. Decompose the following table into a set of 3NF relations.

What is a human resource plan : What is a human resource plan? Which enterprise environmental factors influence the development of a human resource plan?

What does it mean for a drawee to accept a draft : To whom may order paper and bearer paper be paid? What does it mean for a promissory note to be a demand instrument?

Research a real-life case of sponsorship failure : Research a real-life case of sponsorship failure in the sports business industry. Include links to the related research along with a summary.

Marketing and communication techniques for health care : When selecting marketing and communication techniques, health care organizations must carefully examine their consumer populations

User Account

All Pages