1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA Integrated SEMESTER- II EXAMINATION WINTER 2018
Subject Code: 4420603 Date: 05-01-2019
Subject Name: Fundatmentals of Database Management Systems
Time: 02.30 pm to 5.00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1

Define Following terms.
Domain
Relation
Schema
Data Model
Cardinality
Relational Algebra
Information island
07

Do as directed:
The administrative information stored in data dictionaries is known as
Relational Calculus is a type of system like Relational Algebra.
was the first database model that offered the data security that is provided and enforced by the DBMS.
Four Different Entities are associated with each other is called Relationship.
State True or False: A schema separates the physical aspects of data storage from the logical aspects of data representation.
State True or False: The DML enabled the manipulation of the database contents.
Full Form: BCNF
07
Q.2

Define Data Dictionaries.Describe Benefits of Data Dictionaries in Brief and also Describe Data Dictionary Types.
07

Describe ANSI/SPARC Architecture of DBMS in detail.
07
OR

Describe Dependency Strong and Weak Entity.
07
Q.3

Describe Components of DBMS with Diagram.
07

Describe First Normal Form and Second Normal Form with example in detail.
07
OR
Q.3

Describe Hierarchical Model and Object Oriented Model
07

Write a note on: Decomposition (Lossless-join Decomposition and Lossy-join Decomposition)
07
Q.4

Compare: Simple Attribute v/s Single Valued Attribute v/s Composite Attribute.
07

Write a note on: Integrity Constraints and types (Domain, Entity, Referential and Operational)
07
OR
2
Q.4

Describe E-F Codd Rules Briefly.
07

Compare: Primary Key v/s Alternate Key v/s Candidate Key.
07
Q.5

Describe tuple relational calculus by giving suitable example.
07

Draw E-R diagram for a university
07
OR
Q.5

Draw E-R diagram for a car insurance company
07

Describe RENAME and ASSIGNMENT operation in Relational Algebra.
07