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-I Full Marks 20
Answer all the Questions. All questions carry equal marks.
1. Create the following tables with the fields given below
STU_DETAILS SNAME, DOB, ADDR1, ADDR2, CITY, COUNTRY)
MARK_DETAILS MARKS1, MARKS2, MARKS3, TOTAL)
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 the student name of the student who scored the highest TOTAL.
To display the MARKS1 of all the students.
To display the ENOs of all the students who scored >50 marks in MARKS2.
Alter the table MARK_DETAILS to add a column AVG with appropriate data type.
Using appropriate command drop the column COUNTRY from STU_DETAILS.