UNIVERSITY EXAMINATIONS: 2019/2020
EXAMINATION FOR BACHELOR OF SCIENCE IN
INFORMATION TECHNOLOGY
BIT 2104/ BAC 1301: DATABASE DESIGN AND DEVELOPMENT
MODE: FULL TIME/PART TIME/DISTANCE LEARNING
ORDINARY EXAMINATIONS
DATE: MAY, 2020 TIME: 6 HOURS
INSTRUCTIONS: Answer ALL QUESTIONS
SECTION 2: 20 MARKS [OPEN BOOK]
1. Consider the schema below and write appropriate SQL statements:
Property->(PropertyID, Location, Acreage, RegistrationDate):
i. Add new column for PropertyRates whose type is numeric.
ii. Display all properties registered before 2017-01-31
iii. Display total property rates collected for properties located in Mwiki.
iv. Increase the acreage for all properties in Karen by 2%.
v. Create view to display all properties whose acreage exceed 2 Acres.
SECTION 3: 20 MARKS [OPEN BOOK]
2. In an organization, an employee is identified by unique number, name, salary and address.
There are several employees. Each employee works in one and only one department although
a department has several of these employees. Each department is described by department
number, name and budgetary allocation. Each employee has one or more dependents identified
by employee’s unique number, a name and age.
i. Normalize this narrative to 3.N.F.
10 Marks
ii. Draw an ER diagram for this narrative after normalization.
10 Marks
