Database Management Systems Question Paper
Database Management Systems
Course:Bachelor Of Business Information Technology
Institution: Jomo Kenyatta University Of Agriculture And Technology question papers
Exam Year:2012
QUESTION ONE
a) Define the following terms (6marks)
i. Database
ii. Database management system
iii. File system
b) With the aid of examples differentiate between the Data Manipulation Language (DML) and the Data Definition language (DDL) (6 marks)
c) Determine the cardinality and the existence of each of the following pairs of entity types. (12marks)
i. Patient undertaking care of physician
ii. Physician performs operation
iii. Doctors have specialty in diseases
iv. Needle injected into patient
d) Describe the following types of dependencies with appropriate examples (6marks)
i. Multi valued attribute
ii. Partial dependency
iii. Transitive dependency
QUESTION TWO
a) Describe the three categories of database models (6 marks)
b) Describe the ACID properties of a good DBMS (8 marks)
c) List five Applications of Database systems. (6marks)
QUESTION THREE
a) Define the following terms (6marks)
i. Entity type
ii. Entity
iii. Instances
b) Differentiate between an attribute and an identifier of an entity(4marks)
c) Draw an ER diagram for the following. Be sure to indicate the existence and cardinality for each relationship. (10 marks)
1. A college runs many classes. Each class may be taught by several teachers, and a teacher may teach several classes. A particular class always uses the same room. Because classes may meet at different times or on different evenings, it is possible for different classes to use the same room.
2. Each employee in an engineering company has at most one recognized skill, but given a skill may be possessed by several employees. An employee is able to operate a given machine-type (e.g, lathe grinder) if he has one of several skills, but each skill is associated with the operation of only one machine type. Possession of a given skill (e.g., mechanic, electrician) allows an employee to maintain several machine-types, although maintenance of any given machine-type requires a specific skill (e.g., a lathe must be maintained by a mechanic).
QUESTION FOUR
a) Define the term normalization (2 marks)
b) State the two problems association with Redundant data (2marks)
c) List four advantages of normalization (4marks)
d) A college maintains details of its lecturer’s subject area skills. These details comprise
• Lecturer number
• Lecturer name
• Lecturer grade
• Department code
• Department name
• Subject code
• Subject name
• Subject level
Assume that each lecturer may teach many subjects but may not belong to more than one department.
Subject code, subject name and subject levels are repeating fields. Normalize this data to Third Normal Form. (12 marks)
QUESTION FIVE
a) List four traditional Data Administration Functions (4marks)
b) Define data security (2 marks)
c) Describe four threats to Data security (8 marks)
d)Describe concurrency control techniques (6 marks)
More Question Papers