Syllabus of Andhra University BTech Information Technology - IT 3.2.8 - DBMS Lab

Third year - Second Semester

Instruction: 3 Periods/week
Univ. Exam : 3 Hours

Sessional Marks: 50
Univ-Exam-Marks: 50

Study features of a commercial RDBMS package such as ORACLE, 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.