Relational Database Schema
Table of Content:
A set of relation schemas {R1, R2,……,Rm
} together with a set of integrity constraints in the database constitutes relational database schema. A relational database schema, say S,
is represented as S
= {R1, R2,……, Rm
).
For example, the relational database schema for Online Book database is a set of relation schemas, namely, BOOK, PUBLISHER, AUTHOR, AUTHOR_BOOK
and REVIEW,
which is shown in below
Hence, the relational database schema for Online Book database can be represented as:
Online Book= {BOOK, PUBLISHER, AUTHOR, AUTHOR_BOOK, REVIEW}