DBMS Open Course

Syllabus

                 5D03CSC Database Management System 

Contact Hours/Week: Theory 2 Credit: 2 

Module I

    Introduction–Field,Record,Entity,Attribute,Relation,Domain,Tuple-Advantages of database systems- data models (Network model, Hierarchical Model, DBTG CODASYL model, Relational Model(E-R)) - system structure.

Module II 

    Database administrator- data base users, Constraints(Primary, Foreign, Candidate, Unique)Relational Algebra (Union, Intersection, Difference, Product, Project, Selection).

Module III 

        Normalization (First, Second, Third, Fourth, BCNF),SQL: Introduction To SQLables DDL, DML, DCL (In Detail),Data Types. 

Module IV 

        SQL Functions(Different Types of Functions),Operators(Arithmetic, Relational, Logical), Sub Quires (in Detail),Clauses(Having, Group By) 

Module V

         Joins(Different Types of Join Statements),View, Introduction to Sequence, Index and Triggers . 

Textbook: 

1. Data Base Concept 3rd edition Abraham Silberschatz, Henery f Korth McGraw Hill 

2. A Guide to the SQL Standard, C. J. Date and Hugh Darwen, 1997, Addison-Wesley

Model Question Paper

5D03CSC Database Management System 

Time: 2 Hrs                                                                                                    Max. Marks: 20

SECTION A

 1. Answer in one word (8 x 0.5 = 4 marks)

a. The collection of information stored in the database is called…………. 

b. The data hold across the primary key column must be unique

c. -------------- is the total no. of entity sets participating in a relationship 

d. foreign Keys represent relationships between tables. 

e. The structure of database is………………..

f. relationship is the association among several entities. 

g. For each attribute there is a set of permitted values is called domain 

h. An entity set without having a primary key is called weak entity set

SECTION B 

Write short notes on ANY THREE of the following questions (3x 2 = 6 marks) 

2. Explain about INSERT command? 

3. What is the usage of CREATE command? 

4. Which are the different types of attributes?

5. Explain UPDATE command. 

6. Define foreign key. 

SECTION C 

Answer ANY T WO of the following questions (2x 3 = 6 marks) 

7. Explain the advantages of DBMS? 

8. Which are the different types of keys? 

9. Explain components of SQL? 

10. Write a note on ALTER command? 

SECTION D 

Write an essay on ANY ONE of the following questions (1 x 4 = 4 marks) 

11. Explain ER data Model. 

12. Write a detailed note on normalization

How To write the exam

1. Write a short note on ddl command

     a. write what is ddl

     b. 3 commands 

            create

             alter

             drop

     c. write syntax of each command

     d. example

2. Write a short note on DML command

     a. write what is dml

     b. 3 commands 

            update

             delete

             insert

     c. write syntax of each command

     d. example

3. Write a short note on DCL command

     a. write what is dcl

     b. 2 commands 

            grand

             revoke

     c. write syntax of each command

     d. example

4. What is Normalization

     a. write what is normalization

     b. 1nf 2nf 3nf bcnf

     c. write about each normal form

     d. example

5. Write UPDATE command

    a. comes under DML

    b.  write intro of DML

    c. Syntax of Update

    d. Example