Ict320 Database Programming For The Assessment Answer

Australian Zoo wildlife Hospital database schema is very old and full of vulnerability. It is facing enormous issues and very far from efficient for them. Their current database schema are facing issues such as data repetition and data loss. So the existing system needs to implement in order to make it effective. The effective system must be loss-less and no data should be over written. After analyzing the whole systems some flaws are identified. The existing system contains more than 6500 entries. This vast amount of data is producing data repetition. This repeated data is also responsible for wasting huge amount of space. The repeated data are also preventing the system to run optimally. This repeated data must be removed in order to free those reserve space. The existing system is also needs to be optimized in order to make it more efficient for them to use. It is lacking to produce the desired result.as necessary. For more optimized system de-normalization strategies must be utilized on the current normalized tables. Their existing database also following the relation data structure. The use of no sql can be more effective to implement the database.

There are certain disadvantage of using sql as it required predefined schema and all the data should follow the same structure. There are also several type of no-sql available. However, document-based store can be more efficient for their database. This type of no-sql will be appropriate as it is capable of storing document which are made up of tagged elements. COUCHDB is most popular example of this type. Their current data set does not support multi constrains as there is no foreign and unique key available. The implementation of foreign key and unique is essential in order to optimize the performance. Their current database is normalized in 1NF. This is one og the reason of data repetition.