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 image
I 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
Get step-by-step solutions from verified subject matter experts
