l form:The first normal form is implemented to make all occurrences of relation contain the same number of attributes.In customer orders table, a problem will occur when a customer places in more than one order.Similarly, in the “cars” entity set of the rent orders table, a problem will occur if more than one car is ordered in a single order.The solution is separating the tables.Example:Customer ID Customer Name Order ID Order Date 12 Barış Kk 6,7 23.03.1999,10.04.1999Order ID Car ID Quantity Fee 7102,105 1,2 10.000.000,15.000.000After normalization:Customer ID Customer Name Customer Address 12 Barış Kk Nispetiye Cad.No13 Daire2 R.hisarıstCustomer ID Customer Name Order ID Order Date 12 Barış Kk 6 23.03.1999 12 Barış Kk 7 10.04.1999Order ID Car ID Quantity Fee Order Date 7 102 1 10.000.000 10.04.1999 7 105 2 15.000.000 10.04.1999Second normal formThe second normal form states that a non-key attribute must provide a fact about the whole key, not a subset of the key.In the rent orders table, customer name is dependent on customer ID and independent of order number.In order to remove this kind of drawbacks we can normalize the tables by taking the attribute from the ...
