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 data processing, data representation in computer systems and basics of database management systems 

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: 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: 

Data Representation: Number Systems (Binary, Octal, Decimal, Hexadecimal), Computer Arithmetic Conversions, ‘+’, ‘-‘, ‘*’, ‘/’). Signed Number Representation in Binary Form, Codes: BCD, ASCII, Extended binary coded decimal interchange code, Excess-3, Gray Code, Error detecting and error correcting codes, Representation of characters, integers and fractions, binary and hexadecimal representations, Computer Arithmetic: Addition, subtraction, multiplication, division, simple arithmetic and two’s complement arithmetic, signed number representation, floating point representation of numbers.

 

12.00
Unit IV: 

Introduction to DBMS, File processing systems vs DBMS, Advantages of DBMS. Introduction to MS-Access: An Overview of Access, Access Tables, Data Types.

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

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

 

12.00
Unit V: 

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

Queries & Filter–Difference, Filter Techniques, SQL-DDL, DML, DCL.

Open Source Concepts: Proprietory and Open Source Software, Freeware, Shareware, FLOSS/FOSS, GNU,FSF, OSI,W3C

 

ESSENTIAL READINGS: 
  1. P. K. Sinha & Priti Sinha , “Computer Fundamentals”, BPB Publications, 1992.
  2. Satish Jain, “Business Systems”, (‘O’ Level Module-2), BPB publications.
  3. Michael J. Folk, Greg, Riccardi ,”File Structure”, Addison Wesley Longman
  4. Reena bharti,”File Organisation and Fundamental Of Databases”,Vision publications
  5. Michael R. Groh ,“Microsoft Office Access 2007 Bible”, John Wiley & Sons, Inc

 

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. Norton Peter, “Introduction to Computers”, 6th Ed., TMH, 2006.

 

Academic Year: 
2015-16
  • Printer-friendly version