Search Header Logo

WEEK 3-4 ERD Quiz

Authored by Darwin Vargas

Computers

12th Grade

Used 1+ times

WEEK 3-4 ERD Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of an ER diagram?

To define the security measures of a database

To represent entities and relationships in a database

To optimize database performance

To enforce data integrity rules

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a component of an ER diagram?

Entity

Attribute

Relationship

Index

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A primary key is used to:

Uniquely identify each tuple in a relation

Define relationships between tables

Store duplicate data

Represent foreign keys in a schema

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does "cardinality" describe in an ER diagram?

The number of attributes in an entity

The number of tuples in a table

The number of instances of one entity associated with another

The strength of a relationship

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In an ER model, a weak entity:

Has no attributes

Can exist without a strong entity

Depends on a strong entity and uses a foreign key

Is the same as a derived attribute

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of a many-to-many relationship?

Students and their unique ID numbers

Books and their authors (where a book can have multiple authors and an author can write multiple books)

Employees and their supervisors (where an employee has only one supervisor)

Countries and their capital cities

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A foreign key in a relational schema is used to:

Define a unique identifier for each table

Create a link between two tables

Store duplicate records

Represent attributes in an entity

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?