Relational Database and Schemas Video Lecture | SSC CGL Tier 2 - Study Material, Online Tests, Previous Year

let's understand the term schema in
databases in dictionary schema means a
plan structured framework a diagram or
an outline database schema will mean
database plan a database structure
database outline order database diagram
it is a description of the entire
database database schema is specified
when we design a database and we expect
that it will not change frequently
displayed schema is called a schema
diagram let's take an example a company
schema diagram it shows a company plan
the company structure company outline or
a company diagram here it shows all the
tables in this company database even all
the columns of a table are specified the
term relation schema means description
of a relation or a table and the syntax
to specify this relation schema is table
name or relation name in bracket all the
columns separated by comma in problems
you may see this term schema where you
will be asked to write
database schema or you will be given a
relation schema and you will be asked to
write queries on it thank you