Build a Website

The project is about a company that works on cars transportation which has a lot of relations with customers and contract with other companies. For example, if a person had an accident while traveling and they needed to transfer their cars to other cities with no worried about it. They could take a train and leave the work for the company. However, we have broken the tables to make it flexible for the car’s company which has a website with a database. The owner of the company has a full control and organized of the database. Also, both employees and users have a limited of accessing to the database. For instance, a customer does not like to travel on cars then they could see the website and register his car to be transferred to where they want. Moreover, the employee could review and approve the operation. Now, the discretion of company tables are, repairs the trucks, insurances, customers, Toyota’s Agent, Availability and kind of cars, employees’ salaries, and transfer charge. The repairs table is about all trucks in the company and what does each truck require to be in the market? For example, oil, wheels, and breaks. The second table is for fees on customers. The third table is about the insurances on cars and employees which charge the company on general. For example, when the date of charge, and how much. The fourth table is about customers’ information. The fifth table is about the big customer as Toyota’s Agent who sells cars across the country. The six table is about kind of cars availability. For example, one customer wants to send the car to another state on short time. So, the charge would be high otherwise the car could be sent with other cars on the big track. The seventh table is about salaries of the employees instated of paperwork. For example, information of employee such as contact information, salary, overtime and bank account to be processed the deposition on the account automatically.