Relationships -May 6, 2022 St. Boniface

Relationships -May 6, 2022 St. Boniface

10th Grade

10 Qs

quiz-placeholder

Similar activities

S4 DDD

S4 DDD

10th Grade - University

14 Qs

Database Fundamentals

Database Fundamentals

KG - University

10 Qs

Databases

Databases

9th - 12th Grade

15 Qs

DBMS-Open Office

DBMS-Open Office

9th - 12th Grade

10 Qs

GCSE Databases & SQL

GCSE Databases & SQL

9th - 11th Grade

14 Qs

Cambridge Nationals: Database Entity Relationship Modelling

Cambridge Nationals: Database Entity Relationship Modelling

9th - 12th Grade

12 Qs

Database

Database

8th - 12th Grade

10 Qs

U2 Normalization

U2 Normalization

10th - 12th Grade

14 Qs

Relationships -May 6, 2022 St. Boniface

Relationships -May 6, 2022 St. Boniface

Assessment

Quiz

Computers

10th Grade

Medium

Created by

Angel Estor

Used 26+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?