RDBMS Development using Visual FOXPRO
(for 3rd Semester Students only)

The course is designed to give you an entry into the exciting world of Relational Database Management Systems. The software used will be Microsoft FoxPro 2.6(Windows version), one of the leading RDBMS development systems in the software world. The course will include the following topics :

• Introduction to RDBMS Development.
• Introduction to System Analysis for RDBMS development.
• Introduction to Fundamentals of RDBMS design.
• Basic elements of Visual FoxPro-database, screens, reports, etc.
• Elements of the X-base language.
• Study of "The NIST Librarian(v. 1.0)" software.
• A complete project including system analysis, design and implementation.
• Introduction to ACCOUNTING practice in the Indian context(including accounts, inventory, payroll, etc.).
• Introduction to SQL.
• Import / Export of Database Information.

DURATION : 40 hours or more

Database Development using MS-ACCESS

The course will give you a broad-based introduction to the design and development of database systems .

• Introduction to Database Systems.
• System Analysis for Database Systems.
• Fundamentals of System Design.
• Basic elements of databases in MS-ACCESS - tables, forms, reports.
• GROUP PROJECT (3- or 4 students) -System analysis and design.
• Study of Kalinga Hospital Software.
• Introduction to Accounting Practice -financial accounting, inventory, & payroll.
• Introduction to NIST FINANCIAL ACCOUNTING package.
• Introduction to NIST STUDENT DATABASE.
• Export / Import of data from Database systems.

DURATION : 40 hours or more

INSTRUCTOR: Ms. Geetika Mudali and some experts from the Industry

• Introduction to Systems Design and Systems Development Life Cycle.
• Comparison of Relational, Network and Hierarchical Database Models.
• Data Flow and Systems Flow Diagram.
• Entity - Relationship model and Normalization of Relations.
• Concepts of Client - Server Architecture.
• Introduction to Oracle 7.3.
• Introduction to Cooperative Development Environment (CDE).
• SQL Plus having SQL (Structured Query Language) and PL/SQL (Programming Language) Environment.
• Introduction to SQL and use of SQL( Functions, Single Row Functions, Substitution Variables, Join Methods, Group Functions, Nested Queries, SubQueries).
• Creating, Defining, Manipulating Table Structures and Table Management Concurrency, Locking, Security, Sequences, Indexes and Views.
• Introduction and Use of PL/SQL and interaction with Oracle(Composite Datatypes, Flow Control, Built in Functions, Cursor Management, Exception Handling, Stored Code in database).
• SQL Plus and Reporting Design and Implementation of Projects on Oracle (Using SQLPLUS, FORMS and REPORTS) by Groups of Students.

INSTRUCTOR: Ms. Geetika Mudali and some experts from the Industry

• Introduction to Oracle Forms, Book, Graphics and Reports.
• Running Oracle Forms Application.
• Introduction and use of Blocks, Records and Items(Customizing Forms and Blocks).
• Introduction and Use of Buttons, Check Box, Radio Group, Text, Image, Chart, Display, List.
• Introduction and Use of Window, Canvas, Alert, Editor, LOV, Named Visual Attribute.
• Introduction and Use of Triggers and Built-in PL/SQL Routines ( Components of a Trigger, Creating Triggers, Adding functionality to Items, Transaction Processing).
• Introduction and Use of Global Variable, Parameter, Timer,Relation, Record Group User Interface for the various group.
• Projects developed using Forms 4.0.

Information System for Restaurant Management, Accident Database for IRE, Information System for Insurance Company, Hotel Management, Travel Agency, Vehicle Rental Agency, Hospital Management, Printing Press Management, Video Rental Agency, Drug Store, Inventory Management for Cement and Fertilizer Plant, Information System for a Stationary Wholesaler etc..