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
10 questions
Database

Quiz
•
8th - 12th Grade
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
Popular Resources on Quizizz
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

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

Quiz
•
10th Grade