ICT320 Database Programming

Their current system contains many vulnerability. Their database need to be analyzed in order to identify the flaws. Major flaw areas needs to be improved as well. Their existing database contains 6000-8000 entries that needs to be maintain as well. This enormous number of the entries are creating repeating conflict. The repeated data are also consuming huge amount of unwanted space.  It is essential to remove the repeated data in order to gain more free space. The database performance is also lacking as it is unable to produce the desire result. The database performance can be optimized through de-normalization the tables.

The de-normalized strategies can be used on current normalized tables to optimize the performance as well. Their existing system also use a relation data structure. SQL database needs predefined schema to determine the structure of a database and also all data must follow same structure. For their current approaches the document-based store no SQL is appropriate. It is best suited for the system caused it is able to store document made up of tagged elements. CouchDB is an example of the document-based store database. The implementation of the foreign key is also essential as it could uniquely identifies a record/row in another table.

The unique can be utilized to ensure that all values in a column are different. This approach can stop the amount of repeated data which are most likely caused by not-null and primary constrains.  Their database are embedded with 1NF normalization. The current normalization strategy is not very effective as data repetition is occurring frequently.