[Solved] Database Online Exam Help. Database Exam Helper, Database Homework Helper

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.

Give a Comment