Understanding Relational Database Schema: A Comprehensive Overview

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}