SYBSc(C.S.) - DBMS

S.Y.B.Sc. (Computer Science)

Data Structures I and  Database Management Systems I

Course Type: Major Core

Course Code: CS-203-MJ-P

Course Title: Lab Course based on CS-201-MJ-T & CS-202-MJ-T

Section II – Database Management Systems I 

1. Data Definition Language commands (Create)-Create simple tables(All Constraints)

2. Data Definition Language commands (Create)-Create more than one table with referential integrity constraint

3. Data Definition Language commands (Alter, Drop)  Data Manipulation Language commands (Insert, Update and delete)

4. Simple queries 

5. Queries with set operations 

6. Nested Queries, Views


Section II – Database Management Systems II 

1.Stored Procedure 

2. Function 

3. Cursors 

4. Error and Exception Handling 

5. Trigger

No comments:

Post a Comment