Explain the four parts of ACID? (Atomicity, Consistency, Isolation, Durability)

(10 marks)

Normalise the following table to BCNF and create a logical ERD diagram of it

(15 marks)

Compare and contrast XML and HTML (5 marks)

List and explain five advantages and five disadvantages of the Database Management Systems. (10 marks)

\begin{tabular}{|l|l|l|l|l|} \hline StudentNo & StudentName & CourseName & Teacher & TeachersOffice \\ \hline 02356 & Scott Fowler & Poetry & Martyn & 12B \\ \hline 02356 & Scott Fower & Prose & Porfirio & 12B \\ \hline 02111 & Rob Lowe & Poetry & Martyn & 12B \\ \hline 02356 & Scott Fowler & History & Ricksen & 25C \\ \hline \end{tabular}