Understanding Relational Database Schema: A Comprehensive Overview

Rumman Ansari   Software Engineer   2024-07-19 02:36:11   7667  Share
Subject Syllabus DetailsSubject Details
☰ TContent
☰Fullscreen

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}