Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

Engineering


Home >> Computer Engineering

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

 

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M91701326
  • Price:- $20

Priced at Now at $20, Verified Solution

Have any Question?


Related Questions in Computer Engineering

The switch statementhere is the question in its entirety

The switch statement Here is the question in its entirety, but the actual problem is at the end. I just felt that I would give an overview of what I am asking. The program has to be in c++ (.cpp) and must compile as such ...

Question suppose you are given two stacked s and twrite an

Question : Suppose you are given two stacked S and T. Write an algorithm to transfer all elements from S to T so that the top of S is the first to be inserted onto T, and the bottom of S ends up at the top of T.

You have 2 tasks to createer-modeling in ms visio simple

You have 2 tasks to createER-Modeling in MS visio. Simple jab for the database expert that would take him 30 min to finish. My requirement not only for the expert to get the task done. I need to do it myself. Then he cor ...

The local police department must write an average of 5

The local police department must write an average of 5 traffic tickets each day to keep department revenues at budgeted levels. Suppose the number of tickets written per day follows a Poisson distribution with a mean of ...

Risky business how can us companies protect their digital

Risky Business: How Can U.S. Companies Protect their Digital Assets Overseas? Prepare a 3 to 5 paragraph briefing statement that can be used to answer the above question. Your audience will be attendees at a conference f ...

Represent each of the following values in the ieee 754

Represent each of the following values in the IEEE 754 32-bit format, truncating inexact values. Indicate the percent error of the value stored compared to the exact value. This will require you to convert the 32 bit flo ...

Question some help me to answer this1 discuss the osi

Question: Some help me to answer this 1. Discuss the OSI reference model and TCP/IP model. discuss in details their features, advantages and disadvantages 2. Compare and contrast the two models. The response must be type ...

What are the assumptions of linear regression analysis and

What are the assumptions of linear regression analysis and ,How do we interpret the regression coefficients ,can u give a real life example of how linear regression is used in statistical research

What is a domain name in the context of internet what is

What is a domain name in the context of Internet? What is the procedure to get a domain name and link it to an Internet Protocol (IP) address? Use an example.

Each student will create classes methods and design icons

Each student will create classes, methods, and design icons for their mobile device application using OOP language and GUI. The following must be included. Your instructor may add additional requirements, if any, in a se ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved