DBMS 1st ASSIGNMENT

R.C. Institute of Technology

(Affiliated to Guru Gobind Singh Indraprastha University)

Nazafgarh-43

Assignment:DataBase Management System(MCA-108)                  Date: 4 Feb, 2013

Purpose: This assignment covers questions from unit-I. It will help students to understand-

· ERD:Entity Relationship Diagram

·SQL:Structure Query Lang.

·Basic concepts of DBMS.

·Models in DBMS.

Q1. Draw an ERD of Railway Management system.

Q2. Draw an ERD of University Management System.

Q3.SQL part

(i)Difference Between Primary key and Foreign Key.

(ii) Difference Between Primary key and Unique Key.

(iii) Difference Between Delete and Truncate.

Q4.Explain DR. E.F. Codd 12 rule .

Q5.Explain Model in DBMS.



Deepak Singh
(Assistant Professor)
ID:deepak_rcit@yahoo.com