|
Students |
|
student_id |
|
students_name |
|
students_address |
|
email_address |
|
other_students_deatils |
|
Books_Out_on_Loan |
|
book borrowing_id |
|
rule_id(FK) |
|
student_id(FK) |
|
isbn(FK) |
|
sys_control_id(FK) |
|
date_issued |
|
date_due_for_return |
|
date_returned |
|
amount_of_fine |
|
Books |
|
Isbn |
|
book_tital |
|
date_of_publication |
|
Books_by_Category |
|
category_id(FK) |
|
Isbn(FK) |
|
Books_by_Author |
|
author_id (FK) |
|
Isbn (FK) |
|
Categories |
|
category_id |
|
category_name |
|
Author |
|
author_id |
|
author_firstname |
|
author_lastname |
|
Library_Rules |
|
rule_id |
|
rule_description |
|
rule_value |
|
System_Control_Parameter |
|
system_control_Parameters_id |
|
overdue_daily_fine |
February 17, 2008 at 4:10 am
sorry not quite correct