Problem of Normalized Similarity

Question: Discuss about the Problem of Normalized Similarity. Answer: Introduction Auto-Parts Warehouse is an organization that has its business in the supplying of auto parts to its customers. The business is spread across the mid-western metro regions. The primary activity that the organization performs is associated with the delivery of the auto parts that are present in the stock or the ones that can be delivered in a timeframe of few hours. The current system that is followed in Auto-Parts Warehouse for stock and inventory management is not technically advanced. There are various advancements that are required to be done in the field to ascertain that these drawbacks are avoided and the organization has an advanced system in place. The organization is looking to expand and it would therefore be required to have a system that can handle new requirements with ease and perfection. The purpose of the report is to cover the design details of the stock and inventory management system for Auto-Parts Warehouse with the help of the design diagram as Entity-Relationship (ER) diagram and with the concept of normalization as well. Normalization Database Normalization is a set of processes that are used and applied for the organization of data in the database. It is a set of methods and an approach that is used for the decomposition of the tables in the database to remove the redundancy in the data and to also remove the characteristics that are not desired such as various anomalies in terms of insertion of data, update of the data and deletion of the data from the database (Wang, Du and Lehmann, 2010). There are multiple steps that are involved in the process of normalization in order to achieve the aim and objective of the same. The primary objective of normalization is to make sure that the database is free from any of the duplicate data and the dependencies that exist in the database are logical in nature (Attig, 2015). The purpose in this particular scenario is to convert the relation in its third normal form that is 3NF. There are a lot many steps that will be involved in the process. It would be essential to perform each of these steps to convert the relation in its third normal form. 1NF The first normal form is abbreviated as 1NF and for a relation to be in its 1NF, it is essential that the two conditions are met viz. the relations must comprise of the atomic values and there shall also be no repetition of the groups. The term atomic value implies to the value that cannot be divided further. The term repeating groups refers to more than one combination of row and column that has an identical set of values (Chavan, 2012). 2NF The second normal form is abbreviated as 2NF and for a relation to be in its 2NF, it is essential that the two conditions are met; viz. the relation must be present in its first normal form and there shall be no partial dependencies present. The absence of partial dependency in a relation refers to the condition in which all the non-key attributes that are present in the relation must be completely dependent upon the primary key of the same (Deepa, 2014). 3NF - The third normal form is abbreviated as 3NF and for a relation to be in its 3NF, it is essential that the two conditions are met; viz. the relation must be present in its second normal form and there shall be no transitive dependencies present. The absence of transitive dependency in a relation refers to the condition in which if a relation A is completely dependent on a second relation B which is further dependent on a third relation C then C shall not be transitively dependent upon A (Duggal, 2014). Use of Codes The main objective behind the development and usage of code is to come up with maximum cost savings in the domains such as data storage and database space which are the ones that are related with the design of the database. Efficient designing of the database provides a surety that the time period that is spent on the tasks such as storage of data, exchange of data or entry of data comes down by a good percentage. There are also a lot many errors that have been observed at the time of data entry which can also be avoided with the help of the codes. The case of Auto-Parts Warehouse, it is included in the database design that the system will automatically generate an invoice number and this invoice number will be used in trackingRequest table. Invoice and billing are the activities that must be handled with perfection. The step by step and systematic generation of invoices would assure that the process runs effectively and in an organized manner. Also, it would be necessary to ascertai n that the system accepts the data only through data entry operations. These invoices that would be generated will also be applicable in the unique tracking request number. The codes that are available also include alphabetic codes which are put in the code field of the product table. These are further utilized with the codes that are used for maintaining of the sequence. References Attig, A. (2015). The Problem of Normalization and a Normalized Similarity Measure by Online Data. [online] Available at: https://www.ibai-publishing.org/journal/issue_cbr/2011_october/cbr_4_1_3-17.pdf [Accessed 9 Jan. 2017]. Chavan, S. (2012). Study of Various Normal forms and Functional Dependency. [online] Available at: https://www.ijetae.com/files/Volume2Issue7/IJETAE_0712_68.pdf [Accessed 9 Jan. 2017]. Deepa, (2014). An Approach for Normalizing Fuzzy Relational Databases Based on Join Dependency. [online] Available at: https://arxiv.org/ftp/arxiv/papers/1403/1403.2958.pdf [Accessed 9 Jan. 2017]. Duggal, K. (2014). Gamified Approach to Database Normalization. [online] Available at: https://research.ijcaonline.org/volume93/number4/pxc3895505.pdf [Accessed 9 Jan. 2017]. Wang, T., Du, H. and Lehmann, C. (2010). Accounting For The Benefits Of Database Normalization. [online] Cluteinstitute.com. Available at: https://www.cluteinstitute.com/ojs/index.php/AJBE/article/view/371/360 [Accessed 9 Jan. 2017].