Solution-Decompose grade report into a set of 3nf relations

Decompose grade report into a set of 3nf relations

Assignment Help Database Management System

Reference no: EM13904720

Table 1: GRADE REPORT relation above

Table 1: 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

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

2. Decompose GRADE REPORT into a set of 3NF relations

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

NOTE

Manually drawing the dependency diagram or the relational schema is NOT acceptable.

Rationale

1. This assessment item is designed to test your understanding of more advanced database design, your ability to use an iterative approach to modelling, and to examine data problems due to redundancy.

2. Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.

Reference no: EM13904720

Questions Cloud

High-involvement strategies for improving human resource : In your opinion what are “high-involvement” strategies for improving human resource management in organizations? Why? Provide specific examples.

Write a balanced equation using the correct formulas : Write a balanced equation using the correct formulas and include conditions ( s, l, g, or aq) for each of the following reactions- Solid calcium carbonate decomposes to produce solid calcium oxide and carbon dioxide gas:

Find probability of no units in the system : In a waiting line situation, arrivals occur at a rate of 2 per minute, and the service times average 18 seconds. Assume the Poisson and exponential distributions. Find probability of no units in the system. Find average number of units in the system...

Compute the macaulay duration of bond for integer values : Berkshire Hathaway is contemplating the issue of a very unusual bond. Known as a “Bizarro Bond,” the security will provide an annual coupon payment of $50. The yield to maturity on the bond is 4 percent and the maturity value of the bond is the stand..

Decompose grade report into a set of 3nf relations : Draw a dependency diagram to show the functional dependencies in the relation and decompose GRADE REPORT into a set of 3NF relations.

Movement of the nominal interest rate : Use terms for direction and timing to characterize the movement of the nominal interest rate over the macroeconomic cycle. Detail you explanation by reference to the Keynesian transmission mechanism.

Maynard keynes concept of effective demand : Explain John Maynard Keynes's concept of effective demand. How is the employment of labor explained in this theory? How does this explanation differ from the neoclassical interpretation of the labor market?

Thorstein veblen theory of consumption : Explain Thorstein Veblen's theory of consumption. Is economic behavior, and consumption in particular, driven by utilitarian impulses or socio-cultural factors? What is the point of conspicuous consumption and conspicuous leisure?

Alfred marshall theory of a long run : Explain Alfred Marshall's theory of a long run (long period) competitive equilibrium (the theory still used to this day to explain the long-run outcome of perfectly competitive markets).

User Account

All Pages

Decompose grade report into a set of 3nf relations

Reference no: EM13904720

Reference no: EM13904720

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT