List of Experiments / Activities
- 1Install oracle/ MYSQL.
- 2Create Entity-Relationship Diagram using case tools.
- 3Write SQL statements Using ORACLE /MYSQL: a) Write basic SQL SELECT statements. b) Restrict and sort data. c) Display data from multiple tables. d) Aggregate data using group function. e) Manipulate data. f) Create and manage tables.
- 4Normalization.
- 5Create cursor.
- 6Create procedure and functions.
- 7Create packages and triggers.
- 8Design and implement payroll processing system.
- 9Design and implement Library Information System.
- 10Design and implement Student Information System.
- 11Automatic Backup of Files and Recovery of Files
- Note: The instructor may add/delete/modify experiments, wherever he/she feels in a justified manner.
Course Outcomes (COs)
After completion of the course student will be able to:
- CO1Use the Concept of Data Abstraction and Encapsulation in C++ programs.K6
- CO2Write SQL commands to query a database.K3
- CO3Write PL/SQL programs for implementing stored procedures, stored functions, cursors, trigger and packages.K6
Official AKTU syllabus
This subject is on page 29, 30 of the original AKTU PDF.