Data Management and Databases: Competencies and Concepts, Slides of Information Technology

Various aspects of data management and databases, including the physical and logical view of data, data organization, databases and database management systems (dbms), data models, types of databases, and database uses and issues. Students will learn about the distinction between physical and logical views of data, how data is organized into characters, fields, records, files, and databases, the role of dbms, the five data models, and the benefits and limitations of databases.

Typology: Slides

2011/2012

Uploaded on 07/12/2012

vishu
vishu 🇮🇳

4.7

(3)

31 documents

1 / 15

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CE06_PP12-2
Competencies (Page 1 of 2)
Distinguish between the
physical and logical
view of data
Describe how data is
organized: characters,
fields, records, files,
and databases
Describe databases,
database issues, and
database management
systems (DBMS)
Page 332
Docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff

Partial preview of the text

Download Data Management and Databases: Competencies and Concepts and more Slides Information Technology in PDF only on Docsity!

CE06_PP12-

Competencies (Page 1 of 2)

Distinguish between the physical and logical view of data

Describe how data is organized: characters, fields, records, files, and databases

Describe databases, database issues, and database management systems (DBMS)

CE06_PP12-

Competencies (Page 2 of 2)

Describe the five data models: hierarchical, network, relational, multidimensional, and object-oriented

Distinguish among individual, company, distributed, proprietary, and Web databases

Recognize strategic database uses and security concerns

CE06_PP12-

Data Organization

Character

Field

Record

File

Database

CE06_PP12-

Key Field

Unique identifier also

known as primary field

Common examples

Social security number

Driver’s license

Credit card account

CE06_PP12-

Batch Versus

Real-Time Processing (Page 2 of 2)

Real-time processing -- now

CE06_PP12-

Need for Databases

Sharing – one department to another

Security – passwords to access

Less data redundancy

Data integrity

Page 339

Access data entry form Docsity.com

CE06_PP12-

DBMS Structure

Data models define

rules and standards for

data in a database – the

five data models are:

Hierarchical database Network database Relational database Multidimensional database Object-oriented database

CE06_PP12-

Types of Databases

The five classifications of databases include:

Individual or microcomputer database

Company or shared

Operational User

Distributed

Proprietary

Web database

CE06_PP12-

A Look to the Future

Xperanto

Enhancement to searching for data

Access to structured (relational databases) and unstructured data (word processing and spreadsheet files)

CE06_PP12-

Discussion Questions (Page 1 of 2)

Describe the five logical data groups or

categories.

What is the difference between batch

processing and real-time processing?

Identify and define the five part of DBMS

programs.

What are the five types of databases? Why does

more than one kind of database exist?

Page 359 Docsity.com