Guide to Oracle 10

Guide to Oracle 10g

• Chapter 1:
• Client/Server Databases and the Oracle 10g Relational Database

Objectives

• Guide to Oracle 10g

• Develop an understanding of the purpose of database systems
• Describe the purpose and contents of an entity-relationship model
• Explain the steps in the normalization process
• Describe the differences between personal and client/server databases

Introduction

• Guide to Oracle 10g

• If an organization needs to store and maintain a large amount of data that must be viewed and updated by many users at the same time, it often uses a client/server database such as Oracle 11g.

Database Systems

• Guide to Oracle 10g

• Data files consist of:
• Fields
• Describe characteristics
• Also called columns
• Records
• Group of related fields

Database Systems (continued)

• Guide to Oracle 10g

• Problems with storing data in files:
• Proliferation of data management programs
• Presence of redundant data
• Inconsistent data
• Database
• Stores all organizational data in central location
• Eliminates redundant data to reduce possibility of inconsistent data

Database Systems (continued)

• Guide to Oracle 10g

• Database management system (DBMS)
• Application that performs all routine data-handling operations
• Provides central set of common functions for managing database
• Inserting
• Updating
• Retrieving
• Deleting data values