Poorly Implemented Database

Mainly here there are five types of database models those are the first one is the flat-file model, the second one is a hierarchical model, the third one is network model, the fourth one is two tables with a relationship, and the final fifth one is an object-oriented model. Here there are some pros and cons those are the pros are here there is no redundancy of data which means there are no relational inconsistencies. Here the performance was fully normalized on the expression of a data model which is very close to compact. The compact has the possible representation for the data items as bytes per unit of information (Hopia, 2016).

Performance is a well known normalized database that is faster than to write and access for some reason as few bytes as per unit of information. The cons of the database are that it is very difficult and expensive; it will require the skills to provide a functional view. The functional view was access to some methods which were comprehensible and streamlined for consumer applications. The database will require discipline to maintain the conceptuality of the current and normalized database. There will be a skill experience to create and manage the view and process to populate it (Guo, 2013).

There will be storing data as in a more optimal way, it takes less space with fewer duplications, and there will be a free form of update and delete anomalies. There are three important data models those are the first one is a conceptual data model, the second one is a logical data model, and the final third one is the physical data model. The normalization is known as the systematic way for ensuring the database structure in a suitable for a general-purpose in an undesirable characteristic. Here there will be a deletion of anomalies which may have to lead to get lost the data integrity, and the normalization will make the relation or the table free form for insert and delete the anomalies for save the space by deleting or removing the data (Yip, 2017).