| MUET / Departments / Computer Systems & Software Engineering / Course of CS / FDB |  |
FILES AND DATABASES Theory (100) Practical (50) FILES AND DATABASE CONCEPTS Traditional File Based System, Database Approach, Database Environment Roles, Advantages and Disadvantages of Database System, Three Level Architecture, Database Languages, Data Models and Conceptual Modeling, DBMS Functions, Multi-user DBMS Architecture, Data Dictionaries; Relational Model, Relational Integrity, Relational Algebra, Relational Calculus, Views, Codd Rule, Database Planning, Entity Relationship Modeling, Structural Constraints, ERD Model Problems, Enhanced Entity Relationship Model, ERD Tools, Normalization, Anomalies, Functional Dependencies, BASIC COBOL ELEMENTS Coding Format, Structure of COBOL Program, Literals, Figurative Constants, Comments, Areas, Divisions, Level Structures, Elementary Items, Group Items COBOL STATEMENTS Arithmetic Verbs, ADD, SUBTRACT, MULTIPLY, DIVIDE, COMPUTE, ROUNDED, Sequence Control Verbs, IF, GO TO, STOP, PERFORM, EXIT, Looping Verbs, PERFORM-TIMES, PERFORM-UNTIL, PERFORM-VARYING INTRODUCTION TO VISUAL FOXPRO Opening and Creating Tables, Using the Command Language, Functions, Date, String, Type Conversion, Variables, Data Types, Indexes and Performance, Local Views and Cursors, Normalization WORKING WITH DATABASE Moving through Database using menu and command, Locate, Seek, Append, Insert, Replace, Replace..For, Deleting Record, Queries, Query Designer, Wizard PROGRAMMING AND DEVELOPMENT Arrays, Code Structures, Debugging and Error Handling,Variables and Parameters OOP CONCEPTS OO Terminology, Inheritance, Encapsulation, Polymorphism, Properties, Events, Methods FORMS, CONTROLS, AND MENUS Access and Assign Methods, Containers, Data Environment, Instantiation, Menu Builder, Methods and Events, Properties, Types of Controls, User Interface NOTE: PRACTICAL WILL BE BASED ON THEORY RECOMMENDED BOOKS [1] R Hutty, “Mastering COBOL”. [2] M.K. Roy, D Ghosh Dastidar, “COBOL Programming Including MS COBOL And COBOL-85”, Second Edition, Tata McGraw Hill Publications. [3] Thane Hubbell, “Teach Yourself COBOL in 24 Hours”, SAMS Publications. [4] Menachem Bazian, Jim Booth, “Special Edition Using Visual Foxpro 6”, Que Publications. [5] Marcia Akins, et al, “1001 Things You Always Wanted to Know About Visual FoxPro”.
|
