SANDIP UNIVERSITY NASHIK

DEPARTMENT OF COMPUTER ENGINEERING & SCIENCE

Subject: Database Management System (YCF403) Class : [Link] (Sem-IV)

Subject In charge: Mr. V. K. Wani Academic Year: 2018-19
Important Questions

UNIT – 1 Introduction to DBMS

UNIT – 2 Constraints & Normalization
UNIT – 3 Introduction to SQL
UNIT – 4 Procedure & Transaction Management
UNIT – 5 Parallel and Distributed Databases

Bloom
Sr. No. Question Marks
Level
Unit-I: Introduction
1 Define Entity, Attributes, Relationships, Constraints, Keys. 1 6
2 Draw and Explain with neat diagram Database System Architecture. 2 4
Compare Relational data model, Hierarchical data model and Network data
3 4 6/8
Model. Which is most suitable according to you?
4 Explain users and architecture of DBA. 2 4/6
5 Explain ER Diagram with example, List &explain E-R Model Components. 2
Explain EER Diagram with example, List &explain EE-R Model
6 2 4/6/8
Components.
What are the various Constraints to convert ER diagram to table. Explain
7 3 6/8
with example for each constraint.
8 Explain Legacy system model. 2 6
Define foreign key, primary key, Candidature key constraints with example
9 2 6
of each.
Identify all the possible Entity & attributes and Dram the following ER
Diagrams
1. Hotel Management System
2. Library Management System 6 For
10 3
3. Hospital Management System Each
4. Car Showroom Management System
5. Software Company System
6 For
11 Convert above ER Diagrams in to Tables 3
Each

Unit-II: Constraints & Normalization

1 List and Explain all Codd's Rules. 2 8
Define: Relational Integrity, Domain, Entity, Referential Integrities, Views,
2 2 8
Enterprise Constraints, Schema Diagram with Example of Each.
3 Define and Explain Referential Integrities 1 4
4 Explain Functional Dependency and Directives with Example 2 6
5 Draw Schema Diagram for Library Management System 3 8
6 What is Normalization? Explain Purpose of Normalization. 2 4
7 Explain Data Redundancy and Update Anomalies with Example 2 4
 What is Normalization? Explain 1NF, 2NF, 3NF & BCNF with example of
8 each. 2 8
9 Explain the various form of Normalization. 2 8
10 Explain lossless join decomposition & dependency preservation with Ex. 2 8
11 Multi valued Normalization write a short note with example. 2 4
12 Convert the given Table in Normal form. 3 6/8

Unit-III : Introduction to SQL

1 What are the Characteristics and advantages of SQL? 1 4
2 What are the various SQL Data Types and Literals? 1 4
3 Write a Short note on SQL. 2 4
4 Explain DDL, DML, DCL, TCL with example 2 8
5 Explain various SQL Operators with example. 2 8
Explain the queries to Creating, Modifying, Deleting Tables also write the
6 3 8
queries to create modify and delete a record for table Student.
Define Views. Explain the queries to Creating, Modifying, & Deleting Views
7 3 6/8
also write the queries to create modify & delete a record for table Student.
8 Define Indexes & Nulls 1 4
9 Explain the various clauses for SELECT Query with example. 3 6
10 Explain the various Set Operations with example. 3 6
11 Explain the Predicates and Joins with example 3 4
Define and Explain Set membership, Tuple Variables, Set comparison,
12 2 8
Ordering of Tuples
13 Aggregate Functions write a short note. 1 4
14 Write a short note on Nested Queries with Example. 2 4
15 Explain SQL Insert, Update and Delete Queries with example 3 6
16 Write a short note on MongoDB 2 4

Unit-IV: Procedure & Transaction Management

1 Define and Explain in short Procedures, Cursors, Triggers, assertions 1 8
2 Define Procedure. How to create a procedure in sql explain with example. 2 6
3 Compare Embedded SQL VS Dynamic SQL 4 4
4 Write a Note on 1. Embedded SQL 2. Dynamic SQL 2 6
5 Explain roles and privileges in SQL. 2 4
6 How to Assign role and privileges in sql Explain with example. 2 8
7 What is Transaction, what are the Properties of Transactions. 2 6/8
8 Write a note on Transaction Management. 2 8
9 Define and Explain Schedule, Serial Schedule. 2 4
10 Write a note on Recoverable and Non- recoverable Schedules 1 6
11 Compare Recoverable and Non- recoverable Schedules 4 6
12 Define the term Conflict and View, Cascaded Aborts 1 6

Unit-V: Parallel and Distributed Databases

1 Define and Explain Locking Methods. 2 6
2 Define and Explain Deadlocks. 2 4
3 List and Explain Time-stamping Methods. 2 6
4 Explain various Optimistic Techniques 2 6
5 List and Explain various Recovery methods. 2 8
6 Compare Shadow-Paging and Log-Based Recovery 4 6
 7 Compare Centralized and Client-Server Architectures, 4 4
8 Explain Centralized and Client-Server Architectures with diagram. 2 8
9 Explain 2 Tier and 3 Tier Architecture 2 8
10 Write a note on Parallel, Distributed and Internet Databases 2 6
11 Compare Parallel Databases and Distributed Databases. 4 4
12 Explain Database Connectivity using Mongo databases. 3 6
13 Explain Key elements of Parallel Database Processing. 2 6
14 Explain Architecture of Parallel Databases. 2 8
15 Explain Architecture of Distributed Databases 2 8
16 Write a note on Distributed Database Design 1 6
17 Write a note on Internet Databases. 1 6
18 Compare Parallel Databases and Internet Databases. 4 4
19 Compare Distributed Databases and Internet Databases 4 4
20 Compare Centralized and Client-Server Architectures 4 4
21 Define Checkpoints. 1 2

Prepared By: Mr. Vipin Wani