Database Design and Management (CSCT3114)
Computer Science - COS
Semester: Resit
Level: 300
Year: 2018
Exercise I (5x2=10 mks)
What does the following abbreviations stand for?
DDL, DML, SQL, NoSQL, DCL
Exercise II (4x3 = 12mks)
For each of the following concepts, write down how are they important and explain how
technically it is implemented:
Index, Transaction, First normal form, Foreign key
Exercise III (12x4 = 48mks)
The computerization of the civil status of citizens has been given to you. The expected
documents to be generated for each citizen at a given time are birth certificate, marriage
certificate, school certificates. You should not manage the place of issue such as council,
hospitals and schools. A citizen has a FirstName, LastName, DateOfBirth, PlaceOfBirth,
Gender, FathersName, MothersName. Each certificate apart from the SerialNumber has a
Title, DateOfIssue, MinimumNumberOfYears. This last attribute contains the minimum
number of years a citizen should have to be issued such a certificate.
a) Draw an Entity Relationship Diagram of the future system
b) For each citizen, write an SQL query to show his FirstName ,LastName and also
FirstName , LastName of his father.
c) The SerialNumber of a marriage certificate is “NW234”. From that number, write a
query to give the names of the spouses.
d) Write a query to delete from the database all the citizen having certificates that the
criteria of MinimumNumberOfYears is not met.
Good Luck !
REPUBLIC OF CAMEROON THE UNIVERSITY OF BAMENDA
Peace-Work-Fatherland P.O. Box 39 Bambili
First Semester Examinations
School/Faculty: HTTTC Department: Computer Science Option: ICT Lecturer: Dr LIENOU Jean-Pierre
Course Code: ICT218 Course Title: Database Design and Management Credit Value: 2
Date: 13/09/2018 Duration 1H Start Time: 03 PM End Time 04 PM Hall: PBB07
www.schoolfaqs.net
