FDBS Lesson 2 Quiz (Quiz #2)

What does an Entity represent in an ER Model?

• A person, place, thing, or event

• A type of key

• A data type

• A relationship

What is an Attribute in an ER Diagram?

• A property or characteristic of an entity

• A type of relationship

• A database key

• A data table

Which of the following is a correct example of an entity?

• Student

• Name

• ID Number

• Enrollment Date

Which is the correct example of an attribute?

• Student

• Enrollment

• Name

• Course

What does a Relationship show in an ER Diagram?

• How entities are connected to each other

• The data types of attributes

• The design of forms

• The number of attributes

The symbol used to represent entities in an ERD is usually a:

• Circle

• Diamond

• Rectangle

• Triangle

Which symbol represents relationships in an ERD?

• Rectangle

• Oval

• Diamond

• Arrow Lines

What is the Primary Key used for?

• To link data between tables

• To identify each record uniquely

• To count the number of records

• To delete duplicate rows

A Foreign Key is used to:

• Create reports

• Connect data between two related tables

• Identify each row in a table

• Backup the database

Which of the following is TRUE about a foreign key?

• It must be unique in every table

• It can contain duplicate values

• It cannot be null

• It is used only in one table