Periods/week : 3 Periods & 1 Tut /week.                                                                  Ses. : 50 Exam : 50 Examination (Practical): 3hrs.                                                                                   Credits: 2

Study features of a commercial RDBMS package such as ORACLE/DB2, MS Access, MYSQL & Structured
Query Language (SQL) used with the RDBMS.( Select two of RDMSs)

Laboratory exercises should include defining schemas for applications, creation of a database, writing SQL queries, to retrieve information from the database, use of host languages, interface with the embedded SQL, use of forms & report writing packages available with the chosen RDBMS product.

Some sample applications, which may be programmed, are given below: Accounting package for a shop,
Database manager for a Magazine agency or a newspaper agency, Ticket booking for performances,
Preparing greeting cards & birthday cards,
Personal accounts – Insurance, loans, mortgage payments, etc., Doctor’s diary & billing system,
Personal bank account, Class marks management, Hostel accounting,
Video Tape library, History of cricket scores,

Cable TV transmission program manager, Personal library.

tejus mahiCSE 3.2 SyllabusIT 3.2 SyllabusCSE,CSE Syllabus,DBMS Lab,IT,IT Syllabus
Periods/week : 3 Periods & 1 Tut /week.                                                                  Ses. : 50 Exam : 50 Examination (Practical): 3hrs.                                                                                   Credits: 2 Study features of a commercial RDBMS package such as ORACLE/DB2, MS Access, MYSQL & Structured Query Language...