Purchase Solution

Drawing a Dependence Diagram

Not what you're looking for?

Ask Custom Question

Using Microsoft Word, complete the following:

The following table shows a table called Grade Report for a university. The existing functional dependencies are described as follows:

Student_ID -> Student_Name, Major
Course_ID -> Course_Title, Instructor_Name, Instructor_Location
Student_ID, Course_ID -> Grade
Instructor_Name -> Instructor_Location
Deliverable:

Draw a dependence diagram. There are examples in the reading assignments of dependence diagrams.
In what normal form is this table? Explain why.
Decompose the table into a set of 3NF tables. Describe the process to decompose the table.
Draw an ER diagram based on the decomposed tables (in Chen model).
Table: Grade Report

Student_ID
Student_ Name
Major
Course_ID
Course_Title
Instructor_Name
Instructor_Location
Grade

168300458
Williams
IT
ITD320
Database Imp
Codd
B104
A

168300458
Williams
IT
ITP310
Programming
Parsons
B317
B

543291073
Baker
Acctg
ITD320
Database Imp
Codd
B104
C

543291073
Baker
Acctg
Acct201
Fund Acctg
Miller
H310
B

543291073
Baker
Acctg
Mktg300
Intro Mktg
Bennett
B212
A

These shown Dependencies have been included in a .jpeg file for better order.

Attachments
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Networking Questions

This quiz consists of some basic networking questions.

C# variables and classes

This quiz contains questions about C# classes and variables.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

View More Free Quizzes
Related BrainMass Solutions

  • Dependence diagram

    270333 Dependence Diagram The following table shows a table called Grade Report for a university.

  • dependence diagrams

    dependence diagram.

  • Drawing Venn Diagram for Gas Well Completions

    NOTE: You can use the drawing commands in Microsoft Excel to draw the Venn diagram. You can also make the diagrams rectangles instead of circles if that is easier. Please explain how to draw a Venn diagram.

  • Probability questions with cards, Tree diagrams vs Tables

    Note that drawing a face card and drawing an ace are mutually exclusive events.

  • CPM: Network diagram

    Draw the network Hi the attached word file contains the network diagram. Regards Drawing a network diagram for given set of activities.

  • Euler diagram and argument

    194496 Euler diagram and argument Some artists like drawing Some artists like painting _____________________________ Therefore, some artists who like drawing like painting Is this argument valid or invalid ? The argument is invalid.

  • Solvolysis of t-butylchloride by aqueous acetone

    determining step. 5) Drawing another energy diagram for this reaction with a solid line representing the original reaction and a dashed line representing the reaction with t-butyliodide instead of t-butylchloride.

  • Develop database tables using a relational database system

    Drawing a dependency diagram.

  • Circuit analysis problem

    Which curve could represent the time dependence of current through the capacitor? b. Current through a resistor has the time dependence which looks like curve g. Which curve could represent the time dependence of voltage across the resistor?

View More Related Solutions