Ics 2214: Database Management System Question Paper
Ics 2214: Database Management System
Course:
Institution: Jomo Kenyatta University Of Agriculture And Technology question papers
Exam Year:2011
Q1.
a)Define the following terms
~Data
~Database management systems
~Meta data
~Data-warehousing (4mks)
b)Describe why a database system is important to an enterprise(6mks)
c)Name the three main elements of SQL. (6mks)
The internal structure of SQL(Structured Query Language) is divided into three main elements namely?
d)Briefly differentiate between basic object adapter(BOA) and portable object adapter(POA).Used in relation for implementing CORBA objects.(6mks)
e)State four problems that are caused by data redundancy.(4mks)
f)Give the main difference between java servlet ana java applets.(4mks)
Q2.
a)A business venture is to proceed after a feasibility study has been completed.A database management system will be required.
~Describe three functions of a DBMS.(6mks)
~Explain four components of DBMS.(4mks)
~What is data integrity.(2mks)
b)Explain the meaning of the following SQL statement
~Select *from authors.(2mks)
~Select *from book_title,where ''year published''<1998 order by year published desc.(3mks)
c)Differentiate between an entity an an attribute.(3mks)
Q3.
a)Explain five problems of file based systems.(10mks)
b)Briefly explain what is a javaservlet.(2mks)
c)Database is used by different kind of people,performing the different functions.Giving examples,list the responsibilities of:
~Database administrator.(4mks)
~Data administrator.(4mks)
Q4.
a)Briefly define distributed object systems.(2mks)
b)Describe four models used to implement distributed object applications.(8mks)
c)The CORBA(Common Object Request Broker Architecture)specificatiös defines the concept of an object adapter,used in implementation of CORBA objects;give five functions of an object adapter.(10mks)
More Question Papers