UAS Sistem Basis Data

Quiz
•
Computers
•
University
•
Hard
imam Asrowardi
FREE Resource
Student preview

50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
To resolve a 2nd Normal Form violation, we:
Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity.
Move the attribute that violates 2nd Normal Form to a new ERD.
Do nothing, an entity does not need to be in 2nd Normal Form.
Delete the attribute that was causing the violation.
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
ENTITY: RECEIPT
ATTRIBUTES:
#CUSTOMER ID
#STORE ID
STORE LOCATION
DATE
Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity.
Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.
Do nothing, it is already in 2nd Normal Form.
Delete the attribute STORE ID
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Any Non-UID attribute must be dependent upon the entire UID. True or False?
True
False
4.
MULTIPLE SELECT QUESTION
1 min • 1 pt
A UID can be made up from the following: (Choose Two)
(Choose all correct answers)
Entities
Relationships
Attributes
Synonyms
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?
True
False
6.
MULTIPLE SELECT QUESTION
1 min • 1 pt
Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)
(Choose all correct answers)
Address
Employee ID
Social Security Number
Last Name
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An entity could have more than one attribute that would be a suitable Primary UID. True or False?
True
False
Create a free account and access millions of resources
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)

Quiz
•
8th Grade - University
7 questions
Force and Motion

Interactive video
•
4th Grade - University
36 questions
Unit 5 Key Terms

Quiz
•
11th Grade - University
7 questions
Figurative Language: Idioms, Similes, and Metaphors

Interactive video
•
4th Grade - University
15 questions
Properties of Equality

Quiz
•
8th Grade - University
38 questions
WH - Unit 3 Exam Review*

Quiz
•
10th Grade - University
21 questions
Advise vs. Advice

Quiz
•
6th Grade - University
12 questions
Reading a ruler!

Quiz
•
9th Grade - University