III/MCA/301
Professional Course Examination, November 2018
3rd Semester
MASTER OF COMPUTER APPLICATIONS
Course MCA-301
Database Management Systems
Revised
Full Marks 60
Time 3 hours
The figures in the margin indicate full marks for the questions
Answer Q. No. 1 and any four from the rest
1. Answer the following questions 2×6=12
What are the elements of a database?
Why do we need a database?
What is data abstraction and why is it required?
Define a view. How are views different from tables?
How does the two-phase locking protocol work?
Define a JOIN clause.
/424 1 Contd.
2. Explain the characteristics of data in a database. 6
Explain the three database levels with the help of a diagram. 6
3. Describe the connectivity of a relationship by giving example. 6
What do you mean by specialization and generalization in EER model?
Explain with example. 6
4. What are the relational algebraic operations derived from set theory?
Explain with example. 8
What are existential and universal quantifiers and what are they used
for? 4
5. Draw an ER diagram from the given relation 8
DEPARTMENT (dept_no, dept_name, dlocation)
EMPLOYEE (essn, name, dob, sex, address, phone, dept_no)
PROJECT (project_no, pname, plocation, dept_no)
WORKS_ON (essn, project_no, hours)
DEPENDENT (essn, dept_name, dob, sex, relationship)
Explain the different types of integrity constraints. 4
6. What is normalization? Explain the different normal forms. 6
Write short notes on the following 6
ANY and ALL clause in SQL
Denormalization
7. What is transaction management? Describe the ACID properties. 5
Explain concurrency control by timestamp. 3
What is shadow paging? Explain how it is performed. 4
III/MCA/301 2 Contd.
8. Explain the common causes of failure in a database. 6
Write the SQL queries for the given relation
ID Title Author Publisher Year Price
A01 A Painted House Grisham Random House 2001 195
A02 Abduction Cook Pan Books 2000 360
B01 Biplane Bach Dell Books 1999 283
C01 Catch 22 Heller Random House 1994 250
D01 Dragon Cussler Harper Collins 1990 123·50
Get the title, author name and publisher of all books published in
1999 and 2000.
Get all the details of book whose price is in the range of 100 and
200 both exclusive.
Change the price of the book B01 to 290.
Get the name of publishers after eliminating the duplicates.
Show the book details in the ascending order from the year of
publishing.
Get the title of all books whose price is greater than 300. 6