1.1
Overview of business systems (Management functions, Levels of management
and their information requirements).
1.2
Profile of data in business
systems, primary, secondary & historical data for reference and analysis,
need for ensuring accurate, reliable and timely processing of data. Examples of
business data processing and its applications in Payroll, Financial, Accounting,
Inventory, etc.
1.3
Computer System as a potent
tool to meet business data processing needs, facilities available in
computerized systems for: Data capture, online and offline, validation, storage,
processing and output, transmission.
I(13, 14, 20)
2.1
Data structure (Elements, fields, records, fixed and variable lengths,
record layout, data codes – alphabetic, alphanumeric, numeric)
2.2
Files (Content of master file – Information of permanent and
semi-permanent nature, transaction file and transaction file organization,
sequential, relative and indexed,
file creation and handling, file identification – Header label (lebel record),
generation number. File and data
security – retention date, write permission, access control e.g.
passwords, addition and deletion of records-updation, modes of
processing; batch, online and real-time)
2.3
Backup for data security (File corruption potential and data loss. Three generations of back-up (grand father/father/son).
Concepts for file recovery.
3
Principles
and Techniques of Programming
15 hours
3.2
Program definition
3.3
Program life cycle
3.4
Characteristics of a good program
3.5
Data handling
3.6
Introduction to flowcharts
3.7
Operation of file: (input, Output, I/O)
3.8
Concepts of DBMS: (Data definition, Data refinement, Establishing
relationship between fields
3.9
Keywords used for file
processing
3.10
Report production and file
updation
3.11
Learning to make simple
reports with totals
3.12
Overview of control break
procedure for report production
3.13
Multiple handling
3.14
File Updation: (Sequential
file-updation, random updation)
3.15
Modular programming
3.16
Structured approach to
programming
3.17
Checking program design
3.18
Program development process
3.19
Software utilities
3.20
Translators and Assemblers
3.21
Linkers
3.22
Program documentation
4.
FoxPro for Business Systems
15 hours
4.1
Introduction to FoxPro
4.2
Sorting and indexing
4.3
Querying (query with
commands, menu, find and seek vs locate and continue, Set filter fields for
commands, view files
4.4
Queries and reports
(Creating query with RQBE. Add sort order to query result, Select fields for
query result, Change output of query, Save Query, Execute saved query, Modifying
existing theory, Introduction to report generation.
4.5
Window objects in database,
file management commands, macros (Linking, Embedding, Add picture to database,
Add OLE data to database, Edit OLE data, Run command, Copy file command, Define
work areas, Closing database, Copying database structure, Combining files,
Create macros, Save macros, Macro menu option, Rule and limitation of macros)
4.6
Fox Pro Relational Power
(Relational database, Relating files, Create relational reports, Query multiple
database, Relating through view windows, type of relationships One-to-many
many-to-many
4.7
Application creation
(Starting FoxPro, Create screen, Generate application, using application to –
(make changes to records, generate records, other menu options), Run an existing
application, quit application
4.8
FoxPro Programming (Create
command file, Memory variable, operator (mathematical, relational, logical,
string), Functions (eof, of ,date and time, upper, lower, ctod and dtoc, dtos,
space, trim, itrim, str), Commands (set talk, skip, return, accept and input,
count sum-average, @, ?, ??, text
4.9
More on FoxPro Programming (Loop construct): Scan and Endscan,
Do…While, if, else, endif, nested if, case, exit, cancel, wait, zap, Use
macro, Memo field handling, Window, Light bar menu, program code for (data
entry, deleting records, generating reports, send report to printer)
5.
Business Applications
3 hours
Design,
analysis and development of
5.1
(a) Computer Applications in Financial Accounting.
5.1
(b) Computer Applications in Payroll.
5.1
(c) Computer Applications in
Inventory Control.
6.
Implementation of Business Applications
12 hours
6.1
Controls: Input-Output control, File Access control, process control,
Passwords and other security aspects, Job scheduling, Computer log.
6.2
Documentation: Need and philosophy, Updation of documentation, Requests
for change, Monitoring and control
6.3
Management of computer
resources: Centralised traditional data processing department, emerging scene of
distributed processing (user involvement in identifying and organizing for
information needs: centralized management in respect of hardware, software,
personal, data bases, security and policy.)
6.4
System Audit: Need and objective-protecting against risk for loss,
corruption, fraud and sabotage in respect of hardware, software and data; Audit
approaches and methods-systems, financial, hardware, software, place in ADLC,
testing methodologies.
Text Books
I
V.K.
Kapoor, “Introduction to Computer Data Processing & System Analysis”,
Sultan Chand.
II
R.K.
Taxali, “FoxPro 2.5 Made Simple for DOS & Windows”, BPB Publications,
1996.
Reference
Books
1.
Antanowich, “FoxPro 2..5/2.6”, Galgotia, 1996.
2.
Griver, “FoxPro 2.6 Code Book”, BPB Publication, 1994.
3.
James A O’ Bries, “Management Information Systems”, TMH
Publications, Fifth Edition.