Draw the dependency diagram

Assignment Help Other Subject

Reference no: EM132211405

Assignment Task -

To keep track of office furniture, computers, printers, and so on, the CSU DIT uses the table structure shown in Table 1.

Please note that BLDG stands for building.

Table 1 - Sample ITEM Records

Attribute Name	Sample Value	Sample Value	Sample Value
ITEM_ID	231134-678	342245-225	254668-449
ITEM_LABEL	HP DeskJet 895Cse	HP Toner	DT Scanner
ROOM_NUMBER	325	325	123
BLDG_CODE	NTC	NTC	CSF
BLDG_NAME	Nottooclear	Nottoclear	Canseefar
BLDG_MANAGER	I.B. Rightonit	I.B. Rightonit	May B. Next

a. Given that information, draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies.

b. Modify the dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary.

c. Draw the Crow's Foot ERD.

Rationale - This assessment task will assess the following learning outcomes: be able to apply normalization techniques to optimise a database design.

Reference no: EM132211405

Questions Cloud

Write a program that reads a file from a standard input : Write a program that reads a file from a standard input and rewrites the file to standard output, replacing all tab characters.

Calculate the volume and surface area of a sphere : Write a program to read in a radius from the keyboard, and then calculate the volume and surface area of a sphere.

Write a program segement in assembly language : Write a program segement in assembly language to read 10 integer numbers and store them into a one dimensional array. The program should calculate.

Print the input file data to an output file : Write a program that reads an input file then print the input file data to an output file

Draw the dependency diagram : Assignment Task - Given that information, draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies

What price would the bonds sell : Dooley, Inc., has outstanding $100 million bonds that pay an annual coupon rate of interest of 11 percent. Par value of each bond is $1,000.

Calculate the payback period : McGilla Golf has decided to sell a new line of golf clubs. The clubs will sell for $875 per set and have a variable cost of $430 per set.

Discuss differences between the two professions : Discuss the similarities and the differences between the two professions in general terms. Examine the difference between internal and external auditing.

Calculate user weight on planets : Write a program that reads user weight (between 40 kg and 200 kg) and calculates user weight on planets.

Reviews

len2211405

1/9/2019 2:51:36 AM

NOTE - For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: How to normalise database relations in 3 quick steps? Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable. Analysis identifies all PKs and functional, partial and transitive dependencies. Accurately identifies all 3NF relations, including PKs, relevant attributes and referential integrity constraints. Creates an ERD that represents all 3NF relations and includes all entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Requirements - Either save your diagrams in a PDF file or embed them in a Word document. Don't use any other file formats. Please include your student ID, name and subject code in your submission.

Write a Review

Required(*) Message

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

User Account

All Pages