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 (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The question is incomplete because it lacks clarity regarding the ... 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!