VEER NARMAD SOUTH GUJARAT UNIVERSITY, Surat
D. C. A. (1st SEMESTER) SYLLABUS
Effective From : August – 2006 (L : 4; P : 0)
PAPER NO. : 102
Paper Title : DATA BASE MANAGEMENT SYSTEM (DBMS)
Prerequisite : Nil
Aim & Objective : To understand Data Base Concepts & develop programming skills on DBMS Package.
1. Basic Concepts of Database Management System
1.1. Purpose of Database Systems
1.2. Data Models
1.3. Data Definition & Manipulation Language
1.4. Database Administrator
2. Data Base Package (FoxPro)
2.1. Data Base, Records, Fields
2.2. Operators
2.3. Data Base & Array Handling:
2.3.1. Creation
2.3.2. Modification
2.3.3. Processing
2.4. Inbuilt Functions, User defined functions & Procedures
2.5. SET Commands
2.6. Working On LAN
2.6.1. Exclusive use of Database Files
2.6.2. Working with shared Database Files
2.6.3. Locking Records & Files
Reference Books:
1. Database Concepts & Systems, 2/ed – Bayross, O’Reilly, Shroff Publishers & Distributors Pvt. Ltd.
2. FoxPro 2.5 made Simple; R. K. Taxali, BPB Pub.
3. Mastering FOXPRO - 2.5 - Charles Siegel
4. Programmer's guide to FOXPRO 2.5 - Howard Pickler, BPB Pub.
For more details, visit http://www.sgu.ernet.in
|
No responses found. Be the first to respond and make money from revenue sharing program.
|