Introduction to DBMS—SQL
UNIT: 1 Overview of Database Management System :
Introduction to Data and Database system, Elements of Database system, DBMS and its 3-tire architecture, Advantages of DBMS (including Data independence), Types of user, Type of Data Base Administrator and their functions.
UNIT: 2 Data Models:
Type of Data Models, Detailed Study of Relational model (Properties of relational model, key and Integrity rules), Comparative study between different type of data models, advantage and disadvantages of data models.
Management Information System
UNIT: 1 Foundation of Information Systems:
Introduction to information system in business, fundamentals of information systems, solving business problems with information systems, Types of information systems, effectiveness and efficiency criteria in information system.
UNIT: 2 An Overview of Management Information Systems:
Definition of a management information system, MIS versus Data Processing, MIS & Decision Support Systems, MIS & Information Resources Management, End user computing, Concept of a MIS, Structure of a Management information system.
Operating System
UNIT: 1 Introduction:
Operating system and function, the evolution of OS, Operating System services, OS Components. Operating Systems Types: Batch, Time Sharing, Multiprogramming, Multitasking, Multiprocessor, Distributed, Real Time, Network.
UNIT: 2 CPU Scheduling:
Process concept, Process state transitions, schedulers (long term, short term, mid term), Scheduling concept, Performance criteria, Scheduling algorithms, multiple processor scheduling.
System Analysis and Design
UNIT I Introduction
System definition and concepts: Characteristics and types of system, Manual and automated systems
Real-life Business sub-systems: Production, Marketing, Personal, Material, Finance
Systems models types of models: Systems environment and boundaries, Realtime and distributed systems, Basic principles of successful systems
Visual Basic
UNIT I Basics of Visual Basic Language, Requirements for VB 6.0, Tool bars, Menu bars- file, edit, view, project, format, tools, Add- Ins menu, Project explorer, Properties Window, code, form, debug Windows, Immediate debug window, local debug window, watch debug window, tool box window, Adding removing custom control to toolbox, creating and saving a project, Visual Development and event driven Programming, OOPS, Object and classes, Properties, Methods and events