It is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
Relationships -May 6, 2022 St. Boniface

Quiz
•
Computers
•
10th Grade
•
Medium
Angel Estor
Used 26+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Relational
Normalization
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
This key play an essential role in database design. One important part of database design is making sure that relationships between real-world entities are reflected in the database by references.
Foreign Key
Primary Key
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A _____ _ works by matching data in key columns usually columns with the same name in both the tables.
Relationship
Normalization
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
This relationship is the most common type of relationship. In this type of relationship, a row in table A can have many matching rows in table B, but a row in table B can have only one matching row in table A.
One to One Relationship
One to Many Relationship
Many to Many Relationship
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In this relationship, a row in table A can have no more than one matching row in table B, and vice versa. The relationship is created if both the related columns are primary keys or have unique constraints.
One to One Relationship
One to Many Relationship
Many to Many Relationship
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In this relationship, a row in table A can have many matching rows in table B, and vice versa. You can create such a relationship by defining a third table.
One to one Relationship
One to Many Relationship
Many to Many Relationship
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In Many to Many Relationship, you create such a relationship by defining a third table, called a ________ table, whose primary key consists of the foreign keys from both tables A and B.
Field
related
Junction
Create a free account and access millions of resources
Similar Resources on Quizizz
8 questions
Terminologies In Database

Quiz
•
9th - 12th Grade
10 questions
Database Relationships

Quiz
•
10th - 12th Grade
15 questions
Database concepts part 1 & 2

Quiz
•
9th - 11th Grade
10 questions
SQL and databases

Quiz
•
KG - 12th Grade
11 questions
SQL

Quiz
•
10th - 12th Grade
11 questions
87. Database - Relational Database Concepts Quiz

Quiz
•
9th - 12th Grade
10 questions
MS Access Database

Quiz
•
KG - University
10 questions
Database

Quiz
•
8th - 12th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
Discover more resources for Computers
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade
65 questions
MegaQuiz v2 2025

Quiz
•
9th - 12th Grade
10 questions
GPA Lesson

Lesson
•
9th - 12th Grade
15 questions
SMART Goals

Quiz
•
8th - 12th Grade