Scribd
Upload
0 views2 pages

Imp Question

The document outlines a comprehensive curriculum for a database management course, covering key concepts such as DBMS, database architecture, relational algebra, normalization, query processing, and transaction management. It includes definitions, functions of database administrators, examples of relational operators, and detailed explanations of normalization forms and ACID properties. Additionally, it addresses practical applications and techniques related to database systems.

Uploaded by

hodcse
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
0 views2 pages

Imp Question

The document outlines a comprehensive curriculum for a database management course, covering key concepts such as DBMS, database architecture, relational algebra, normalization, query processing, and transaction management. It includes definitions, functions of database administrators, examples of relational operators, and detailed explanations of normalization forms and ACID properties. Additionally, it addresses practical applications and techniques related to database systems.

Uploaded by

hodcse
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

Unit – 1

1. Define the following terms: (ALL definitions are Important)


a. DBMS
b. Schema
c. Physical Data Independence
d. Logical Data Independence
e. SQL
2. What are the main functions of a database administrator?
3. Explain Database System Architecture levels.
4. Enlist the advantages of DBMS over traditional file system in detail
5. Explain the difference between physical and logical data independence.
6. What is database? List out the applications of database management
system.

Unit 2
7. Discuss any four relational algebra operators with example or Explain
fundamental operators and syntax of relational algebra.
8. Explain Constraints with example.
9. Enlist the relational algebra operators. Explain select and project
operators with example.
[Link] join using relation algebra.
[Link] Cartesian Product operation in relational algebra with example

Unit – 3
[Link] Specialization and Generalization concepts in ER diagram
with suitable example.
[Link] and explain mapping cardinalities of E-R diagram with example
[Link] E-R diagram for (library, hospital school, university… any)
Unit – 4
[Link] normalization? Explain 2NF and 3NF in detail.
[Link] 1Nf, 2NF, 3NF with example.
[Link] Functional Dependency and explain trivial and non-trivial FD

Unit – 5
[Link] short note on query processing.
[Link] Join and its types in SQL.
[Link] various steps involved in query processing with example.
[Link] query optimization with diagram.
[Link] typical query processing strategy of DBMS?
[Link] view serializability concept in detail.
[Link] the techniques to obtain the query cost. Explain any on.

Unit – 6
[Link] is transaction? List and explain ACID property of transaction with
respect to database transaction.
[Link] various state of transaction in detail.
[Link] the two-phase locking protocol in detail.
[Link] ACID properties in transaction processing.
[Link] is Trigger? Explain with example.
[Link] two-phase commit protocol.
[Link] is log-based recovery? List and explain various fields use in log
records for log-based recovery.

You might also like