Question: There is a database of library.sql which contains 4 tables, namely students, officers, books, and loans Where Student table has the attributes: stuid (primary key)

There is a database of library.sql which contains 4 tables, namely students, officers, books, and loans
Where
Student table has the attributes:
stuid (primary key)
full name
address
the password

Student table has the attributes:
offid (primary key)
full name
address
the password

the books table has the attributes:
bkid (primary)
title
stocks

lending table has the following attributes:
id
stuid (foreign key from student table)
offid (foreign key from officer table)
bkid (foreign key from books table)
borrowing date
date of return

Question:
1. Explain in detail about background of making the database
2. Explain in detail about Benefits and objectives of making the database

Step by Step Solution

3.47 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The question appears to be complete Lets proceed to explain the background and benefits of creating the librarysql database 1 Background of Creating t... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!