How to Convert stuff into 3rd national form…
February 11, 2008
Guys, as part of the how to do series…this week we shall learn how to convert data into third national form. For this purpose we will take up the example of a library data that is present in an un-normalised form and then try and convert it into 3rd national form…
The attributes:
|
Roll No. |
|
Name |
|
|
|
Address |
|
Phone no. |
|
Late fine outstanding |
|
Book title |
|
Book Author |
|
Book ISBN |
|
Book price |
|
Library catalogues no |
|
Quality of copy |
|
Date issued |
|
Date of return |
Now, the next step is to identify certain entities and distribute the attributes to them. The one’s highlighted in green below are the entities.
|
Student |
|
Roll No. (Primary Key) |
|
Name |
|
Late Fine Outstanding |
|
Email-id |
|
Phone no. |
|
Book |
|
Book ISBN (Primary Key) |
|
Library catalogue no. (Function Key) |
|
Book Title |
|
Book Author |
|
Book price |
|
Book List |
|
Library Catalogue no (Primary Key) |
|
Quality Of Book |
|
No. Of Copies |
|
Issue Details |
|
Issue Id (Primary Key) |
|
Roll No (Function Key) |
|
Library catalogue no (Function Key) |
|
Issue date |
|
Return date |
That’s it folks…until next time….Keep the faith..
Entry Filed under: Uncategorized. .
Trackback this post | Subscribe to the comments via RSS Feed