Download Database Design and Development Exam and more Exercises Art in PDF only on Docsity!
School of Computing and Information Systems PROGRAMME: BSC COMPUTER SYSTEMS ENGINEERING CIS216-Database Design and Development Year 2 Semester
Final Examination
Date:10/11/ Time:14: Total Marks: 100 Duration: 2hours Instructions to candidates
- Candidates must attempt any four (4) questions.
- Candidates attempting to gain unfair advantage or colluding in any way whatsoever are liable to be disqualified.
- Do NOT open the question paper until you are told to do so.
- Candidates are not allowed to bring any material that may be used to copy, collude or plagiarize the examinations This marking key paper consists four (4) printed pages including this
a) Explain what a transaction is in databases. 2 Marks b) Give an example of a transaction in the context of a bank. 1 Mark c) Identify and explain the four (4) properties of a database transaction. 8 Marks d) Explain what these symbols mean1:1, 1:M, M:N and draw an ERD to represent them. 6 marks e) State four properties of a table. 4 marks f) List any four database management systems. 4 marks
Question 2 Total: 25 Marks
a) Write a DDL statement that will define the table described below: Student has the following attributes: id, full name, age, gender, 6 marks b) Write PLSQL code that creates a procedure that takes parameters and adds a student record into the database. 6 Marks c) •Write a function that takes an id parameter of a student and displays all the details of the found student and returns their id. 7 Marks d) Write an anonymous block that calls the 2 procedures and function. • 4 Marks e) Write a trigger that prevents the insertion of student who are younger than 17 or older than 65. 4 Marks
a) Define normalization. 2 marks b) Identify the characteristics of the first 3 normal forms. 3 marks c) List three concurrency problems that arise when isolation is broken. 3 marks d) What does the database environment consist of? 5 marks d) Identify and explain three database implementation models. 6 marks e) Explain these two acronyms DDL and DML and provide two examples each. 6 marks Question 5 Total: 25 Marks a) Define the following terms database, data, information, table and record.
b) Identify and explain any 5 DBMS functions. 10 c) Explain five objectives of the three level architecture. 5 End of exam paper.
