This in fact was - and maybe is since it is not complete yet - a very cumbersome task. I had very difficult time normalising the database since I forgot most of the things about normalisation. Honestly I really didn't understand why we have to do this huge task in SDI, this would be more suitable for the database subject, however there were good points about why different database structure is needed for different purpose in organisations which I think is a realistic situation in regards to answering if the task was realistic or not.
As mentioned in the studio, different database structure suits different purpose e.g. for BI purpose or transactional database and they vary in terms of performance or ease of use so re-structuring database seems necessary in order to change the database to suit the purpose.
whether it's done in the way we did or not i.e. manually by hand or by some tools is the answer which I like to know as feedback, however it doesn't seem wise to do it manually unless there is no tool to perform the action.
No comments:
Post a Comment