Given the below two databases, design a relational database showing how we will link together with at least two other databases. Also Upload a diagram of our design to the discussion board and comment to others on their design.

Data 1 :

For my Data analysis, I chose the Electric vehicle population data. Analysis was based on the comparison between the Electric vehicle type and Electric vehicle range. We used Battery Electric Vehicles (BEV) and Plug-in Hybrid Electric Vehicles (PHEV). The data in the pivot table shows that Battery Electric Vehicles have a higher electric range than Plug-in Hybrid Electric vehicles. BEVs have a higher electric range because they have a bigger battery capacity than PHEVs. For example, the Tesla Model 3 Long Range model has a maximum range of 215 miles on a single charge compared to the Nissan leaf, which has a range of 75 miles because the Tesla Model 3 has a battery capacity of 82 Kilowatt-hour (kWh). In contrast, the Nissan Leaf has a battery capacity of 40 kWh.

Data : 2

The relationship between clean alternative fuel vehicle (CAFV) eligibility and electric range is important, as electric range is a key factor in determining whether or not a vehicle is eligible for CAFV status. Electric range is a measure of how far a battery-powered electric vehicle can travel on a single charge. The higher the electric range, the more likely the vehicle is to be eligible for CAFV status. This is because vehicles with higher electric ranges are able to travel further on a single charge, reducing their emissions and making them more environmentally friendly.

The above table shows the total number of CAFV eligible vehicles based on their electric range. 9617446 vehicles with a higher electric range are eligible for CAFV status while 299537 vehicles with a lower electric range are not eligible. The remaining 0 indicates that eligibility is unknown as the electric range has not been researched. The grand total of all vehicles is 9916983. This table demonstrates that electric range is a key factor in determining whether or not a vehicle is eligible for CAFV status.

Average 'Electric Range' by 'Electric Vehicle Type' 'Clean Alternative Fuel Vehicle Eligible' accounts for the majority of 'Electric Range'. Average 'Electric Range' by 'Electric Vehicle Type' 'Clean Alternative Fuel Vehicle Eligible' accounts for the majority of 'Electric Range