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)
More Question Papers
Exams With Marking Schemes
Popular Exams
Mid Term Exams
End Term 1 Exams
End Term 3 Exams
Opener Exams
Full Set Exams
Return to Question Papers