FILE ORGANIZATION AND DATABASE CONCEPTS

Paper Code: 
BCA 101
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

To develop a conceptual understanding of fundamentals of the electronic data processing system and their application in business.

12.00
Unit I: 

Data Processing Fundamentals: Introduction, Data, Information and Data Processing, Data structure, Need for Data Processing, Data Processing Cycle and Functions (data origination, capture, sorting, merging, calculating, summarizing, managing output-results, storing and retrieving), Methods of Data Processing, Applications of Data Processing, Advantages and Disadvantages of Electronic Data Processing.

Computer Processing Techniques: Introduction, On line, Batch and Real time processing systems, Time sharing, Multi-Programming system, Multi-Processing system, Distributed data processing system.

 

12.00
Unit II: 

File structure: Files, Logical and physical file, Basic File Operations,

Types of Files: Master, Transaction, Transfer, Work, Output, Reference, Dump, Security, Archival

File Organization: File Storage on HDD, Types of File Organizations (Unordered or heap or serial files, Ordered or sequential file, Hash file, Indexed Sequential, Direct access and Random files),  File Performance Measures.

 

12.00
Unit III: 

Introduction to DBMS, File processing systems Vs DBMS Advantages and Disadvantages, Architecture, Data Independence and Database Abstraction,

Data Models: Relational, Hierarchical, Network, Object Oriented Data Model

Database Users: Designer, Application Programmer, Sophisticated Users, End Users

Entity Relationship Diagram: Entity, Relation, Relationship, Weak, Strong Entity, ERD

 

12.00
Unit IV: 

Introduction to RDBMS, Relational Database Components: Data Types, Field Properties, Fields: names, types, properties, default values, format, caption, validation rules.

Data Entry: Add record, delete record, Update Record, Data Sort, Find/Replace, Filter/Select, Re-arrange Columns, Freeze Columns.

Edit Tables- Copy, Delete, Import, Modify table structure. Create a Table in an RDBMS

 

12.00
Unit V: 

Queries & Filter–Difference, Filter Techniques, SQL-DDL, DML, DCL, Constraints, Joins, Operators, Query Functions, TCL.

Introduction to Forms Types of Basic Forms: Columnar, Tabular, Datasheet, Main/ Subforms, add headers and footers, Forms Wizard.

Introduction to Reports, Types of Basic Reports: Single Column, Tabular Report Groups/Total, single table report preview report print report, Report Wizard.

ESSENTIAL READINGS: 
  1. Satish Jain, “Business Systems”, (‘O’ Level Module-2), BPB publications.
  2. Michael J. Folk, Greg, Riccardi ,”File Structure”, Addison Wesley Longman
  3. Reena bharti,”File Organisation and Fundamental Database”,Vision publications
  4. Michael R. Groh ,“Microsoft Office Access 2007 Bible”, John Wiley & Sons, Inc
  5. Korth, Sudarshan, Schilbershatz, “Introduction to Database Management”, TMH
  6. V.K. Kapoor,  “Introduction to Electronic Data Processing”, S. Chand & Sons.

 

REFERENCES: 
  1. Alan L. Tharp, “File Organization and Processing”, Wiley 1 edition.
  2. Steve Lambert, M Dow Lambert,”Microsoft® Office Access(TM) 2007 Step by Step ”, Microsoft Press
  3. Navathe,”Database Management Concepts”, Addison Wesley

 

Academic Year: 
2014-15
  • Printer-friendly version