100%(2)2 out of 2 people found this document helpful
This preview shows page 1 - 2 out of 4 pages.
T1 2019: ICT200 Database andDevelopment Tutorial 4Topic:Week 4 Relational Model and NormalizationSubmission:Five minutes before the end of the tutorial: all files must be uploaded on Moodle.Questions1. Explain the intuitive meaning of the functional dependencyPart 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 key4. What conditions are required for a relation to be in BCNF?