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

Database Systems Question Paper

Database Systems

Course:Certificate In Information Technology

Institution: Africa Nazarene University question papers

Exam Year:2015

QUESTION ONE
a)Discuss each of the following concepts in the context of the relational data model: 6marks
i)Relation
ii)Relational database
iii)Domain
iv)Tuple

v)Attribute
vi)Entity
b)Discuss the properties of a relational table 4marks
c)Explain the function of each of the clauses in the SELECT statement.What restrictions are imposed on These clauses?
i)From
ii)Where
iii)Group by
iv)Having
v)Select
vi)Order by
d)Describe how strong and weak entities differ and provide an example of each 5marks
e)Give a definition of a data warehouse 2marks
f)Define the following terms
i)Database
ii)DBMS
g)Explain at least five roles of database administrator 5marks
QUESTION TWO
A)Consider a database of employees in which we need to record information about employees' addresses.What conditions would cause you to make "address"as an entity set of its own rather than employee entity set? 5marks
b)Explain atleast 5 areas where databases are widely applied 5marks

QUESTION THREE
A)Explain at least 3 data models 8marks
b)Give at least4 examples of relational databases 2marks
QUESTION FOUR
a)Explain the advantages of three data models 6marks
b)what is the difference between dml and ddl give examples in each case? 4marks
QUESTION FIVE
Describe the five components of the DBMS environment and discuss how they relate to each other 10 marks

Database Systems Question Paper

More Question Papers

Popular Exams