Mid-Term Examination
Course: Information Management
Q1. Why Data Management Software is needed? List some important features
of DB2. 6 Marks
Instructions: For Question 2 and Question3 attach the snapshot of the DB2
window showing the query and the answer.
Q2. Write queries in SQL against the DB2 SAMPLE Database, which includes
the EMPLOYEE, DEPARTMENT, PROJECT, and EMP_ACT tables. Each
query should be expressed using a single SQL statement, and produce a
properly labelled table. 8 Marks
(a) Print the names of the tables in the DB2 SAMPLE Database.
(b) Print the column details of the of the EMPLOYEE and PROJECT Table.
(c) Print the first name of the employees who are female.
(d) For each employee with job title ‘MANAGER’ give the full name, current
salary, Sex and the time he or she was hired.
Q3. Create a STUDENT database in DB2. In the database create tables which
include Student Name, Age, GPA and the Course they are taking. The
database should have 15 entries. 6 Marks
Note: You can take reference from student.csv file.
