plate No availability register No Cars location No dailyPrice costPerMile Name ID creditCardNo M meterReading IName name mName Customers Makes N Rental Caddress Includes phones signedD reserveDate returnDate length OfTime fName agentNum IName name Agents mName phone eMail Task: Write SQL statements to translate the above ER diagram to tables in the ExamDB database. Note that the SQL statements should capture as many constraints (such as the total participation and cardinality constraints) as possible. You should choose a suitable data type and/or data size for each column and be sure to declara prima keys. Then answer the following questions 3.6.

  
 
 
 

Transcribed Image Text:

Name Name name 10 Name Customers ignedD Makes creditCandNo reserveDate ocation returnDate No Rental lengthOffime availabday dailyPrice costPerMile Name Name Name name registerNe meterReading agentNum phone Cars Includes Agents Mail Task Write SQL statements to translate the above ER diagram to tables in the ExamDB database. Note that the SQL statements should capture as many constraints (such as the total participation and cardinality constraints) as possible. You should choose a suitable data type and/or data size for each column and be sure to ferlam nim keys. Then answer the following questions Name Name name 10 Name Customers ignedD Makes creditCandNo reserveDate ocation returnDate No Rental lengthOffime availabday dailyPrice costPerMile Name Name Name name registerNe meterReading agentNum phone Cars Includes Agents Mail Task Write SQL statements to translate the above ER diagram to tables in the ExamDB database. Note that the SQL statements should capture as many constraints (such as the total participation and cardinality constraints) as possible. You should choose a suitable data type and/or data size for each column and be sure to ferlam nim keys. Then answer the following questions