SYLLABUS - Diploma CSE 3rd Semester

CHAPTER-1 INTRODUCTION

• ?? Data, Information and knowledge, Increasing use of data as a corporate resource, Data processing versus data management, File oriented approach versus Database Oriented approach to data Management, Different kinds of DBMS users, Types of database languages.

CHAPTER - 2 DATABASE MANAGEMENT SYSTEM.

• ?? What is a database system? What is database? Why database, data independence, Data models: Relational, Network & Hierarchical schema and subschema..

CHAPTER – 3 FOXPRO - RDBMS FEATURES, VIEWING, EDITING AND MODIFYING COMMANDS

• ?? FoxPro - Versions, features, requirement of Hardware and Software
• ?? FoxPro - Menu System, Working with FoxPro 
• ?? Creating Database File Some common operations on dataCREATE, LIST, APPEND, CLOSE, QUIT
• ?? FoxPro - Data Types Viewing And Editing Data
• ?? Data Displaying and Monitoring Commands - DISPLAY, LIST, LOCATE, EDIT, CHANGE, BROWSE, REPLACE, DELETE, RECALL, PACK (All Commands with various Options) Modify Structure, Memo Field And File Utilities
• ?? File utilities in FoxPro - DISPLAY DIRECTORY, COPY, DELETE, RENAME. 

CHAPTER-4 SORTING AND INDEXING OF DATABASE FILES

• ?? Sorting & Indexing Concept
• ?? Sort Commands - Single & Multiple Key
• ?? Advantage & Disadvantages of Sort
• ?? Indexing Vs Sorting, Single & Multiple Key
• ?? Indexing, FIND, SEEK

CHAPTER – 5 FUNCTIONS, MACROS AND PRINTING REPORTS

• ?? Memory Variables, Date & Time Functions And Keyboard Macros
• ?? Memory Variables - Creation and Uses, Simple
• ?? Saving and Restoring Memory Variables
• ?? ?/??/??? Commands
• ?? Time & Date Functions and Commands, Date Arithmetic
• ?? Converting Defining Function Keys
• ?? Keyboard Macros - Creating and Using Mathematical Commands And Functions
• ?? Arithmetic Operations, Mathematical Functions, Mathematical Commands, Statistical Functions. Printing Reports And Labels
• ?? FoxPro Report - its creation, features & Utilities, Preview, Printing Custom Report, grouping & Subgrouping. FoxPro Label - Designing & Printing

CHAPTER – 6 PROGRAMMING WITH FOXPRO

• ?? Concepts of FoxPro commands file, Modify Commands
• ?? Conditioning , Branching and Looping within Program files with Do While Enddo, If - Endif, Scan-Endscan, For - Endfor, Docase-Endcase, Text - Endtext, Executing Commands from
• other command files, Macro Substitution
• ?? Error Conditions And Program Debugging Aids

CHAPTER – 7 HANDLING MULTIPLE DATA FILES AND USER DEFINE

FUNCTIONS

• Handling Multiple Data Files
• ?? Concept of Multiple Database Files - Using multiple database
• ?? Relationing the database - SET RELATION, UPDATE, APPEND FROM, COPY TO, JOIN, Relation Query by Example and SQL Custom Screens & User Define Functions & Other Tools
• ?? Create Custom Screen with @, @_GET, @_EDIT, @_SAY_GET_READ, Creating Box & Lines, User Define Functions, Custom Screen Designing.

CHAPTER – 8 INTRODUCTION TO MS-ACCESS

• ?? An Overview of MS-Access, Its Features, Requirement of Hardware & Software, Primary Keys, Foreign Keys & their relations
• ?? Creating Tables and Database, Various features and Operations of a Form, Creating Forms, modifying & Editing the Forms
• ?? Creating Referential Integrity and Generating Queries
• ?? Attaching, Importing & Exporting Data / Tables from various Database and Files
• ?? Preparing Macros
• ?? Various Types of Reports and their features and utilities
• ?? Creating Crystal Reports