SQL 1 – Assignment

Sub-Module 1 Practice Question

Scenario:
You are designing a database for an online bookstore. You need to ensure that each book has a unique identifier and that prices are correctly stored.

Question:
Which of the following statements about SQL table design is TRUE?

A) Every table must have a PRIMARY KEY to ensure unique records
B) Text columns should always use INT data types for efficiency
C) A table must store only numbers to be valid
D) Data types do not affect performance in SQL

Send in your assignment as a .doc format, with the questions and your selected answer.