Database design is important in business software development since virtually every business application uses a database management system. Databases have to be normalized to the third normal form (3NF) when relational database management systems are used. Databases not normalized to 3NF will stumble upon insertion, deletion, and updating anomalies.
Here I am presenting a 3rd Normal form of Library Information system.
Attributes: Roll No., Name, e-mail Address, Phone No., Late fine outstanding, Book title, Book Author, Book ISBN, Book Price, Library catalogue No., Quality of copy, Date Issued, Date of Return.
Entities: Account, Member, Book, Title, Issue
| Account | |
| Library ID | PK |
| Roll No. | FK |
| Late Fine Outstanding | |
| Member | |
| Roll No. | PK |
| Name | |
| E-mail Address | |
| Phone No. | |
| Book | |
| Catalogue No. | PK |
| Library ID | FK |
| Book ISBN | FK |
| Quality of Copy | |
| Issue ID | FK |
| Issue | |
| Issue ID | PK |
| Date Of Issue | |
| Date of Return | |
| Title | |
| Book ISBN | PK |
| Book Title | |
| Book Author | |
| Book Price |
good attempt but not quite correct …