Thursday, 4 May 2017

Database Design

This EERD for the Database was created by myself, and agreed upon by the rest of the group.
This EERD suffered many changes throughout the project. I had an initial EERD that was optimised for compatibility with the old Database. Due to complications in importing the old Database, we discarded the EERD and I created a new one (similar to the final one) that took into consideration the fact that we wouldn't be using the old Database, at all, because of the complications with importing the data.
Finally after some more fiddling around, I painstakingly, managed to import the data (after several hours of trial and error, and fixes upon fixes) into a new Database that I had created. Subsequently I modified my previous EERD in order to reflect the subtle changes in the attribute lengths.
Below is a screenshot of the final EERD.

This EERD was made using a program called Visual Paradigm, and therefore follows their UML standards.

No comments:

Post a Comment