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

Database Management Systems Question Paper

Database Management Systems

Course:Bachelor Of Computer Science

Institution: Kabarak University question papers

Exam Year:2011

INSTRUCTIONS:
NOTE: - PART-A IS COMPULSORY, HAS 30 MARKS AND FROM PART-B, YOU CAN

SECTION A COMPULSORY (30MARKS)

QUESTION-1 (30 MARKS)
a). Explain storage management in details as used DBMS (3 marks)
b).What is Data Independence? (1 mark)
c). Discuss the two types of Data Independence (2 marks)
d). Explain the following terms:-

i). Database
iii) Attribute
iv) Entity set (3 marks)
e). Discuss areas of database applications (3 marks)

f).What is data model? Discuss at least 3 types of data model (3 marks)

g).Explain briefly what is meant by database security and database integrity
within a relational database system and highlight the relationship between
them. (2 marks)

h). Discuss the following:-

i). Data Manipulation Language (DML) (3 marks)
ii). Data definition Language (DDL) (3 marks)

i).Describe the three levels of data abstraction? (3 marks)

j).What are the major factors that have led to the development of distributed
database systems? (4 marks)

QUESTION TWO: 20 marks

a).
i) What are the drawbacks of using file systems to store data (3 marks)

. ii).Define a schema? Explain its two types (3 marks)

b). A company that supplies parts keeps in their database the following fields as contained in
three database tables:

Field Data type length Null? Description
Vendor_detail
SuppCode varchar 5 Not null supplier code
SuppName varchar 20 Not null supplier names
Status int Not null supplier’s state
City varchar 15 Not null city supplied from

Vendor_dbase
SuppCode varchar 5 Not null supplier code
PartNo. varchar 6 Not null part number
Quantity int Not null part amount supplied

Section_dbase
PartNo. varchar 6 Not null part number
PartName varchar 20 Not null part name
Colour varchar 10 Not null part colour
Weight smallint Not null part weight
City varchar 15 Not null city supplied to

Required:-
i).create the above three tables. (3 marks)
ii). Write a SQL statement that adds a new field Discount to Vendor_detail table
(1mark)
iii). Write a SQL statement that returns supplier code and status for supplies from a
city called Mombasa in ascending order of status (2 marks)
iv) Write a SQL statement that deletes the entire Section_dbase table from the database.
(1 marks)
v). Create a copy of an existing employee table. (2 marks)

c). what is normalization? (2 mark)
d). Discuss the factors to consider when selecting a database? (3marks)

QUESTION THREE: 20 marks

a). Create The following two tables : (2 marks)

College-info
Faculty-info
College-info consists of fields : college-code, college-name, address
Faculty-info consists of fields : college-code, faculty-code, faculty-name,
qualification, experience-in-no-of-years, address.

The field college-code is foreign key.

Generate queries to do the following :
(i) List all those faculty members whose experience is greater than or equal to 10 years and
have M. Tech degree. (1 mark)
(ii) List all those faculty members, who have at least 10 years of experience but do not have
M. Tech degree. (1 mark)
.
b). Explain the forms of authorization on parts of a database (3 marks)

c).what is an attribute? Discuss attributes types (3 marks)
d). Discuss the following types of normal forms:
(i) First normal form (2marks)
(ii) Second normal form (2marks)
(iii) Third normal form (2marks)
e).Explain forms of mapping cardinalities with aid of appropriate diagrams in each case.
(4 marks)

QUESTION FOUR-20 marks

a) Differentiate between primary key and a foreign key (2 marks)

b) Discuss all the categories of database users in details (4 marks)

c).Describe the components of a DBMS? (5 marks)

d). write down the basic structure of a relation. (3marks)

e). Discuss the Boyce-Codd Normal Form (BCNF) with the help of an example. (6marks)

Database Management Systems Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams