Scribd
Upload
5 views2 pages

Module 1 Questions

This document is a question bank for a Database Management Systems course at City Engineering College, covering various topics related to databases and DBMS. It includes questions on definitions, characteristics, responsibilities of database professionals, advantages of database approaches, and ER diagrams. The document serves as a study guide for students in their fourth semester of Computer Science and Engineering.

Uploaded by

ujwalsgowda2006
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views2 pages

Module 1 Questions

This document is a question bank for a Database Management Systems course at City Engineering College, covering various topics related to databases and DBMS. It includes questions on definitions, characteristics, responsibilities of database professionals, advantages of database approaches, and ER diagrams. The document serves as a study guide for students in their fourth semester of Computer Science and Engineering.

Uploaded by

ujwalsgowda2006
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

CITY ENGINEERING COLLEGE

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

MODULE 1 QUESTION BANK

SUBJECT: DATABASE MANAGEMENT SYSTEMS SEM/SEC: IV SEM C


Section

FACULTY NAME: [Link] D SUB-CODE: BCS403

MODULE 1

1. Define Database and DBMS. With a neat diagram explain the database system environment.
2. Describe the characteristics of the database approach.*
3. What are the responsibilities of the DBA and Database Designer?
4. Discuss the advantage of using Database approach.*
OR
List and discuss the advantages of DBMS over File system.
5. Define Database Model, Schema, Instance and Database state.
6. Explain a three-schema architecture with a neat diagram. Why do we need mapping
between schema levels?*
7. Discuss Database languages and the different types of user friendly interfaces.
8. Discuss some types of database utilities and tools and their functions.
9. Explain the component modules of DBMS and their interaction with the help of a diagram.*
10. Explain different types of attributes that occur in the ER diagram model with examples.
11. Define the following terms
12. Define the following terms: i) Entity ii) attribute iii) entity type iv)entity set
v) key attribute vi) value set v)degree of a relationship type vi) role names vii)
cardinality ratio viii) participation constraints

13. What is meant by a recursive relationship type? Give some examples of


recursive relationship types.

14. What is a weak entity type? Explain the role of partial key in the design of
weak entity type.

15. Explain with an example specialization and generalization.


16. What are the structural constraints on a relationship type? Explain with examples.
ER Diagram related questions
17. Write an ER diagram to represent CAR entity type with 2 key attributes Registration and
Vehicle ID.
18. Write an ER diagram for hospital management considering at least four entities.
19. Draw an ER diagram for an AIRLINES database schema with at least five entities. Also
specify primary key and structural constraints.
20. Design an ER diagram for an employee database with at least four entities considering
all the constraints.
21. Draw an ER diagram of the movie database. Assume your own entities, attributes and
relationships. Draw an ER diagram of an airline reservation system, taking into account
at least five entities. Indicate all keys, constraints and assumptions that are made. 9.
Define snapshot, metadata, intention and database.
22. Draw an ER diagram of Banking System taking into account at least five entities;
indicate all keys, constraints and assumptions that are made.
23. Draw the ER diagram for an Employee database. The constraints are as
follows: An employee works for a department
Every department is headed by a
manager An employee works on one
or more projects An employee has
dependents
A department controls the projects.

You might also like