Show the functional dependencies in the relation

Assignment Help Data Structure & Algorithms

Reference no: EM131798717

Task

Table : GRADE REPORT relation

Student_ID	Student_Name	Campus_Address	Major	Course_ID	Course_title	Instructor_Name	Instructor_Location	Grade
16830058	Williams	Albury	BIT	ITC114	Database Sys	Peter	B104	HD
16830058	Williams	Albury	BIT	ITC211	Sys Analysis	John	B115	D
543291073	Baker	Wagga	Acct	ITC200	Database Mgt	David	H310	D
543291073	Baker	Wagga	Acct	Acc11	Fund Acct	William	A120	C
543291073	Baker	Wagga	Acct	Mkg21	Intro Mkt	Mike	A112	P

Using above table

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

2. Decompose the GRADE REPORT 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, watch this very short YouTube video.

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

Rationale

This assessment aligns with the following subject outcomes:be able to critically analyse a database design and apply normalisation theory and techniques;

Reference no: EM131798717

Questions Cloud

Problem on emissions with us department of energy : Emissions with U.S. Department of Energy data for selected years from 2000 and projected to 2030, sulphur dioxide emissions from electricity generation.

Sample correlation coefficients to confirm : Which explanatory variables are likely to be collinear? Find their sample correlation coefficients to confirm.

Write a program to store information on vehicle owners : This type should be used in the program to store information on vehicle owners. The information we need in this situation is the owner's name and age.

Healthy food on the incidence of smoking : E A nutritionist wants to understand the influence of income and healthy food on the incidence of smoking. He collects 2009 data on the percentage of smokers.

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

Appropriate numerical measure : Consider the following 10 observations on the response variable y and the explanatory variable x.

Complete the payroll register : Complete the Payroll register below and Prepare the journal entries to accrue the payroll and record employer payroll taxes expense

Can you find the sum of its elements : The first line contains an integer, , denoting the size of the array. The second line contains space-separated integers representing the array's elements.

Estimate a quadratic regression model : a. Estimate a quadratic regression model where the GPA of middle school children is regressed on hours and hourssquared.

User Account

All Pages