Answer Happy

QUESTION ONE (25 MARKS] 1.1 The table shown below stores details of students and the overall grade each student obtained in different modules. The Primary key is (Studenti, ModuleID). (8) Results StudentID S001 S001 SOO2 StudentName Smith Smith Ford ModuleID M01 MO2 M01 ModuleName Java Databases Java Grade A B B (i) Which Normal Form does the above table violate and why? (ii) Give an example of an update anomaly and an example of a delete anomaly that may occur if the table is left un-normalised. Explain the problems that are caused. (ii) Show how you would normalise the table.

(8) 1.2 An important concept in the theory of relational databases is that of a functional dependency. (1) Explain what is meant by a functional dependency and give an example. (ii) Identify two functional dependencies in the following table (A, B and C are the attributes): с ci A a1 al a1 Ford B b1 b1 b2 c3 c1

1.3 A company uses the table below to record details of staff. Each staff has up to three (8) qualifications: StaffID S01 SO2 SO3 StaffName Victor Wiseman Raymond Qualifications BSc, MSc, PhD Bsc, MSc Bsc, PhD (i) Explain why this table is not in "First Normal Form" (1NF). (ii) Show how this table can be transformed into 1NF tables. Give two possible solutions.