Which of the following functional dependencies in the table FLIGHT is an

Which of the following functional dependencies in the

This preview shows page 5 - 8 out of 14 pages.

19) Which of the following functional dependencies in the table FLIGHT is an augmented functional dependency? A) FlightID, Date --> NoOfPassengersB) FlightID --> OriginC) FlightID --> DestinationD) FlightID, Date --> OriginAnswer: D Diff: 2 Page Ref: 97-99 20) What type of functional dependency does NOT exist in the table FLIGHT? D Diff: 3 Page Ref: 99-102 21) Table FLIGHT is: B Diff: 3 Page Ref: 105-109 22) Normalizing table FLIGHT to 3NF will result in: B Diff: 2 Page Ref: 105-109 5
Image of page 5
DOCTORObserve the table DOCTOR:DOCTORDoctorIDNameDateOfMDGraduationNumberOfPatients D111John1/1/1999100D222Tina1/2/2003117D333Ellen1/1/2001117D444Tina1/1/2003144This table will be used for the following questions citing table DOCTOR.23) What type of functional dependency exists in the table DOCTOR? A) TrivialB) PartialC) TransitiveD) All of the aboveAnswer: A Diff: 3 Page Ref: 99-102 24) Table DOCTOR is: D Diff: 3 Page Ref: 105-109 25) Normalizing table DOCTOR to 3NF will result in: A Diff: 2 Page Ref: 105-109 4.2 True/False Questions 1) Update operations are also referred to as readoperations. Diff: 1 Page Ref: 91 2) A nonkey column is a column in a relation that is not a primary or a candidate key column. Diff: 1 Page Ref: 95 6
Image of page 6
3) An insertion anomaly occurs when a user who wants to insert data about one real world entity is forced to enter a unique value about it. Diff: 1 Page Ref: 95 4) If A, B, C, and D are columns of the table whose composite primary key is A, Bwhile C and D are nonkey columnsthen B --> C is a partial functional dependency. Diff: 2 Page Ref: 101-102 5) If A, B, C, and D are columns of the table whose composite primary key is A, Bwhile C and D are nonkey columnsthen B --> D is a transitive functional dependency. Diff: 2 Page Ref: 101-102 6) If A, B, C, and D are columns of the table whose composite primary key is A, Bwhile C and D are nonkey columnsthen C --> D is a transitive functional dependency. Diff: 2 Page Ref: 101-102
Image of page 7
Image of page 8

You've reached the end of your free preview.

Want to read all 14 pages?

  • Spring '14
  • SWINARSKI,MATTHEW
  • Database normalization, Page Ref, 3NF, 2NF, 1NF

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture