Test Your Knowledge On Normal Forms

1. A procedure that transforms an un-normalised schema into a normalised one is known as _____ a) normal form b) normalisation c) redundancy d) insertion

2. A database that is not _____ can include data that is contained in one or more different tables for no apparent reason. a) efficient b) secured c) normalised d) updated

3. The aim of the database system is to reduce _____ of information. a) insertion b) repetition c) details d) deletion

4. The notion of functional dependency generalises the notion of ______ a) super key b) corresponding change c) dependency d) facts

5. A relational database is made up of a number of ____ a) relations only b) corresponding relational database schema c) options a and b d) none of the above

6. ______ is an identifier for a record in a table. a) file b) field c) primary key d) index