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

Database Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit 221) (Dcis 106) 3Rd Trimester 2014 Question Paper

Database Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit 221) (Dcis 106) 3Rd Trimester 2014

Course:Bachelor Of Business Information Technology

Institution: Kenya Methodist University question papers

Exam Year:2014

DATABASE SYSTEMS (BBIT 232) (CISY 221) (COMP 340) (BSIS 115) (DBIT 221) (DCIS 106) 3RD TRIMESTER 2014
KENYA METHODIST UNIVERSITY

END OF 3'rd 'TRIMESTER 2014 (PT) EXAMINATION

FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE AND BUSINESS
INFORMATION
UNIT CODE : BBIT 232/CISY 221/COMP 340/BSIS 115/
DBIT 221/DCIS 106

UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS

SECTION A

Answer all the questions in this section

Question One

State four drawbacks of using operating system files to store large amounts of data.
(4 marks)
By giving examples, differentiate between a data definition language and a data manipulation language.
(4 Marks)
Explain the meaning of the following terms as used in relational database modeling
(4 Marks)
Entity
Relation
Attribute
Relationship
A system is required for managing deliveries of customer’s orders. Customers’ orders are delivered to the towns from which the order is made. A customer may have businesses in more than one town. Using E-R model the relationship between customers, towns and order deliveries.
(10 Marks)
Differentiate between a primary key and a foreign key in database design.
(4 Marks)
Explain the three roles played by attributes in an entity class.
(4 marks)
SECTION B: '''answer any two questions

Question Two

Explain any three ways of classifying failure in a database management system.
(6 Marks)
Describe three characteristics that distinguish the database management system approach to data processing from the file processing approach.
(6 marks)
Explain the three basic layers of a data driven enterprise application.
(3 Marks)
Question Three

Using relevant diagrams, explain any three cardinality constraints in a relational database design.
(6 Marks)
The SQL language has several components. Explain the role of any three of the components.
(6 Marks)
Given the data dictionary below, write the SQL command that will create the relation department
(3 marks)
Table name : department

dept_name : varchar (20 )

building : varchar (50)

budget : numeric (12, 2)

primary key : dept_name

Question Four

Explain the three aspects of data security in database management systems.
(6 Marks)
In a University, the following relations are used to capture data about students and courses offered. Model a database system that gives the details of each student and the courses enrolled for, given that a student can take more than one course.
(6 Marks)
The conceptual schema consists of the data requirements of the users. Explain three aspects of data described by a conceptual schema. (3 marks)

Database Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit 221) (Dcis 106) 3Rd Trimester 2014 Question Paper

More Question Papers

Popular Exams