chAptEr 11

Question 1

What is a data storage function?

Answer 1

How data is stored and handled
by programs that run the system.

Question 2

Explain the data storage design

Answer 2

Choose data format
Convert local data model into physical data model
Balance DFD & ERD diagrams
Optimize storage

Question 3

List the types of data storage formats.

Answer 3

Files - electronic list of data, sequential order
Database - collection of relational information.
DBMS -software that creates and manipulates data.

Question 4

List the types of files.

Answer 4

Master files -stores core info
Look-up files - stores static values
Transaction files - stores info that can be used to update a master file
Audit files - stores b4 and after images of data
History files -stores past transactions

Question 5

List the different types of databases.

Answer 5

Legacy database - old technology
Relational database - most common
Object database - object-oriented
Multidimensional database - data warehousing
NoSQL database - newest apprach

Question 6

What are the 2 major types of legacy databases?

Answer 6

Hierarchical databases
Network databases

Question 7

What is data warehousing?

Answer 7

Practice of taking and storing data in a large database that supports BI systems.

Question 8

What is a multidimensional database?

Answer 8

It is a database that stores data to support aggregations of data on multiple dimensions.

Question 9

List the different types of NOSQL databases.

Answer 9

Document-oriented databases
Wide column databases
Graph databases

Question 10

List the factors to consider in selecting a storage format.

Answer 10

Data Types
Type of Application System
Existing Storage Formats
Future Needs

Question 11

Study the comparison of storage formats table.

Answer 11

Chapter 11, P20

Question 12

List the steps to create the physical ERD.

Answer 12

Change entities to tables or files
Change attributes to fields
Add primary keys
Add foreign keys
Add system-related components

Question 13

Study the physical ERD.

Answer 13

Chapter 11, P25; YouTube

Question 14

Explain the modifications that may need to be made when
updating the CRUD matrix

Answer 14

Ensure data models (DFD & ERD) and CRUD matrix are aligned.
Design involves translating logical models into physical models for implementation.
System changes (new processes, data stores, elements) require revising the CRUD matrix.