Scribd
Upload
27 views2 pages

DBMS Assignment

The document outlines assignments for a DBMS course, covering definitions of key terms, differences between data and information, and the roles of a DBA. It includes topics on database architecture, data independence, data models, relational algebra, integrity constraints, and E-R models. Each assignment consists of multiple questions aimed at assessing students' understanding of database management systems.

Uploaded by

abdulhussain0886
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
27 views2 pages

DBMS Assignment

The document outlines assignments for a DBMS course, covering definitions of key terms, differences between data and information, and the roles of a DBA. It includes topics on database architecture, data independence, data models, relational algebra, integrity constraints, and E-R models. Each assignment consists of multiple questions aimed at assessing students' understanding of database management systems.

Uploaded by

abdulhussain0886
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

rd

Subject: DBMS (3330703) Semester: 3

ASSIGNMENT: 1
1. Define following terms:
a. Data
b. Information
c. Database
d. DBMS
e. Field
f. Record
g. Files
h. Data Dictionary
i. Data Warehouse
j. Metadata
k. System Catalog
2. Give difference between data and information.
3. Explain advantages and disadvantages of file oriented system.
4. What is DBA? Explain responsibilities of DBA.
5. Explain advantages and disadvantages of DBMS.

ASSIGNMENT: 2
1. Explain 3-tier ANSI SPARC Architecture. Also give advantages.
2. Explain schema, subschema and instance.
3. What is Data Independence? Explain its types.
4. What is Mapping? Explain its types.
5. Explain functions and services of DBMS.
6. List data models and explain Network and Hierarchical Data Model.
7. List database systems and explain Client-Server and Distributed Database
System.

VPMP Polytechnic, Gandhinagar Page 1


ASSIGNMENT: 3
1. Define the following terms:-

1. Relation
2. Attribute
3. Tuple
4. Cardinality
5. Degree
6. Domain
7. Key
2. Define the various types of keys which are used in a relational model.

3. What is Relational algebra? List types of operations.

4. Explain Projection and Selection operation with example.

5. Explain Union and Intersection operation with example.

6. Explain types of Join operation with example.

ASSIGNMENT-4
1. Explain Domain integrity constraints with its type.
2. Explain Entity Integrity constraint with Example.
3. Exaplain Following.

a) Primary Key.

b) Foreign Key.

ASSIGNMENT-5

1. Explain E-R Model Symbols.

2. Explain Specialization with Example.

3. Exaplain Generalization with Example.

4. Draw one E-R Diagram for any System.(i.e. Banking System).

VPMP Polytechnic, Gandhinagar Page 2

You might also like