Database Design and Management Quiz

Given a scenario, design tables for storing data

Given a scenario, identify the appropriate primary key

Given a scenario, choose data types to meet requirements

Given a scenario, design relationships between tables

Normalize a database

Given a scenario, identify data protection measures

Construct and analyze queries that create, alter, and drop tables

Construct and analyze queries that create, alter, and drop views

Construct and analyze stored procedures and functions

Given a scenario, choose between clustered and non-clustered indexes