FYBCS
Semester- I Paper - III
Course Type: Core Credit Course Code:CS103
Title : Practical course on Problem Solving using Computer and ‘C’ programming and Database Management Systems
Teaching Scheme 3 Hrs / week
No. of Credits 1.5
Examination Scheme IE : 15 Marks UE: 35 Marks
List of Assignments:
B) Database Management Systems
To create simple tables with only the primary key constraint ( as a table level
constraint & as a field level constraint) (include all data types)
To create more than one table, with referential integrity constraint, PK constraint.
To create one or more tables with following constraints, in addition to the first two
constraints (PK & FK)
a. Check constraint
b. Unique constraint
c. Not null constraint
To drop a table, alter schema of a table, insert / update / delete records using tables
created in previous Assignments. ( use simple forms of insert / update / delete
statements)
To query the tables using simple form of select statement Select <field-list> from
table [where <condition> order by <field list>] Select <field-list, aggregate functions
> from table [where <condition> group by <> having <> order by <>]
To query table, using set operations (union, intersect)
To query tables using nested queries (use of ‘Except’, exists, not exists, all clauses
To create views.
Semester- II Paper - III
Course Type: Core Credit Course Code:CS203
Title :Practical Course on Advanced ‘C’ Programming and Relational Dstabase Management Systems
Teaching Scheme 3 Hrs / week
No. of Credits 1.5
Examination Scheme IE : 15 Marks UE: 35 Marks
List of Assignments:
B) Relational Database Management Systems:
1) A Simple Stored Procedure
2) A Stored Procedure with IN, OUT and IN/OUT parameter
1) A Simple Stored Function
2) A Stored Function that returns
3) A Stored Function recursive
1) A Simple Cursor
2) A Parameterize Cursor
1) Simple Exception- Raise Debug Level Messages
2) Simple Exception- Raise Notice Level Messages
3) Simple Exception- Raise Exception Level Messages
1) Before Triggers (insert, update, delete)
2) After Triggers (insert, update, delete)
Online PgSQL Editors and Compilers to compile and edit your Queries here :
No comments:
Post a Comment