ITC556 Database Systems - Assessment 3 - Normalisation

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.   5 Marks

b.   Modify the dependency 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

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

  • be able to apply normalisation techniques to optimise a database design.
Order Now