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.
Top comments (0)