Download Introduction to Database Management Systems (ICS 2206) - University Exam Paper and more Essays (university) Database Management Systems (DBMS) in PDF only on Docsity!
W1-2-60-1-
JOMO KENYATTA UNIVERSITY
OF AGRICULTURE AND TECHNOLOGY
University Examinations 2016/
YEAR ONE SEMESTER TWO/YEAR TWO SEMESTER ONE EXAMINATIONS
FOR THE DEGREE BACHELOR OF SCIENCE IN INFORMATION
TECHNOLOGY/BACHELOR OF MASS COMMUNICATION/BACHELOR OF
BUSINESS INFORMATION SYSTEMS
ICS 2206: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
DATE: APRIL 2017 TIME: 2 HOURS
INSTRUCTIONS: ANSWER QUESTION ONE (COMPULSORY) AND ANY OTHER
TWO QUESTIONS
QUESTION ONE (30 MARKS)
a) Distinguish between;
i) File –based system and database approach (2 marks)
ii) Centralized database and distributed database (2 marks)
b) Define the term database system (2 marks)
c) Explain the meaning of transaction in database terms (2 marks)
d) Describe the following data models:
i) Network model (3 marks) ii) Relational model (3 marks)
e) Explain the four basic building blocks of all data models (4 marks)
f) Describe the following database design processes;
i) Conceptual design (2 marks) ii) Logical design (2 marks) iii) Physical design (2 marks)
g) Explain the following broad categories of SQL functions;
i) Data Definition Language (DDL) (3 marks) ii) Data Manipulation Language (DML) (3 marks)
QUESTION TWO (20 MARKS)
a) Illustrate the structure of a typical DMBs based on the relational data model (8 marks)
b) Explain briefly the five major components of the database system environment (5 marks)
c) Describe, with the aid of an example, the syntax of SQL INSERT statement (7 marks)
QUESTION THREE (20 MARKS)
a) Explain four disadvantages of the database approach (4 marks)
b) Describe the ACID transaction properties (4 marks)
c) Explain the SQL syntax of ;
i) CREATE TABLE (6 marks) ii) UPDTE record (6 marks)
QUESTION FOUR (20 MARKS)
a) A university registrar’s office maintains data about the following entities;
i) Courses, including number, title, credits, syllabus, and prerequisites; ii) Course offerings, including course number, year, semester, section number, instructor(s), timings and classroom; iii) Students, including student ID, name, and program; iv) Instructors, including identification number, name, department, and title.
Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be properly modeled. Construct an E-R diagram for the registrar’s office (12 marks)
b) Explain four advantages of a DBMs (4 marks)
c) Discuss briefly the hierarchical data model (4 marks)
QUESTION FIVE (20 MARKS)
a) Explain the following;
i) One-to-one (1:1) Relationships (2 marks) ii) One –to-many (1:) Relationships (2 marks) iii) Many-to-many (:*) Relationships (2 marks)
