CC207 - FinalQuiz #3

A student's name listed as one of the registrants in a marathon is an example of?

• Field

• Entity

• Record

• File

Which of the following key fields is a primary key?

• Student's surname

• SSS ID number

• Zip Code

• School Address

Commonly use a Crow's foot notation to define the number of occurrences of the entity related to other entities.

• Relationship

• Cardinality

• Degree

• Attribute

A table design contains a repeating group is a process called normalization.

• True

• False

Rearrange the basic steps in building an ERD.

A. Identify the entities

B. Identify Relationships

C. Add Attributes and Assign Identifiers

• A-B-C

• A-C-B

• B-A-C

• C-A-B

Assumptions are an important part of data modeling.

• True

• False

How to identify an Independent Entity?

• when a child does not require attributes from the parent entity

• when a child does require attributes from the parent entity

• a student may take many courses and a course is taken by many students

• none of the above

You can use normalization to validate an ERD.

• True

• False

A table is in first normal form (1NF) if it does contain a repeating group.

• True

• False

It is considered as a blueprint of the system.

• ERD

• Use Case

• CRUD Matrix

• Data Model