Question

you need to create a database for a public library to store book details (write the steps involved and also attach a copy of the screenshot) ​

Answer 1

Answer:

Introduction

Tables

Book_Details

Binding_Details

Category_Details

Borrower_Details

Student_Details

Staff_Details

Student_Details

Shelf_Details

Normalization

ER-Diagram

SQL Command (select, update, insert, delete)

Creating table “Book_Details”:

Inserting Some Data in “Book_Details”

Creating table “Binding_Details”:

Creating Relationship Between Book and Binding Table:

Creating Category Table:

Building Relationship between Book & Category Table:

Creating Borrower Table:

Building Relation Between Book & Borrower Table

Creating Staff Table

Building Relationship between student and Borrower table:

Checking Full Relationship

Adding Shelf Table

Adding Relationship Between Shelf and Book Table

Combined All Relationship

Answer 2

Answer:

v bvvnbfvnnfngngfnnfnfnfnfnfnvnfnvvnnvngngnygn