Data Flow Diagramming Quiz

What are the basic principles and design considerations for a DFD?

• Eliminate repeating groups

• Include redundant data

• Use only one symbol

• Have more than seven processes

What do the four symbols in the DFD mean?

• Circle (process), line (data flow), rectangle (external entity), and parallel lines (data store)

• Square (process), arrow (data flow), oval (external entity), and cloud (data store)

• Triangle (process), zigzag line (data flow), hexagon (external entity), and wavy lines (data store)

• Diamond (process), dotted line (data flow), rounded rectangle (external entity), and grid (data store)

How are DFDs similar to flowcharts? How are they different?

• Both represent processes, but DFDs focus on data flows

• Both are used for database design, but flowcharts are more efficient

• Both use the same symbols, but DFDs are more detailed

• Both are used for system documentation, but flowcharts are less structured

What is the purpose of a context diagram in a leveled set of DFDs?

• To display the primary key of each table

• To list all the data stores in the system

• To provide detailed information about each process

• To show the relationship between processes and external entities

What is the primary key in a relational database table?

• A field that uniquely identifies every record within the table

• A field that is shared among multiple tables

• A field that contains redundant data

• A field that is not necessary in database design

What is the purpose of normalization in database design?

• To make the database tables organized efficiently and effectively

• To add redundancy to the data for better accuracy

• To combine all tables into one for simplicity

• To eliminate the primary key from each table

What is the first stage of normalization in database design?

• Fourth Normal Form (4NF) - Combine all tables into one

• Third Normal Form (3NF) - Eliminate columns not dependent on the primary key

• Second Normal Form (2NF) - Eliminate redundant data

• First Normal Form (1NF) - Eliminate repeating groups

Why is a relational database a better tool than a flat file for managing complex data?

• It has fewer tables and fields

• It is easier to create and maintain

• It contains more redundant data

• It allows for efficient storage, retrieval, reporting, and querying of data

Which of the following is most likely to be an external entity?

• People interested in adopting animals

• Animals

• Humane Society staff

• Rancho Cucamonga Humane Society

Which of the following is most likely to be Process 1.0?

• Open from 7 a.m. to 7 p.m.

• Maintain computerized inventory of animals.

• Complete application.

• Review application.