Electric vehicle charging An electric vehicle (EV) charging station provides charging facilities with different charging rates and costs to the electric vehicles. The charging stations can also be associated with other facilities like cafés and restaurants. Your team is going to be helping to create the technical infrastructure for the charging stations, electric vehicles, and electric vehicle users. As part of this, you will be creating a MySQL database to store this information. The following specifications have been provided to you to assist in your design.

Electric vehicle (EV)Each electric vehicle is associated with a unique vehicle identification number (VIN), manufacturer company, model name, year, capacity of the battery (e.g., 60kW). For each manufacturer company - the name of the company, a unique ABN number, and the current CEO’s name are stored. An electric vehicle is manufactured by only one company, while the company can manufacture multiple vehicles. The system stores the company information of only the companies that manufacture at least one EV. Sometimes an EV manufacturing company is owned by a larger EV manufacturing company. One EV manufacturing company can own multiple companies, but one company can be owned by only one other company. Each electric vehicle is registered with only one person. The system stores information about the registered electric vehicles only (not the unregistered vehicles). For each person, the system stores that person’s (unique) driving license number, their name, and one or more phone numbers. One person can have multiple electric vehicles registered with them.Charging eventThe system maintains the information of all charging events – that is, which electric vehicle is charged at which outlet of a charging station using which coupon (if any). For each charging event, the system stores the start datetime, and the end datetime of the charging. A charging event may or may not use a discount coupon, where the coupon can only be from one of the facilities. Only one discount coupon can be applied for a specific charging event. An EV can charge at the same outlet at a different datetime, which will be considered as a different charging event. While entering a charging station, the driver of each EV needs to provide their information in the system. If the driver’s information has already been in the system (either as a person with whom an EV is registered, or as driver entered before), then the driver only needs to enter their driving licence number. Otherwise, the driver needs to enter the (unique) driving license number, name, and one or more phone numbers. The system also records the entry time. An EV can enter at the same charging station at different datetimes, which will be considered as a different entry event. If all the outlets at a charging station are occupied upon their entry, then the electric vehicles need to wait in a queue. The system records the EVs waiting in the queue for a charging station, capturing their position and arrival time.Please show me the entities, relationships and attributes in this paragraph based on how the database is analyzed

the manufaturing of electric cars, including EV batteries

Text 1The shift towards electric vehicles (EVs) is rapidly transforming the automotive industry. Initially met with skepticism, EVs are now embraced as a crucial step towards reducing greenhouse gas emissions. The major car manufacturers are investing heavily in this technology, predicting that the future roads will be dominated by electric cars. This shift is largely driven by an increasing awareness of environmental issues and advancements in technology that make electric cars more accessible and effective.Electric vehicles offer significant advantages over traditional gasoline-powered cars. They produce zero direct emissions, which reduces air pollution in urban areas. With the enhancement of battery technology, the driving range of EVs has improved, making them a more viable option for long-distance travel. Furthermore, the cost of batteries, the most expensive part of an electric vehicle, has been falling, making EVs more affordable for the average consumer.Governments around the world are supporting this transition. In many countries, there are financial incentives for buying electric cars, such as tax credits and grants. Moreover, infrastructure development is also given priority, with an increasing number of charging stations being installed. Despite this progress, there are challenges. The production of EV batteries has environmental impacts, and the electricity used to charge the vehicles often comes from non-renewable sources, raising questions about how green electric vehicles truly are.Text 2Public transportation systems are the backbone of any major city. Buses, trains, and subways move millions of people daily, reducing traffic congestion and lowering emissions. This system not only provides a cost-effective way for citizens to commute but also minimizes the environmental impact compared to private vehicle use. For urban areas grappling with high pollution levels, enhancing public transport can offer a substantial relief.Many cities across the globe are now focusing on improving their public transportation networks. Upgrading older systems with modern technology helps to ensure reliability and efficiency. Furthermore, many municipalities are integrating eco-friendly practices, such as using electric or hybrid buses, which further contribute to pollution reduction. To encourage more people to use public transportation, governments are also enhancing connectivity and increasing the frequency of service.Despite these benefits, public transportation in many places suffers from underinvestment. Aging infrastructure can lead to delays and frequent breakdowns, which deter people from using these services. Moreover, during peak hours, overcrowding can become a severe issue, impacting the comfort and convenience of passengers. For public transportation to truly compete with private vehicles, these issues need significant attention and investment.Which challenge is mentioned in both texts?ACost of production and maintenance.BEnvironmental impacts of production processes.COvercrowding during peak hours.DReliance on non-renewable energy sources.EUnderinvestment and aging infrastructure.

3 . 5 Table 1 shows data about different ways to power electric cars. Table 1 Hydrogen fuel cell Rechargeable lithium-ion battery Time taken to refuel or recharge in minutes 5 30 Distance travelled before refuelling or recharging in miles Up to 415 Up to 240 Distance travelled per unit of energy in km 22 66 Cost of refuelling or recharging in £ 50 3 Minimum cost of car in £ 60 000 18 000 Evaluate the use of hydrogen fuel cells compared with rechargeable lithium-ion batteries to power electric cars. Use Table 1 and your own knowledge.

use this format "Another problem with electric vehicles is the high purchase price. In addition, the spread of coronavirus and, consequently, the possibility of epidemics in the coming years can lead to a sharp increase in the use of vehicles in municipal services, including waste collection and road cleaning. This paper proposes a mathematical optimization model for locating charging stations with different technologies and vehicle arc routing for waste collection. However, implementing the model proposed in this paper is challenging due to (1) the lack of comprehensive technical knowledge in some countries to provide charging infrastructure, (2) limited electric vehicle companies, and (3) energy supply problems. Some knowledge-based companies and start-ups have succeeded in designing and making charging devices for electric vehicles, reducing the required time to charge vehicles. Nevertheless, the lack of financial resources for research and development is one of the main problems in these companies and start-ups, which can be solved through government subsidies. In addition, allocating government budgets to leading start-ups and companies with electric vehicle production can create a competitive environment, increase competition, and reduce prices. As the cost of electric vehicles decreases, more people can purchase them, increasing the demand for charging. Services will increase. The charging infrastructure development can also increase the demand for electricity generation, which ultimately leads to an increase in the production capacity of power plants that often use fossil fuels—expanding the use of electric vehicles results in producing more bio-pollutants by power plants. One of the best ways to solve this problem is to invest in renewable energy sources, which have received attention recently. In many countries worldwide, suitable conditions are provided for energy production from renewable sources. Therefore, government resources, private sector investment, and public-private partnerships can be useful management solutions." and write a managerial insight on "Routing optimization of an electric vehicle in municipal solid waste using genetic algorithm"