Database Design and Normalization

Computer Science

An overview of database management systems, covering relational structures, functional dependencies, normalization forms, and SQL language components.

Databases SQL Normalization

10 Questions Medium Ages 16+ May 7, 2026

Practice Test PDF Answer Key PDF

Choose a Study Format

Quiz

Test your knowledge with multiple-choice questions and instant feedback.

Flashcards

Flip through cards to review terms, definitions and key concepts.

True or False

Quickly decide if statements are true or false to reinforce understanding.

Match Game

Race against time to match questions with their correct answers.

Study Guide

Read through all topics and answers as a comprehensive study reference.

Listen Mode

Listen to questions and answers read aloud — great for audio learners on the go.

Embed This Study Set

Add this interactive study set to your website or blog — all 6 formats included.

<div data-quixly-id="2519"></div>
<script src="https://www.quixlylearn.com/assets/embed/widget.js"></script>

Learn more about embedding →

About this Study Set

This study set covers Computer Science through 10 practice questions. An overview of database management systems, covering relational structures, functional dependencies, normalization forms, and SQL language components. Every question includes the correct answer so you can learn as you go — pick any format above to get started.

Questions & Answers

Browse all 10 questions from the Database Design and Normalization study set below. Each question shows the correct answer — select a study format above to practice interactively.

1 What are the three main types of dependencies in database normalization?

A Full, Partial, Transitive
B Primary, Foreign, Unique
C Simple, Complex, Compound
D Static, Dynamic, Logical

2 Which Normal Form (NF) is achieved when a table has no partial functional dependencies?

A First Normal Form
B Second Normal Form
C Third Normal Form
D Fourth Normal Form

3 What is a Primary Key used for in a database table?

A To define the language
B To uniquely identify each record
C To store multiple values
D To delete the database

4 What does DDL stand for in the context of database languages?

A Data Design Logic
B Database Definition Layer
C Data Definition Language
D Direct Data Link

5 Which SQL command is used to create a new database table?

A MAKE TABLE
B ADD TABLE
C BUILD TABLE
D CREATE TABLE

6 What is the purpose of a Foreign Key?

A To link two tables together
B To calculate totals
C To delete columns
D To encrypt data

7 Transitive dependency occurs when a non-key attribute depends on another...

A Primary key
B Non-key attribute
C Foreign key
D Null value

8 What is a domain in database design?

A The physical server location
B The set of valid values for an attribute
C The name of the database
D The software used to run SQL

9 Normalization is used to reduce which of the following?

A Data redundancy
B Table size
C Query speed
D Disk space

10 What does the CHECK constraint do in a database?

A Deletes old data
B Enforces a condition on column values
C Updates the table schema
D Renames a table

📱

Study on the go

Download Quixly and access all study formats on your phone — anywhere, anytime.