Customer(custNr,
name, baseLoc,birthDt, gender)
Property (propId,
locDesc, state, propType, ra<ng)
Rental(custNr,
propId, startDt, totalCost)
To make it easier for the grader, use
the following tuple variables: Customer – c, Property – p,
and Rental – r. There may be cases where you need mul<ple
tuple variables for the same rela<on; please use something
meaningful (e.g., r444).
Please show an appropriate SQL
SELECT statement to answer each of the following.
Customer(custNr, name, baseLoc,birthDt, gender) Property (propId, locDesc, state, propType, ra
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Customer(custNr, name, baseLoc,birthDt, gender) Property (propId, locDesc, state, propType, ra
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!