User Account

All Pages

Draw a dependency diagram to show functional dependencies

Assignment Help Basic Computer Science
Reference no: EM13992481

Assessment item 3NormalisationValue:15%Due date:11-Sep-2015Return date:02-Oct-2015Submission method optionsAlternative submission method

Task

Table 1: GRADE REPORT relation

Student_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGrade
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.

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.

Marking criteria

The marking criteria for this assignment are shown below:

Task HD DI CR PS
Draw a dependency diagram to show the functional dependencies in the relation The dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependencies The dependency diagram accurately identifies and correctly shows all PKs and most functional, partial, and transitive dependencies The dependency diagram identifies and shows most PKs and some functional, partial, and transitive dependencies The dependency diagram identifies and shows few PKs and few functional, partial, and transitive dependencies
Decompose GRADE REPORT into a set of 3NF relations The set of 3NF relations accurately identifies and correctly shows all PKs and all the relevant attributes The set of 3NF relations accurately identifies and correctly shows all PKs and most of the relevant attributes The set of 3NF relations identifies and shows most PKs and some of the relevant attributes The set of 3NF relations identifies and shows few PKs and few of the relevant attributes
Draw a relational schema for your 3NF relations and show the referential integrity constraints The relational schema accurately identifies and correctly shows all of the referential integrity constraints The relational schema accurately identifies and correctly shows most of the referential integrity constraints The relational schema identifies and shows some of the referential integrity constraints The relational schema identifies and shows few of the referential integrity constraints

 

Reference no: EM13992481

Questions Cloud

Finding the process of making decision : a) Draw both decision trees and show the process of making this decision, including your calculations. b) Which offer should you accept, if any?
What are some of the various groups discussed : What are some of the various groups discussed in our readings for this week? What groups have you been a part of? What is a bureaucracy and why do they often get labeled as inefficient
Compute the voltage drops across the resistor and capacitor : Compute the charge on the capacitor just before the switch is thrown from position 2 back to position 1. Compute the voltage drops across the resistor and across the capacitor at the instant described in part (a).
Determine the work and the heat transfer in the process : A piston/cylinder arrangement contains water of quality x = 0.7 in the initial volume of 0.1 m3, where the piston applies a constant pressure of 200 kPa. The system is now heated to a final temperature of 200°C. Determine the work and the heat tr..
Draw a dependency diagram to show functional dependencies : 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.
Operate business solutions : After the success of the company's first two months, Santana Rey continues to operate Business Solutions. The November 30, 2015, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2015) follows.
Describe what fraud is and how it could be conducted : In conversations with PVSS, you have talked about the long-term strategic goals and plans for expansion.
What was snos ositionin strate : Identify, describe and define the marketing terms of consumers - Write a consumer profile of the target segments.
Estimate the percentage of an employee salary : Estimate the percentage of an employee's salary that must be contributed to the pension plan if it is to remain solvent. (Hint: Do all calculations in real rather than nominal dollars.)

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Design concept in terms of the usability of the design

A justification for the design concept in terms of the usability of the design. You should explain why your decisions make sense and why your interface concept works for the application. Any preliminary designs can be included as an Appendix to th..

  Explaining resulting scheme is not ind-cpa-secure

Let a variant of CBC-mode encryption where sender simply increments the IV by 1 each time a message is encrypted. Illustrate that resulting scheme is not IND-CPA-secure.

  Write a program that inputs an integer for n

Write a program that inputs an integer for n, iterates through the Babylonian algorithm twenty times, and outputs the answer as a double to two decimal places. Your answer will be most accurate for small values of n.

  Describe the general tree adt

Describe the General Tree ADT. Discuss different ways for implementing general trees, and compare them in terms of the efficiency of search operations.

  What is the difference between inputstream and filereader

WHat is the difference between InputStream and FileReader?

  Know the industry in which a company operates

Getting to know the industry in which a company operates is a critical factor for leveraging information systems and gaining a competitive advantage.

  Difference between value type and reference type

Difference between value type and reference type arguments in c#

  You have 10 stacks of coins

You have 10 stacks of coins, each consisting of 10 quarters. One entire stack is counterfeit, but you do not know which one. You do know the weight of a genuine quarter and you are also told that each counterfeit quarter weights one gram more than it..

  Use of authentication types techniques impact security

Explain how the use of authentication types techniques impact security

  Design a 3-bit non-binary counter

Design a 3-bit non-binary counter that will count in the sequence 000, 010, 011, 101, 110, 111 when the input signal X = 0, clockwise rotation. If input signal X = 1 it reverses the direction, counterclockwise

  Drawing decision table for type of treatment of customer

Draw a decision table to represent the type of treatment to be given to a customer of the EyeTunes Music Club.

  Program which implements josephus problem

Use a circular list to implement the Josephus Problem.  In the Josephus Problem, there is originally a circle of people numbered from one to n.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd