CS6302 Database Management Systems Question Bank : dmice.ac.in
Name of the College : DMI College OF Engineering
Subject : Database Management Systems
Website : dmice.ac.in
Document type : Question Bank
Download Database Management Systems Question Paper : https://www.pdfquestion.in/uploads/dmice.ac.in/370-CS6302.doc
DMI Database Management Systems Question Paper
CS6302- DATABASE MANAGEMENT SYSTEMS :
QUESTION BANK :
UNIT-I
PART-A (TWO MARK) :
** Explain the basic structure of a relational database with an example.
** What is meant by strong entity set?
Related : DMI College OF Engineering IT2402 Mobile Communication B.E Question Bank : www.pdfquestion.in/2784.html
** What is a data model? List the types of data models used.
** With an example explain what a derived attribute is?
** List five responsibilities of the DB manager.
** Define database management system? What is the need of DBMS?
** Compare database systems with file systems.
** Give the reasons why null values might be introduces into the database.
** What are the disadvantages of file processing system?
** Define Data independence.
** Define query language?
** Give the usage of the rename operation with an example.
** What is meant by normalization of data?
** What is meant by lossless-join decomposition?
PART-B (16 MARK) :
With neat diagram, explain the structure/Component of a DBMS.
i) Explain the differences between physical level, conceptual level and view level of data abstraction. (8)
ii) Define data model. Explain the different types of data models with relevant examples. (8)
** Draw an E-R diagram for a small marketing company database and map to its relational model, assuming your own data requirements.
** With relevant examples discuss the various operations in relational algebra.
** Explain 1NF, 2NF, 3NF and BCNF with suitable example.
** Consider the relational database employee (empname, street, city) works (empname, companyname, salary) company (companyname, city) manages (empname, managername). Give an expression in the relational algebra for each request. Find the names of all employees who work for first bank Corporation. Find the names, street addresses and cities of residence of all employees who work for first Bank Corporation and earn more than 200000 per annum. Find the names of all employees in this database who live in the same city as the company for which they work.Find the names of all employees who earn more than every Employees of small Bank Corporation.
** Draw an E-R diagram for core banking enterprise system and identify the derived and composite attributes, the strong and weak entity sets, and relationships.
** Discuss Join Dependencies and fifth Normal Form and explain Why 5NF?
** Describe the components of entity-relationship diagram with suitable example.
** Explain codd’s rule.
UNIT-II
PART-A (TWO MARK) :
** Describe a circumstance in which you would choose to use embedded SQL rather than using SQL alone.
** Why is a key essential? What are the types of keys?
** Define super key and foreign key?
** What are aggregate functions? And list the aggregate functions supported by SQL? Give examples.
** Write a SQL statement to find the names and loan numbers of all customers who have a loan at Chennai branch.
** What is static SQL? How does it differ from dynamic SQL?**
** List the two major problems with processing of update operations expressed in terms of views.
** How do you measure the cost of query evaluation?
** What are the four broad categories of constraints?
** What are nested queries? Give example.
Thanks for this previous question collection.