[Solved] Which SQL structure best shows denormalization? — Ans: CREATE TABLE Sales (SaleID INT, CustomerName VARCHAR(50), ProductName... | SQL

SQL - Database Design and Normalization

Which SQL structure best shows denormalization?

ACREATE TABLE Sales (SaleID INT, CustomerName VARCHAR(50), ProductName VARCHAR(50), Quantity INT)

BCREATE TABLE Sales (SaleID INT, CustomerID INT, ProductID INT, Quantity INT)

CCREATE TABLE Customers (CustomerID INT PRIMARY KEY, Name VARCHAR(50))

DCREATE TABLE Products (ProductID INT PRIMARY KEY, Name VARCHAR(50))

Step-by-Step Solution

Solution:

Step 1: Identify denormalized table structure
Denormalized tables include redundant data like CustomerName and ProductName in Sales.
Step 2: Compare options
CREATE TABLE Sales (SaleID INT, CustomerName VARCHAR(50), ProductName VARCHAR(50), Quantity INT) includes names directly in Sales, showing denormalization; others separate data normalized.
Final Answer:
CREATE TABLE Sales (SaleID INT, CustomerName VARCHAR(50), ProductName VARCHAR(50), Quantity INT) -> Option A
Quick Check:
Denormalized table = CREATE TABLE Sales (SaleID INT, CustomerName VARCHAR(50), ProductName VARCHAR(50), Quantity INT) [OK]

Quick Trick: Denormalized tables store repeated descriptive data [OK]

Common Mistakes:

Master "Database Design and Normalization" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which SQL structure best shows denormalization?