WorksheetsCC207 - FinalQuiz #3
Total questions: 10
Worksheet time: 10mins
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
