Answer to Question #311103 in Databases | SQL | Oracle | MS Access for Teekay

Question

1.1 The table shown below stores details of students and the overall grade each student

obtained in different modules. The Primary Key is (StudentID, ModuleID). (8)

Results

StudentID StudentName ModuleID ModuleName Grade

S001 Smith M01 Java A

S001 Smith M02 Databases B

S002 Ford M01 Java 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.

(iii) Show how you would normalise the table.

1.2 An important concept in the theory of relational databases is that of a functional (8)

dependency.

(i) 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):

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order