The discovery of new attributes is a really interesting side-effect of following the process. Great discovery! It helps to confirm my belief that this is worthwhile even when the end result will not be a relational database. The man who taught me systems analysis was fond of observing that companies often called him in to help build a computer system but, quite often, the process led them to realise that it was not a new computer system that they needed but better ways of working in the first place. Until we really understand the human and organizational systems we are trying to computerize we are likely not just to fail but to make things worse than they were before!
Yes - surrogate keys are a great idea once you have a clear and accurate model, but they really get in the way of finding that model!
I like the simple sentence - I've often used the sentence myself when explaining what it is about but have not come across that explicit mapping to normal forms before. Nice! Do share that bookmark via the group bookmarks if you have not done so already - it looks useful.
The Landing is a social site for Athabasca University staff, students and invited guests. It is a space where they can share, communicate and connect with anyone or everyone.
Unless you are logged in, you will only be able to see the fraction of posts on the site that have been made public. Right now you are not logged in.
If you have an Athabasca University login ID, use your standard username and password to access this site.
We welcome comments on public posts from members of the public. Please note, however, that all comments made on public posts must be moderated by their owners before they become visible on the site. The owner of the post (and no one else) has to do that.
If you want the full range of features and you have a login ID, log in using the links at the top of the page or at https://landing.athabascau.ca/login (logins are secure and encrypted)
Posts made here are the responsibility of their owners and may not reflect the views of Athabasca University.