Best Practices for Creating Tables in SQL Server

Design a Product Table

Create a SQL Server table named Products with columns for ProductID, Name, Description, Price, and StockQuantity. Apply appropriate data types, primary key, and constraints.

Expected output: A CREATE TABLE statement defining the Products table with proper keys and constraints.

Hint: Use INT for IDs, VARCHAR for text, DECIMAL for price, and ensure Price and StockQuantity cannot be negative.

Add Indexes to an Existing Table

Given a Customers table, write SQL statements to add a non-clustered index on the Email column and a clustered index on CustomerID.

Expected output: SQL statements creating the specified indexes.

Hint: Use CREATE INDEX and specify the index type.

A primary key uniquely identifies each row in a table, ensuring data integrity and enabling efficient indexing and relationships with other tables.

Choosing appropriate data types optimizes storage, improves query performance, and prevents data conversion errors.

Normalization organizes data to reduce redundancy and dependency, which improves data consistency and simplifies maintenance.