Introduction to Database (CSCT2211)
Computer Science - COS
Semester: Second Semester
Level: 200
Year: 2018
Page 1 of 1
T
SCHOOL: H.T.T.T.C DEPARTEMENT: C$ LECTURERfSk Dr. LIENOU Jean-Pierre
COURSE CODE: CSC427 COURSE TITLE: Introduction to Database OPTION: ICT/ FCS100
DATE: HALL: .......... TIME: 1.5 hrs NATURE: EXAM 2017/2018
Exercise I (15+12 +6+4+4+4+4+4=53 mks)
A school wants to create a database to pay teachers that are part time. A teacher has a name, a
highest diploma, a phone number, a rate per hour. He/She can teach many courses in many
classrooms. At the end of the academic year, the accountant produces the statement for payment.
A classroom has a label. A course has a label and the number of hours supposed to be taught.
a) Propose an entity relation diagram to manage such a database Write the SQL
commands that:
b) Create the tables TEACHER, COURSE, CLASSROOM in Mysql,
c) Insert a tuple in each table
d) Delete all the teachers with the highest diploma “HND”
e) Modify the table TEACHER and add an email as a new column
f) Display the total number of classrooms and teachers in the school
g) Display for each classroom the number of hours to be taught per year
h) Display the name of the teacher with the highest rate per hour
Exercise II (9+4+4=17 mks)
a) Describe the differences in the first through third normalization forms
b) Which Mysql command can tell you which weekday (Tuesday or Saturday ...) will be in 120
days?
c) What is the difference between an inner and outer join?
REPUBLIC OF CAMEROON
Peace - Work - Fatherland
THE UNIVERSITY OF BAMENDA
HIGHER TECHNICAL TEACHER TRAINING
COLLEGE (H.T.T.T.C.) BAMBILI – BAMENDA
DIRECTION OF STUDIES
P.0 BOX 39 BAMBILI TEL : 33 36 36 94
REPUBLIQUE DU CAMEROUN
Paix - Travail -Patrie
UNIVERSITE DE BAMENDA
ECOLE NORM ALE SUPERIEURE DE
L 'ENSEIGNEMENT TECHNIQUE (ENSET)
DE BAMBILI - BAMENDA
DIRECTION
DES
ETUDES
FAX / 33 05 10 69
www.schoolfaqs.net
