a) Briefly discuss each of the following terms: i) Database Management System ii) Query iii) Integrity...

Transcribed Image Text:

a) Briefly discuss each of the following terms: i) Database Management System ii) Query iii) Integrity iv) Views (2 marks) (2 marks) (2 marks) (2 marks) b) Discuss the differences between the candidate keys and the primary key of a relation. (4 marks) c) A list of steps to be followed when developing a database system might include the following: i) System definition ii) Requirement collection and analysis iii) Database design iv) DBMS Selection v) Application Design Give a brief explanation of each of the SIX steps listed above. d) Describe the main characteristics of the following: i) File based systems marks) ii) Database approach e) Discuss the disadvantages of file-based systems. a) Briefly discuss each of the following terms: i) Database Management System ii) Query iii) Integrity iv) Views (2 marks) (2 marks) (2 marks) (2 marks) b) Discuss the differences between the candidate keys and the primary key of a relation. (4 marks) c) A list of steps to be followed when developing a database system might include the following: i) System definition ii) Requirement collection and analysis iii) Database design iv) DBMS Selection v) Application Design Give a brief explanation of each of the SIX steps listed above. d) Describe the main characteristics of the following: i) File based systems marks) ii) Database approach e) Discuss the disadvantages of file-based systems.