Data Base Management System LAB [kca-252]

DBMS FILE SYLLABUS FOR AKTU LUCKNOW

1. Installing oracle/ MYSQL.

2. Creating Entity-Relationship Diagram using case tools.

3. Writing SQL statements Using ORACLE /MYSQL:

a. Writing basic SQL SELECT statements.

b. Restricting and sorting data.

c. Displaying data from multiple tables.

d. Aggregating data using group function.

e. Manipulating data.

f. Creating and managing tables.

4. Normalization.

5. Creating cursor.

6. Creating procedure and functions.

7. Creating packages and triggers.

8. Design and implementation of payroll processing system.

9. Design and implementation of Library Information System.

10. Design and implementation of Student Information System.

11. Automatic Backup of Files and Recovery of Files

DOWNLOAD HERE ..................

CLICK DOWNLOAD ICON.....................................

DATA BASE MANAGEMENT SYSYTEM [kca-252].pdf

Download PDF • 2.85MB

....................................................................................................................................