265 - Text - Chapter 1

265 - Text - Chapter 1 - Chapter 1: Elements of Database...

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

View Full Document Right Arrow Icon
Chapter 1: Elements of Database Systems 1 of 30 ADVANCED SYSTEMS ANALYSIS & DESIGN by: Uday S. Murthy, Ph.D., ACA Elements of Database Systems Learning Objectives After studying this chapter you should be able to: distinguish between the file-oriented approach and the database approach discuss fundamental relational database concepts such as composite and foreign keys specify the types of relationships that can be represented in database systems provide a detailed description of the relational database model discuss database integrity , emphasizing entity and referential integrity in particular explain and provide examples of validation rules in relational database systems discuss how views and permissions can be used to restrict access to sensitive data in relational database systems explain the data dictionary concept describe the types of database languages construct SQL queries to extract information from relational database systems discuss database backup and recovery methods explain concepts such as concurrency control explain in general terms concepts such as the object-oriented approach to developing database systems Over the past several years, accounting systems have been undergoing a major transition. In the 1960s and 1970s, manual accounting systems were replaced by computerized systems. These computerized accounting systems were, for the most part, automated versions of manual accounting procedures. There was no fundamental reengineering of accounting procedures. The 1980s saw the birth of database systems. From the late 1980s to the present, large and medium-sized businesses have come to
Background image of page 1

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

View Full DocumentRight Arrow Icon
Chapter 1: Elements of Database Systems 2 of 30 rely on database systems (relational database systems in particular) for their information needs. This chapter presents the elements of database systems. The popular "enterprise resource planning" (ERP) systems like SAP R/3, PeopleSoft, and Oracle all employ database technology to achieve the goal of seamless cross-functional integration throughout the enterprise. We will first differentiate between the older file-oriented approach and the more recent database approach. Various data structures elements specific to database systems will then be discussed. The major types of database models will then be reviewed. The remainder of the chapter will focus exclusively on the relational database model which has grown to become widely accepted as the platform of choice for robust enterprise applications. File-oriented and database approaches contrasted The early applications of computer technology were in automating transaction processing systems. These early applications were developed using COBOL. Each transaction processing system was created and treated independently with its own set of files and programs. There was virtually no integration across application areas. Most business data processing systems developed in the 1970s and the early 1980s employed this approach. This approach to TPS is referred to as the
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/12/2008 for the course MBA 265 taught by Professor James during the Spring '08 term at CSU Sacramento.

Page1 / 30

265 - Text - Chapter 1 - Chapter 1: Elements of Database...

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

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