Solution-Show the functional dependencies

Show the functional dependencies

Assignment Help Database Management System

Reference no: EM13828488

Question: I need your help in making my assignment. This assignment should be submitted to Turnitin as a MS Word document.

Your Dependancy Diagrams could be inserted as images into your MS Word document or drawn in MS Word. These are just the assignments.

you dont have to write lengthy pages.

Normalisation

Value: 15%

Submission method options

Alternative submission method

Task

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

Using Table 1: GRADE REPORT relation above

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.

Online submission via Turnitin is required for this assignment. Details will be provided by your subject lecturer.

Rationale

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.
Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.

Reference no: EM13828488

Questions Cloud

Company and effective utilization of resource : Investigate the degree to which human resources are related to the other factors (project management, product design, process strategy, location decisions, layout decisions, etc.).

Study about the current parking policy opposed by nurses : Study About The Current Parking Policy Opposed by Nurses

Important for human resource management systems : Discuss why it is important for human resource management systems to be in sync with an organization's strategy and goals and with each other

Dimensions of an organization vertical structure : What are the four [4] dimensions of an organization's vertical structure? Please define authority, span of control, delegation and centralization

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

Which features are of little or no interest to you : Questions such as "How often would you buy this product?" and "Which features are of little or no interest to you?" are often proposed during

Example of a project that was challenged by control issues : Monitoring and controlling a project is a core activity for a project manager. Provide an example of a project that was challenged by control issues and describe what caused the situation

What key situational variables will influence the dog owner : From the second e-Activity, speculate, from the U.S. Census market projections, what key situational variables will influence the dog owner target market. Provide two ideas of how premium pet product manufacturers can use this information in their..

Determine effectiveness of negative advertising campaigns : Analyze the attitude change strategies. Determine the effectiveness of negative advertising campaigns in regard to changing the components of attitude. Use examples to illustrate your point

User Account

All Pages

Show the functional dependencies

Reference no: EM13828488

Reference no: EM13828488

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