What is Schema

Mujahida Joynab - Feb 16 - - Dev Community

Logical Representation of the database . Relationa
How to represent data logically?
->With table .

Student Roll Number , Name , Address in columns
Course -> Course id , Name , Relation .

This
SQL -> Data definition language .
Create table
Drop table
Schema is table which information is related to each other .
A collection of table . This is just a logical representation of the database .

How is data represented logically?
With tables! Data is stored in a structured format using tables, where:
Columns represent different attributes (like Roll Number, Name, Address).
Rows contain the actual data entries.
Example:
A Student Table may have:

Roll Number Name Address
101 John New York
102 Alice California
A Course Table may have:

Course ID Course Name
C101 Math
C102 Science
SQL (Structured Query Language) - Data Definition Language (DDL):

CREATE TABLE → Used to create a new table.
DROP TABLE → Used to delete an existing table.

What is a Schema?
A Schema is the overall structure of the database, which includes tables and how they are related.

It's just a logical representation, meaning it defines how the data is organized but doesn't store the actual data itself.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .