Instructions: Answer Question ONE and any other TWO Questions
Question One (30 Marks) [Compulsory]
- Distinguish between a DBMS and database giving examples (4 marks)
- Explain two characteristics of a distributed database (4 marks)
- Explain two characteristics of DDL. (4 marks)
- Discuss two components of a relational database (4 marks)
- Briefly describe three steps involved in database design (6 marks)
- Draw an E-R Diagram for Zetech University that captures the following entities: Students. Lecturers, Library and Computer Lab. (5 marks)
- State three types of data that can be found in a data dictionary (3 marks)
Question Two (20 marks)
- Ken wants to develop a database using the professional procedure. Briefly discuss the database development process that he is likely to follow. (10 marks)
- The managing director of Proctor and Alan Company wants to implement database systems but is not sure of whether he will get value for money. Discuss five reasons why he should go ahead with the plan. (10 marks)
Question Three (20 marks)
a. Discuss five methods that can be used to ensure availability, integrity and secrecy of data and other components in database systems. (10 marks)
- Using well labelled diagrams discuss three types of table relationships (6 marks)
- State four characteristics of business rules applicable to databases (4 marks)
Question 4 (20 marks)
a. Show, giving appropriate SQL commands, step by _step how you would go
About:
i. Creating the database and tables above in MySQL. (6 Marks)
ii. For each table, add the first record. (3 marks)
b. Write SQL statements to:
i. Compute the total budget for all upgrade projects. (4 marks)
ii. Names and departments of the five least expensive employees? (4 marks)
iii. Return employee information grouped by department. (3 marks)