University of Madras
Chepauk, Chennai- 600 005. Master of Computer Applications Title of the Paper: DBMS
Month & Year of Examination: April - 2013 Subject Code: PSC4N Semester: IV Year: Second Year Question Paper Number: 56715 Time: Three hours Maximum: 75 marks PART A – (10 * 1 = 10)
Answer ALL questions. All questions carry equal marks. 1.Define Primary Key.
2.What is meant by join dependency? 3.Define the term referential integrity. 4.Define Boyce Codd Form in normalization. 5.What is hashing in file organization? 6.What do you meant by weak entity set? 7.Define atomicity. 8.What is transaction? 9.What are the different types of network available? 10.Define data anomalies PART B – (5 * 5 = 25)
Answer FIVE questions. All questions carry equal marks. Write short note on recursive queries.
Draw ER-diagram for Library Management System. Explain multi valued dependency in 4th NF. What are the different types of relational calculus? Write short notes on dynamic hashing. Explain relational data model with neat label sketch. PART B – (4 * 10 = 40)
Answer FOUR questions. All questions carry equal marks. Explain about query processing with examples.
Explain the terms, with example (a) Serializability (b) Persistent. Discuss about buffer management in database. Explain MS SQL Server. Explain homogenous database with neat label sketch. Explain tuple relational calculus with necessary example. |
- Home
-
C Language
- C++
- Java
-
B.C.A
- Subject Details
- COBOL
- Digital Logic Fundamentals
- Fundamental of Digital Computers
- Microprocessor and its applications
- Programming in C
- Computer Graphics
- Operating System
- Programming in C++ and Data Structures
- DBMS
- Programming in Java
- Data Communication and Networking
- Software Engineering
- Software Testing
- Web Technology
- Elective - I >
- Elective - II >
- Elective - III >
- Maths Questions >
- English
-
B.Sc
- B.Sc (Cs) Subject Details
- Computer Architecture and Organization
- Digital Electronics and Microprocessor
- Data Structure Using C++
- Microprocessor and Its Applications
- Programming in C
- Programming in C++ and Data Structures
- Programming in Java
- Visual Programming
- Operating System
- DBMS
- Software Engineering
- Data Communication and Networking
- Software Testing
- Web Technology
- Computer Networks
- OOAD
- Multimedia Systems
- M.C.A
- M.Sc (CS)
- M.Sc (IT)
- Conduct Us
- Programming Language
- Programming Logic
- Computer Terms
- Job Selection Process
- Learn English Using Tamil
- Spoken English in Tamil
- Conversational Tamil
- English
- Interview