Normalisation
By kartiksinh
|
|
|
|
|
| Unnormalized Form |
|
|
3NF |
|
|
|
|
|
|
| name |
|
STUDENT |
|
BOOK_LIST |
| emial_id |
|
roll_no PK |
|
library_catalog_no PK |
| phone_no |
|
name |
|
quality_of_book |
| late_fine_outstanding |
|
email_id |
|
no_of_copies |
| book_isbn |
|
phone_no |
|
|
| library_catalog_no |
|
late_fine_outstanding |
|
|
| book_title |
|
|
|
|
| book_author |
|
BOOK |
|
ISSUE_DETAILS |
| book_price |
|
book_isbn PK |
|
issue_id PK |
| quality_of_book |
|
library_catalog_no FK |
|
roll_no FK |
| no_of_copies |
|
book_title |
|
library_catalog_no FK |
| issue_date |
|
book_author |
|
issue_date |
| return_date |
|
book_price |
|
return_date |
|
|
|
|
|
This entry was posted on February 11, 2008 at 6:30 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
February 17, 2008 at 8:12 am |
almost correct … the book list should have book ISBN as the FK and not the other way around. book does not need a copy to exist. a copy needs the book to exist