Tutorial 2 - Tutorial 2 1. A bank's system analyst has...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Tutorial 2 1. A bank’s system analyst has identified the data elements required to manage the Bank’s safe deposit system. The data elements are: BoxHolder First Name Last Name Address City State PostCode Phone Number Deputy BoxHolder Same as BoxHolder Box Box Number Box Size Length Height Depth Box Category Key Number Date Rented Design a normalised table for the safe deposit system. Provide a clear documentation and a discussion of your design demonstrating that it meets all the requirements for a good design. 2. What is the normal form of each of the following relations? a.) INVOICE(InvNo, TranNo , InvDate, VendorNo, TranCost) If
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
InvNo VendorNo InvNo InvDate InvNo ,TranNo TranCost b) CAR(CarNo , ModelID, ColourID, Price, OnHand) MODEL (ModelID , Model) COLOUR (ColourID , Colour) If CarNo ColourID CarNo ModelID CarNo Price CarNo Onhand ColourID Colour ModelID Model 3. Review the following relations and state the highest normal form of each with any
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Tutorial 2 - Tutorial 2 1. A bank's system analyst has...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online