Get Updates on: WhatsApp YouTube Instagram
1. Attempt any FIVE of the
following : 10
(a) Define the term Database Schema.
(b) List 4 types of Database languages.
(c) Define the term Data Model. *
(d) Define the term Foreign key. *
(e) Enlist components of database. *
(f) Draw and name 4 symbols used in ER
diagram. *
(g) State any four characteristics of
Database.
(h) List any four DBMS softwares.
(i) Define Domain and Attribute. **
(j) Define Constraint. **
(k) Define Database. List any two advantages
of database system.
(l) Define database model.
(m) List advantages of and explain
Normalization. *
(n) Define Data and instance.
(o) Write Syntax for create table.
(p) 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 coloumns. 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.
NOTE: This is Not Official MSBTE Website: We Provide Important Practice Questions for Students to Score Good Marks in Exam and this Questions is based on Important Topics of Syllabus and Repeated Ones. So, with the help of this we help student to Not get KT / or / They will Not get Fail in Exam.