I am creating a generalized, basic structure for Microsoft Access databases. it looks like this. I want him to have first, second and third general forms to be normal. Not interested in adding more fields because I believe the basics are
Just looking at this picture is it fit with the three rules of being normal? Do not I have any relationships or do I have any data redundancy? Pretty sure it's okay but any feedback would be appreciated!
To answer your question immediately, this is 3 NF.
One of the drawbacks is your question that you will use this information. Careful about the care of the library Why study / curriculum length for a student? What if "biology" is in a record, and the second is "biology" or "biology 101" versus "biology 102"?
What is a list of courses in which there is a list of courses? This will make some other changes in your database design.
What if the student provides his "loan" for the same book? Are you going to push the loan field for that student ID and book, or a Can create new loans records? This leads me towards my next question: What if a book is overdue? I'm not seeing this database in any way that it also handles. This is an important piece in a library's infrastructure (and partly how they earn money).
Hope it helps.
No comments:
Post a Comment