Exam Details
Subject | advanced database management systems | |
Paper | ||
Exam / Course | b.tech | |
Department | ||
Organization | Vardhaman College Of Engineering | |
Position | ||
Exam Date | June, 2017 | |
City, State | telangana, hyderabad |
Question Paper
Hall Ticket No:
Question Paper Code B3207
(AUTONOMOUS) M. Tech II Semester Regular/Supplementary Examinations, June 2017
(Regulations: VCE-R15) ADVANCED DATABASE MANAGEMENT SYSTEMS
(Computer Science and Engineering) Date: 07 June, 2017 FN
Time: 3 hours
Max Marks: 70
Answer any FIVE Questions
Each Question carries equal marks
1.
With a neat diagram, explain the high-level conceptual data models for database design.
8M
Draw an ER-diagram for a railway online reservation system. Assume your own entities (minimum of 5 entities), also mention the cardinality ratio.
6M
2.
Briefly discuss the characteristics of a relation and how integrity constraints are supported by a relation.
8M
Define the following terms:
i. Physical data independence and Logical data independence
ii. Entity type and entity sets
6M
3.
Write short notes on the following concepts of relational algebra operations with an example for each:
i. Cartesian product (Cross product) ii. Division operation
6M
Discuss the ER-to-Relational mapping algorithm for a company database.
8M
4.
Write a PL/SQL program to print the first 8 Fibonacci numbers using a function.
6M
Briefly explain the blocks of a PL/SQL statement with an example. How triggers are coded using a PL/SQL block?
8M
5.
What is indexing? Briefly discuss the different types of indexing techniques.
8M
Briefly describe the different cost components used to find the cost of executing a query.
6M
6.
Draw a neat diagram and discuss the typical states that a transaction goes through during execution. Detail the characteristics of a transaction.
8M
Explain the concurrent execution of transactions and lock-based concurrency control.
6M
7.
What is distribution transparency? Discuss the three levels of distribution transparency.
8M
What is fragmentation? List the advantages and disadvantages of fragmentation.
6M
8.
What is data security? Explain any three data security measures.
8M
What is object database? List the advantages and disadvantages of object database compared to RDBMS.
6M
Question Paper Code B3207
(AUTONOMOUS) M. Tech II Semester Regular/Supplementary Examinations, June 2017
(Regulations: VCE-R15) ADVANCED DATABASE MANAGEMENT SYSTEMS
(Computer Science and Engineering) Date: 07 June, 2017 FN
Time: 3 hours
Max Marks: 70
Answer any FIVE Questions
Each Question carries equal marks
1.
With a neat diagram, explain the high-level conceptual data models for database design.
8M
Draw an ER-diagram for a railway online reservation system. Assume your own entities (minimum of 5 entities), also mention the cardinality ratio.
6M
2.
Briefly discuss the characteristics of a relation and how integrity constraints are supported by a relation.
8M
Define the following terms:
i. Physical data independence and Logical data independence
ii. Entity type and entity sets
6M
3.
Write short notes on the following concepts of relational algebra operations with an example for each:
i. Cartesian product (Cross product) ii. Division operation
6M
Discuss the ER-to-Relational mapping algorithm for a company database.
8M
4.
Write a PL/SQL program to print the first 8 Fibonacci numbers using a function.
6M
Briefly explain the blocks of a PL/SQL statement with an example. How triggers are coded using a PL/SQL block?
8M
5.
What is indexing? Briefly discuss the different types of indexing techniques.
8M
Briefly describe the different cost components used to find the cost of executing a query.
6M
6.
Draw a neat diagram and discuss the typical states that a transaction goes through during execution. Detail the characteristics of a transaction.
8M
Explain the concurrent execution of transactions and lock-based concurrency control.
6M
7.
What is distribution transparency? Discuss the three levels of distribution transparency.
8M
What is fragmentation? List the advantages and disadvantages of fragmentation.
6M
8.
What is data security? Explain any three data security measures.
8M
What is object database? List the advantages and disadvantages of object database compared to RDBMS.
6M
Other Question Papers
Subjects
- advanced computer networks
- advanced database management systems
- advanced digital signal processing
- advanced structural design
- air line management
- air pollution and control methodologies
- aircraft systems and instrumentation
- analog communications
- artificial intelligence
- automobile engineering
- basic electrical engineering
- basic mechanical engineering
- cad/cam
- cellular and mobile comunications
- cloud computing
- coding theory and techniques
- compiler design
- computational fluid dynamics
- computer architecture and parallel processing
- computer graphics
- computer graphics concepts
- computer networks
- computer organization and architecture
- computer programming
- computer vision and pattern recognition
- concrete technology
- control systems
- cyber security
- data mining and data warehousing
- database management systems
- design and drawing of hydraulic structures
- design for testability
- digital image processing
- distributed databases
- distributed operating systems
- electrical machines-ii
- electromagnetics and transmission lines
- electronic measurements and instrumentation
- embedded netwrok and protocols
- embedded software design
- embedded systems
- engineering drawing-i
- engineering mechanics-i
- engineering physics
- entrepreneurship
- environmental engineering-ii
- environmental science
- finite elements methods in civil engineering
- flexible ac transmission systems
- formal language and automata theory
- grid and cloud computing
- hardware software co-design
- heat transfer
- high voltage engineering
- hydraulic machines
- hydraulics and hydraulic machines
- image processing
- image processing and pattern recognition
- industrial management and psychology
- information retrieval systems
- instrumentation and control systems
- kinematics of machinery
- low power cmos vlsi design
- managerial economics and financial analysis
- microwave engineering
- mobile application development through j2me
- national service scheme
- network security and cryptography
- operating systems
- operations research
- pavement analysis and design
- planning and drawing
- power electronic control of ac drives
- power electronic converters-ii
- power semiconductor drives
- power system generation
- power system switchgear and protection
- principles of electrical engineering
- principles of programming languages
- probability theory and numerical methods
- production technology-i
- programmable logic controllers and applications
- project planning and management
- pulse and digital circuits
- reactive power compensation and management
- refrigeration and air conditioning
- rehabilitation and retrofitting structures
- reliability engineering
- renewable energy sources
- robotics and automation
- satellite and radar communications
- service oriented architecture
- signals and systems
- software architecture
- software engineering
- software project management
- software testing and quality assurance
- speech signal processing
- strength of materials-iibuilding
- structural analysis-i
- surveying-ii
- technical english
- thermal engineering-i
- utilization of electrical energy
- vlsi design
- web technologies
- wireless and mobile computing
- wireless communications and networks