UNIVERSITY EXAMINATIONS: 2021/2022
EXAMINATION FOR THE DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DBIT 301: DATABASE MANAGEMENT SYSTEMS
FULLTIME/ PARTTIME
DATE: DECEMBER, 2021 TIME: 2 HOURS
INSTRUCTIONS: Answer question one and any other two Questions.
QUESTION ONE (20Marks)
(a) James, a DBA working for a software development company was required to design a
database management system.
Required:
(i) Outline two principle requirements he would consider when selecting the
storage media for the proposed database system [2 Marks]
(ii) Explain five benefits the proposed database system will deliver to the
company [5 Marks]
(iii) List and explain three challenges James is likely to encounter while
implementing the proposed database system [3 Marks]
(b) List and explain four DML commands supported by SQL/ MYSQL [4 Marks]
(c) List and explain three components of a DBMS [3 Marks]
(d) Explain three qualities of a good database system [3 Marks]
QUESTION TWO (15 Marks)
(a) Explain the following terms as used in database systems:- [4 Marks]
(i) Database
(ii) Data integrity
(iii) Candidate key
(iv) Relationship
(e) Define the term “database normalization” [2 Marks]
(f) Discuss four benefits of database normalization [4 Marks]
(g) With the aid of appropriate illustrations, describe the following database models:-
(i) Relational model [2 Marks]
(ii) Hierarchical mode [2 Marks]
(e) Differentiate between the following database terms:-
(i) Logical design & physical design [1 Mark]
QUESTION THREE (15 Marks)
Customers (CustomerID, CustomerName, CustomerAddress )
Orders (OrderID, OrderDate, #CustomerID)
Products (ProductID, ProductName, price)
Order_products (#OrderID, #ProductID, Quantity)
(a) Create tables Customers, Orders, Products and Order_products using SQL commands
(8Marks)
(b) Use the command insert to enter the following records (2Marks)
(c) Add a column contact phone in a Customers table (1Mark)
(d) Display all orders done by Paul. (1Mark)
(e) Ana change her place, now her current address is Kicukiro. Use SQL statement to update
the new information. (2Marks)
(f) Display the laptops which the price is BETWEEN 100000 and 280000 (1Mark)
QUESTION FOUR (15 Marks)
The Motor Vehicle Branch administers driving tests and issues driver’s licenses. Any
person who wants a driver’s license must first take a learner’s exam at any Motor Vehicle
Branch in the province. If he/she fails the exam, he can take the exam again any time after
a week of the failed exam date, at any branch. If he passes the exam, he is issued a license
(type = learner’s) with a unique license number. A learner’s license may contain a single
restriction on it. The person may take his driver’s exam at any branch any time before the
learner’s license expiry date (which is usually set at six months after the license issue date).
If he passes the exam, the branch issues him a driver’s license. A driver’s license must also
record if the driver has completed driver’s education, for insurance purposes.
Create an E-R diagram following these steps.
1. Find out the entities and their attributes. (5Marks)
2. Find out the relationships among the entities. (5Marks)
3. Figure out constraints between entities and relationships. (5Marks)
