22321 IMP
The principle of database 22321 MSBTE exam likely covers topics related to database systems, which are computer software programs that allow organizations to store, retrieve, and manage large amounts of data efficiently. Some possible topics that may be included on the exam are:
- Introduction to database systems and their role in modern organizations
- Data modeling and database design, including the use of entity-relationship diagrams
- Structured Query Language (SQL) and its use in creating, querying, and updating databases
- Normalization and the use of normal forms to design efficient databases
- Indexing and the use of different types of indexes to optimize database performance
- Concurrency control and transaction management to ensure the integrity and consistency of data in a multi-user environment
- Data security and protection in database systems
- Case studies and examples of different database management systems, such as MySQL, Oracle, and Microsoft SQL Server
1. Attempt any FIVE of the following : 10
Define (1) Data Abstraction, (ii) Data Redundancy.
Define the term Database Schema.
Define the term tuple and domain.
Define primary key and candidate key.
Define constraints, list types
Define Data and instance.
Write Syntax for create table.
List 4 types of Database languages.
Define the term Data Model.
Define the term Foreign key.
Enlist components of database.
Draw and name 4 symbols used in ER diagram.
State any four characteristics of Database.
List any four DBMS softwares.
Define Domain and Attribute.
Define Constraint.
Define Database. List any two advantages of database system.
Define database model.
List advantages of and explain Normalization.
Define Data and instance.
Write Syntax for create table.
Define (i) Data Abstraction, (ii) Data Redundancy.
2. Attempt any THREE of the following : 12
(a) Distinguish between file processing system and DBMS.
(b) Describe object oriented data models.
(c) Construct an E-R diagram for a car insurance company whose customers own one or more cars. Assume suitable attributes.
(d) Describe the three levels of data abstraction with diagram.
(e) Distinguish between network database model and relational database model.
(f) Describe enhanced ER model with the help of example.
(g) Compare file system and database system.
(h) Explain Generalization with example.
3. Attempt any THREE of the following : 12
(a) Explain Entity / Integrity constraints with example.
(b) Explain benefits and drawbacks of Denormalization.
(c) Explain primary key and candidate key with example.
(d) Explain advantages and Describe of centralized and distributed databases.
(e) Explain any four Codd’s rules.
(f) Describe functional dependency with example.
(g) Explain different types of attributes.
(h) Explain different operations performed with Data Definition Language.
4. Attempt any THREE of the following : 12
(a) Describe the first normal form with its example.
(b) Compare Hierarchical Database Model with Network Model.
(c) Explain three level architecture of Database.
(d) Explain client/server database system.
(e) Explain various types of Relational constraints.
(f) Explain BCNF with example.
(g) Explain merits and demerits of Object Oriented Database model.
(h) Draw the symbols used for entity relationship diagram and write their meaning.
5. Attempt any TWO of the following : 12
(a) Consider relation R with five attributes L, M, N, O, P. You have given following dependencies,
L-> M, MN -> P, PO ->L
(i) List all keys for R.
(ii) In what Normalized form R is ? Justify your answer.
(b) Draw ER diagram for Banking system/ Railway Reservation / Library Management / and all System, to represent a customer has account scenario. Identify entities with their attributes and draw a diagram.
(c) Consider a single table consisting following columns. Convert it into 2NF and 3NF.
Table (Supplier_no, Supplier_name, Supplier_city, Order_no, Order_quantity, order_amount, product_code, product_name)
6. Attempt any TWO of the following : 12
(a) Consider ‘student’ database with appropriate details. Write a procedure to manipulate given database by adding, modifying and deleting records.
(b) For each of following relationship indicate type of relationship (l : l, l : m, m : m)
(i) Works in (a relationship between entities dept. and staff)
(ii) Managers (a relationship between entities employee and Manager)
(c) Draw Enhanced ER diagram for loan payment system. Consider following entities :
(i) Loan (Loan_id, Loan_amount, Loan_date)
(ii) Payment (Payment_id, Payment_date, Balance_amount)
(iii) Personal Loan (Personal Loan_no, Interest rate)
(iv) Home Loan (Home loan_no, Interest rate)
Show strong entity set, weak entity set, super class and sub class.
Draw the enhanced E-R diagram for College Management System and show strong entity set, weak entity set, super class and sub class