Tutorial 2Ans - Tutorial 2 Answers Q1 : There is more than...

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

View Full Document Right Arrow Icon
Tutorial 2 Answers Q1 : There is more than one solution for this question. In general, the solution is as follows: The Tables: BOXHOLDER BOX BOX HISTORY BOX HOLDER IC No ( Or BoxHolderNo.) First Name Last Name Address City State PostCode Phone Number BOX Box Number Length Height Depth Box Category Key Number BOX HISTORY Box Number BoxHolderNo Alternate Box HolderNo. Date Rented Q2 : a) This relation is in 1NF. There are two nonkey fields, VendorNo and InvDate that are dependent on only part of the key, InvNo. There are not dependent on the second key, TranNo. To move this relation into 2NF, it is necessary to divide it into two relations, each of which satisfies the dependency requirements. b) This set of relation is in 3NF, because they conform to the definition of that form. That is, each nonkey field is functionally dependent on the whole key and there are no transitive dependencies.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Q3 : a JOB1(EmpNo , EmpName, Job_Title, Date_Hired) Assuming that EmpName is not unique. So EmpNo is the primary key. The relation is in
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.

This note was uploaded on 02/06/2012 for the course FACULTY OF WXGE6320 taught by Professor Noraini during the Winter '09 term at University of Malaya.

Page1 / 4

Tutorial 2Ans - Tutorial 2 Answers Q1 : There is more than...

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