Entities: Book, Subject, Student and Account information
Attributes: Book ISBN No., Book Title, Book Publisher Name, Book Publishing Date and Year, Book Pages, Subject Category ID, Subject Name, Student ID, Student Name, Student Address, Student E-mail ID, Student Telephone No., Account ID, Borrowing, Returning, Fine Collection.
UnNormalized Entity
|
Book Title |
|
Book Publisher Name |
|
Book Publishing Date and Year |
|
Book Pages |
|
Subject Name |
|
Student Name |
|
Student Address |
|
Student E-mail ID |
|
Student Telephone No. |
|
Borrowing |
|
Returning |
|
Fine Collection |
Normalized Entity
SUBJECT
|
Subject Category ID PK |
|
BOOK ID FK |
|
Subject Name |
STUDENT
|
Student ID PK |
|
BOOK ID FK |
|
Account ID FK |
|
Student Name |
|
Student Address |
|
Student E-mail ID |
|
Student Telephone No. |
Account Information
|
Account ID PK |
|
Borrowing |
|
Returning |
|
Fine Collection |
BOOK
|
BOOK ISBN No. PK |
|
Book Title |
|
Book Publisher Name |
|
Book Publishing Date and Year |
|
Book Pages |
February 17, 2008 at 8:45 am
not quite correct … also additional entities