ilable and respond customers at the correct time, periodicity of reports should be dependent on the rentals.Also, because of the electronic form structure of the report, it can be prepared easily whenever a need rises. Figure 4: Car Report2-INTERNAL DESIGNRelational databases provide an easily understood way to combine and manipulate data in multiple files in a database.The managers and employees can access the data directly.The E-R diagrams, identifying the entity types and their relationships, are represented below. (figure 5 and figure 6) 1m m 1 1 m 1 mFigure 5: E-R Diagram for Customer Orders REDUCING E-R DIAGRAM TO TABLESCustomer entity set(Customer ID, Customer Name, Customer Address) Rent Orders(Customer ID, Order ID, Order Date, Customer Name)Cars(Order ID, Car ID, Quantity, Fee, Order Date) Supplier entity set(Supplier ID, Supplier Name, Supplier Address)Purchase Orders(Supplier ID, Order ID, Order Date, Supplier Name)Customers(Order ID, Customer ID, Customer Name, Customer Address)Cars(Order ID, Cars ID, Delivery Quantity)Cars(Cars ID, Car Model)Branchs(Branch ID, Branch Adress)Normalization of TablesReducing E-R diagrams to tables may bring about some problems.The tables should be checked in order to avoid repetition of information and inability to represent of information or loss of information.First norma...
