bibas week 4.docx - T1 2019 ICT200 Database and Development Tutorial 4 Topic:Week 4 Relational Model and Normalization Submission:Five minutes before

bibas week 4.docx - T1 2019 ICT200 Database and Development...

This preview shows page 1 - 2 out of 4 pages.

T1 2019: ICT200 Database and Development Tutorial 4 Topic:Week 4 Relational Model and Normalization Submission:Five minutes before the end of the tutorial: all files must be uploaded on Moodle. Questions 1. Explain the intuitive meaning of the functional dependency Part Number -> Part Weight Part Weight is fully dependent on part Number. 2. What conditions are required for a relation to be in 2NF? The relation must be in 1NF, All attributes are dependent on the full primary key No non key column is dependent on only a portion of the primary key Each non-key attribute is fully functionally dependent on the primary key. 3. What conditions are required for a relation to be in 3NF? The relation must be in 2NF Each non-key attribute is dependent on the primary key and only on the primary key. All attributes are non-transitively dependent on the primary key 4. What conditions are required for a relation to be in BCNF?
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture