Design and Analysis of Database (CSCT3101)
Computer Science - COS
Semester: First Semester
Level: 300
Year: 2019
REPUBLIC OF CAMEROON THE UNIVERSITY OF BAMENDA
Peace – Work – Fatherland P.O. BOX 39 BAMBILI
FIRST SEMESTER EXAMINATION
SCHOOL: HTTTC DEPARTMENT:CSC OPTION: FCS / ICT
COURSE CODE:CSCT3101 / CSCT3114 COURSE TITLE: Design and Analysis of
Database / Database design and Management
LECTURER: Dr LIENOU CREDIT VALUE: 3
DATE: 13/03/2019 TIME: 1h30 START…09:30..AM END……11:00 AM
Instructions:
Exercise I (6 + 6 + 10 + 6 +6 + 6= 40 mks)
a) Give the mathematical definition of the following concepts of relational algebra:
Selection, Projection, Left Join
b) Explain the fillowing
concepts used in relational
databases and provide an
example: Entity, Transaction,
Foreign key
c) In MySQL, state the
differences and give
advantages/disadvantages of
the MyISAM and InnoDB
storage Engine
d) What are the
conditions for a table to be in
a Third Normal Form?
e) For each of the DML,
DDL, DCL which are parts of
SQL, give two commands in
each and provide an example.
Exercise I1 (10 + 10 + 5 + 5 = 30 mks)
Figure 1 represents an E/R model of a database. You are therefore ask to:
a) Select 2 entities of your choice and write down the SQL commands to create them
b) Write the code of an SQL query to compute the population of a region by adding the
population of its divisions.
c) Write the SQL code to compute the average areas of divisions within each region
d) Write the code to give the Fname of the governor, the name of the region in which
Figure 1 E/R model of Administration Database
www.schoolfaqs.net
