Assignment Task - Given that information, draw the

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.


solvedassignments.net Rated 4.8 / 5 based on 22789 reviews.
Captcha

Helping Students of Australia/New Zealand, GET Help with Classroom Assignments? Order Now