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
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
Get step-by-step solutions from verified subject matter experts
