Get premium membership and access revision papers, questions with answers as well as video lessons.

Com213 Question Paper

Com213

Course:Bachelor Of Science In Acturial Science

Institution: Karatina University question papers

Exam Year:2013/2014

Q3
A) describe each of the following terms with respect to data security
I)authentication
ii)encryption
ii)profiles
B)describe the concept of data independence,explaining its important in a database enviroment
C)with an aid of a diagram describe the ANSI-SPARC three level architecture model
Q4
A)explain four limitation of file based system
B)the following relations are part of relational database
Relation(RESORTID,resort name,adress)
Hotel(HOTELID,RESORTID,hotel name,rating price)
customer(CUSTOMERID,
RESOSRTID,CUSTOMERID,customer name,adress)
Reservation(RESORTID,CUSTOMERID,from date,to date,hotelID)
#primary keys capitalised
C)write expretions in relational algebra to retrive each of the following
I)a list of names of all resorts
Ii)a list of all 3stars hotels that are under ksh 10000 per nigth and resort details
Iii)a list of hotels showing the reservation for 5 june,2015 for each reserve show customer id you should include in your list hotels that has no reservations
NB: NEXT QUESTION ON THE NEXT RESOURCE

Com213 Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams