N A L A N D A O P E N U N I V E R S I T Y
Master of Computer Application Part-II
PAPER-XIV [Practical]
(Database Management System)
Annual Examination, 2018
Time 2 Hours. SET-II Full Marks 20
Answer all the Questions. All questions carry equal marks.
1. Create the following tables with the fields given below
EMP ENAME, DOB, ADDR1, ADDR2, CITY, DOJ, MOB_NO, DEPT_NO, SALARY)
DEPT (DEPT_NO, DEPT_NAME, LOCATION)
Select an appropriate primary key. Input at least 10 meaningful records. Select appropriate
data types for all the fields.
2. For the above tables designed in Q.1, answer the following queries using SQL:
To display all the employees ENO, ENAME working in FINANCE_DEPT.
To display all the employees ENO whose salary is 50,000 per month?
To display the location of HR_DEPT.
Display the difference of DOJ and till date (in months).
Alter the table EMP to add a column COUNTRY with an appropriate data type.