Question: Please solve the following sql problem and draw the UML image I will definitely give you helpful evaluation if you finished it, thank you! and

Please solve the following sql problem and draw the UML imagePlease solve the following sql problem and draw the UML imageI willI will definitely give you helpful evaluation if you finished it, thank you!

and billing. The requirements are: - Track the E-Zpass device including the device and issue date. - E-Zpass devices are assigned to vehicles. Track the vehicle license plate, vehicle_type (commerical, passenger, motocycle), manufacturer, model, and color. - One customer can own more than 1 vehicle. Track the customer and E-Zpass device. - The E-Zpass makes payments to credit cards. Track the customer, credit card number and E-Zpass device. - Vehicles travel on roads and bridges that collection tolls using E-Zpass. Track the toll location, E-Zpass device, date of toll collection and vehicle. Create Relations (25 points) - Create relations in the format of relation(attribute1, attribute2, attribute3, etc.) - Only include the attributes necessary to answer the questions. - Create at least 6 relations. If required for your design, you can create more than 6 relations - Identify the primary key. and foreign key attributes for each relation. - Your design must include at least one of the following attribute types: - single value - multi value - composite - derived and billing. The requirements are: - Track the E-Zpass device including the device and issue date. - E-Zpass devices are assigned to vehicles. Track the vehicle license plate, vehicle_type (commerical, passenger, motocycle), manufacturer, model, and color. - One customer can own more than 1 vehicle. Track the customer and E-Zpass device. - The E-Zpass makes payments to credit cards. Track the customer, credit card number and E-Zpass device. - Vehicles travel on roads and bridges that collection tolls using E-Zpass. Track the toll location, E-Zpass device, date of toll collection and vehicle. Create Relations (25 points) - Create relations in the format of relation(attribute1, attribute2, attribute3, etc.) - Only include the attributes necessary to answer the questions. - Create at least 6 relations. If required for your design, you can create more than 6 relations - Identify the primary key. and foreign key attributes for each relation. - Your design must include at least one of the following attribute types: - single value - multi value - composite - derived

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!