Which of the following are steps in designing related tables in a relational database? Select all the options that apply.
A) Design each table to contain fields that describe only one subject.
B) Keep all data in one large table.
C) Identify a primary key field for each table.
D) Build one-to-many relationships between tables.

Question

Quizplus · Accepted Answer

A) Each table should have its own specific purpose, containing fields that pertain only to that subject.
C) Each table must have a unique primary key to distinguish each record from one another.
D) In a relational database, tables are often linked through one-to-many relationships, where one record in one table corresponds to many records in the other table. 
B) Keeping all data in one large table can cause data redundancy and make it difficult to manage the database.

Which of the Following Are Steps in Designing Related Tables