Database Schema
A database schema is the blueprint or structure of a database, defining how data is organized and related. Components of database schema: 1. Tables (or relations): Define the structure of data storage. - Each table represents a single entity or concept (e.g., customers, orders, products). - Tables consist of rows (or tuples) and columns (or attributes). 2. Columns (or attributes): Define the individual elements within a table. - Each column represents a single field or property (e.g., customer name, order date, product price). - Columns have data types (e.g., integer, string, date) and may have constraints (e.g., primary key, foreign key). 3. Data types: Specify the type of data stored in each column. - Common data types include integers, strings, dates, timestamps, and Boolean values. 4. Relationships: Define how tables are connected. - One-to-one (1:1): One row in Table A matches one row in Table B. - One-to-many (1:M): One row in Table A matches m