Database Refreshment

What does ERD stand for?

• Entity-Relationship Diagram

• Excellent Resource Design

• Every Row Depicts

• Extra Relational Data

What is the purpose of normalization in a database?

• Normalize emotions of developers

• Reduce data redundancy

• Improve data integrity

• Make tables pretty

Which normal form eliminates transitive dependency?

• 1NF

• 2NF

• 3NF

• Google Form

What does the acronym DDL stand for in database terminology?

• Data Distribution Layer

• Dynamic Data List

• Database Data Language

• Data Definition Language

In a relational database, a primary key must be:

• A secret code

• Repeated frequently

• Able to unlock a treasure chest

• Unique and not null

Which of these is an example of a many-to-many relationship?

• Employees and Chairs

• Cats and Owners (Cats own you, let’s be real😂)

• Students and Classes

• Managers and Coffee Machines

What is a foreign key?

• A mysterious lost key in the data jungle

• A key from another table

• A key that speaks another language

• A primary key in disguise

What does SQL stand for?

• Spicy Query Linguistics

• Super Quick Logic

• Structured Query Language

• Some Queries Lag

What is a database schema?

• The structure of a database

• A plot to overtake Excel

• A schema to steal your data

• A fancy name for a tablecloth

What is the result of a CROSS JOIN in SQL?

• Two tables arguing over data

• Rows where keys match

• A cross-stitched database

• All possible combinations of rows from two tables