14 -- Information Technology IV

14 -- Information Technology IV - CPA BEC - STUDY UNIT 14...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CPA BEC - STUDY UNIT 14 Information Technology IV: Core Concepts A. Database Management Systems 1. A database management system (DBMS) is an integrated set of software tools superimposed on the data files that helps maintain the integrity of the underlying database. A DBMS allows programmers and designers to work independently of the physical and logical structure of the database. 2. A particular database’s design, called its schema , consists of the layouts of the tables and the constraints on entering new records. To a great extent, a DBMS automates the process of enforcing the schema. The data dictionary contains the physical and logical characteristics of every data element in a database. 3. Those in the IT function responsible for dealing with the DBMS are called database administrators. B. Transaction Processing Modes 1. Batch processing. In this mode, transactions are accumulated and submitted to the computer as a single “batch.” In the early days of computers, this was the only way a job could be processed. 2. Online processing. In this mode, the computer processes each transaction individually as the user enters it. The user is in direct communication with the computer and gets immediate feedback on whether the transaction was accepted or not.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/29/2010 for the course CBEAM BEC taught by Professor Gleim during the Spring '10 term at De La Salle Lipa.

Page1 / 2

14 -- Information Technology IV - CPA BEC - STUDY UNIT 14...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online