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.

Amit · Accepted Answer

36218/ITC556.docx
Title of the assignment: Normalization 
Student’s name:
Professor’s name:
Course title: ITC 556 (Assignment – 3)
Date:
Table of Contents
1)	Dependency diagram (DD) in 1NF	3
2)	Dependency diagram (DD) in 3NF	3
3)	ERD for 3NF data tables	4
4)	References:	5
1) Dependency diagram (DD) in 1NF
The under mentioned dependency diagram shows the identified dependencies in the provided table representing 1NF: 
2) Dependency diagram (DD) in 3NF 
The under mentioned dependency diagram shows the removed dependencies in the provided table representing 3NF: 
3) ERD for 3NF data tables  
The under mentioned entity relationship diagram shows the removed dependencies in the provided table representing 3NF: 
4) References: 
Lum, V., Dadam, P., Erbe, R., Guenauer, J., Pistor, P., Walch, G., ... & Woodfill, J. (1987). Design of an integrated DBMS to support advanced applications. In Foundations of Data Organization (pp. 31-49). Springer, Boston, MA.
Pinciroli, F., Combi, C., & Pozzi, G. (1992). Object-orientated DBMS techniques for time-orientated medical record. Medical informatics, 17(4), 231-241.
Westland, J. C. (1992). Economic incentives for database normalization. Information processing & management, 28(5), 647-662.
Page 
36218/ITC556_1.png
36218/ITC556_1.

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