|
SEMESTER-III
SPECIALISATION SYSTEMS
**************************************************************************************
MS 124 DATABASE MANAGEMENT SYSTEMS (DBMS-FOXPRO 2.5/2.6)
********************************************************************************
Introduction:-
*************
Introduction to Foxpro, Foxpro navigation commands and screen object handling, data types in foxpro, creating, editing structure of database. Inputting data - APPEND, EDIT commands. LIST, DISPLALY, BROWSE commands with variant scope and conditions. LOCATE-CONTINUE, GOTO. Creating indices-Simple and Compound index files, Structural and compact index files.
Programming in Foxpro:-
*********************
Foxpro editor commands, Input and Output statements, IF-ELSE-ENDIF, counters and accumulators DO WHILE-ENDDO, SCAN-ENDSCAN, FOX-ENDFOR, DO CASE-ENDCASE, DEFINE stmts, ARRAY handling Procedures and Functions, UDFs and Library Functions DBMS related commands, window handlig, Relational capabilities of
Foxpro.
Screen Builder :-
*****************
Creating Data entry screens, Data entry into multiple files, Various code snippets in screen builders, creating Radio Buttons, Push Buttons, Pop Ups, Scrollable Lists, Text Editing Regions, Check Boxes, Hot Keys.
Menu Builder :-
**************
Creating menus, including Foxpro System menu options, Hot Keys, Disabling menu options for some conditions.
Report Writer :-
**************
Using the Report Writer to generate reports, Reporting from multiple files, Reports with multiple level breaks, programming in Reports-creating UDFs.
Query Bulder:-
**************
Creating queries, Querying from multiple database, SQL Select Command, Sending Output of Query to Report, Label, Cursor, Database etc.
MS 125:- SOFTWARE ENGINEERING
*****************************
Software Engineering:-
~~~~~~~~~~~~~~~~~~~~~
Introduction to Software Engineering, why Software development needs an engineering approach, causes of problems.
Software Engineering definition and overview, the various paradigms The Waterfall Model, Prototyping, The Spiral Model, Fourth Generation Techniques.
Project management and Planning :-
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Software Project Estimation, Risk analysis, management and monitoring, Project Planning, Software metrics for Productivity and Quality.
Computer System Engineering:-
Definition, Business system concepts, categories and scope of information systems.
System Development Life Cycle:-
Identification of need, Feasibility Study (technical nad cost-benefit analysis), detailed requirement determination, Fact finding techniques, System and Software requirement Specification documents.
Structured Analysis Development Strategy:-
Data Flow Diagrams (DFDs), rules and norms for preparing DFDs, extensions for data intensive applications, recording control flows in DFDs), Data Dictionary.
Design and Implementation of Software:-
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Design fundamentals, Software architecture and the role of modularity, control hierarchy, data structures, functional independence, cohesion and coupling, data, architectural and procedural design, design documentation, various design methods, User interface design, Real time design.
Software Quality, Testing and Maintenance :-
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Software testing objectives, white box, black box and control structure testing, testing real time systems, the art of debugging.
MS 126 UNIX & 'C'
****************
UNIX
******
Introduction:-
Evolution & History of unix structure of unix functins of various layers.
File System in UNIX:-
*******************
Concept of resource as a file, different kinds of files & their content, Structure of File System in UNIX, Mounting and Unmounting File Systems, Linking Files.
UNIX SYSTEM COMMANDS:-
***************************
Logging in and out, pwd, who, ls, cat, cd, mkdir, rddir, grep, ln, mv, rm, ln, dw, df, touch, find etc.
Editors in UNIX:-
***************
ex and ed editors. Text editing commands. vi Editor. Entering, copying, moving, deleting text in vi, locating a text pattern in vi. Formatting using nr off.
.lm
System Administrator :-
********************
Overview to System Admn. Utilities, creating accounts, resticting access, security in UNIX.
&&&
"C" Language
***********
Structure of C language. Elements of C language, "C" Character set, constants/literals, Reserved Key words, Delimitor, Variable/identifiers, Data types and sizes, variable declarations,labels, expressions, statements and compilation and execution of C programme.
Input/output in C, Convertion specification, d.f.o.x.c.x, input/output functions
Operators and expressions: Arithmatic operations and expression, Relational, logical assignment operator, data type conversion.
Control structures : Unconditional control (got), bi-directional conditional control (if - also) Multidirectional conditional control (switch), loop control (do.. while, for..); Break and continue in loop structure..
Functions: Arrays & Strings; Pointers, Structures and Unions; Files.
**************************************************************************************
|
|
