Question: I have a database library.sql in which there are 4 tables, namely students, officers, books, and loans Where Student table has the attributes: stuid (primary
I have a database library.sql in which there are 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. Make Complete Relationship Table (more than 3 tables), may use Visio, MS Word
2. Table Implementation (3 tables only)
please help because I dont understand the question
Step by Step Solution
3.43 Rating (162 Votes )
There are 3 Steps involved in it
The question seems incomplete because it mentions tasks related to database tables but it doesnt specify what exactly is required under Table Implemen... View full answer
Get step-by-step solutions from verified subject matter experts
