|
Student |
Library |
||
|
Roll Number |
PK |
Library catalog number |
PK |
|
Name |
Roll no |
FK |
|
|
Email Address |
Date issued |
||
|
Phone number |
Date to be returned |
||
|
Late fine outstanding |
Quality of the copy |
||
|
Book |
|||
|
Book ISBN |
PK |
||
|
Library catalog number |
FK |
||
|
Book title |
|||
|
Book author |
|||
|
Book price |
SE Assignment2 Part 1
The URI to TrackBack this entry is: http://nidhirajani.wordpress.com/2008/02/11/se-assignment2-part-1/trackback/
almost there but not quite …
each book could have multiple copies of different quality .. so you need another entity