To keep track of office furniture, computers, printers, and so on, the CSU DIT uses the table...

Question

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 1Sample ITEM Records

Attribute Name	Sample Value	Sample Value	Sample Value
ITEM_ID	XXXXXXXXXX	XXXXXXXXXX	XXXXXXXXXX
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. 5 Marks

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

c. Draw the Crow’s Foot ERD.5 Marks

NOTE

For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.youtube.com/watch?v=vkUyuLLgmwQ

Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

Rationale

back to top

This assessment task will assess the following learning outcome/s:

be able to apply normalisation techniques to optimise a database design.

Marking criteria and standards

back to top

The marking criteria for this assignment is:

Criteria

HD

DI

CR

PS

be able to apply normalisation techniques to optimise a database design.

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.

Analysis identifies PKs and functional, partial and transitive dependencies with minor omissions. Accurately identifies 3NF relations, including PKs, relevant attributes and referential integrity constraints with minor omissions.

Creates an ERD that represents identified 3NF relations and includes all entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities.

Analysis identifies key PKs and functional, partial and transitive dependencies. Identifies key 3NF relations, including PKs and relevant attributes and referential integrity constraints.

Creates an ERD that represents identified 3NF relations and includes the related entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities.

Analysis identifies key PKs and functional dependencies and draws out relevant 3NF relations.

Creates an ERD that represents identified 3NF relations and includes the related entities, PKs, attributes, relationships, cardinalities and optionalities with minor errors.

Requirements

back to top

Either save yourdiagrams in aPDF file or embedthem in a Word document.

Don't use any other file formats

Please include your student ID, name and subject code inyour submission.

Ankit · Accepted Answer

Student_Id
				Student_Name
				Title of Assignment
· The dependency diagram
ITEM_ID is primary key
· Modify the dependency diagrams that meet 3NF requirements.

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 1Sample ITEM Records...

Rationale

Marking criteria and standards

Requirements

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment