Data Modeling Quiz

What is the main purpose of and ERD?

• To represent flow of data

• To model and design relational databases

• To represent the structure of a website

• To represent flow of electricity

What is a link entity in an ERD?

• An entity that represents a website

• An entity that represents a system

• An entity to resolve many-to-many relationships

• An entity to resolve 1-to-many relationships

What is the main purpose of a data flow diagram?

• To represent the flow of data in a system

• To model and design relational databases

• To show the flow of electricity

• To show the structure of a website

An ERD is used in primarily which field? (Choose all that apply)

• Software engineering

• Database deisgn

• Business modelling

• Circuit design

A DFD is primarily used in which field?

• Software engineering

• Database design

• Business modelling

• All of the above

Which would NOT likely be an attribute of an entity called “Student”?

• Age

• Student identification number

• Class room number

• Home phone

• Gender

Lines on an ERD diagram indicate____________.

• Hierarchies between processes

• Relationships among the data

• Plurality of data items

• Uniqueness of data items

• Primary keys

For the following two ENTITIES, which is the appropriate relationship:
ZOO / ANIMAL

• One to One
• One to Many
• Many to Many

Primary key is

• A field that uniquely identifies each
  field in a file.
• A field that uniquely identifies each
  record in a file.
• A record that uniquely identifies each
  record in a file.
• A record that uniquely identifies each
  field in a file.

Foreign key is

• Foreign key is a field in the
  table that is foreign key in
  another table.
• Foreign key is a field in the
  table that is record key in
  another table.
• Foreign key is a field in the
  table that is primary key in
  another table.
• Foreign key is a field in the
  table that is column key in
  another table.