Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Customer(custNr, name, baseLoc,birthDt, gender) Property (propld, locDesc, state, propType, rating) Rental custNr, propld, startDt, totalCost) To make it easier for the grader, use the
Customer(custNr, name, baseLoc,birthDt, gender) Property (propld, locDesc, state, propType, rating) Rental custNr, propld, 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 multiple tuple variables for the same relation; please use something meaningful (e.g. r444). I am showing sample data for your benefit; however, you don't have to do anything with it. Property Table Customer Table propidlocbesc state propType | rating baseLoc | birthot Igender | BEANSBO FIRE Friole Heaven Forest View TX 74 111 Ava Kashun TX 2000-04-01 | M CA 61 222 Can Arch CA 1990-09-11 M HOME333 | Home Alone co 73 333 Pete Moss FL 1992-03-03 M MTNOOD Mountain View 79 444 8111 Board CA 1985-04-04 M NYCCC Times Square NY 96 480 Anita Vacay TX 1975-06-01 F OILAAA 011 Slick TX T 681 555 Perry Scope QUAKELLL Rock N Roll CA M 85 601 E Race RV water Logged Camper FL 991 666 Tom Gunn | NULL NULL SALEE River Shores TX T 91 755 Ray Mee CA SNOWFFF Snowcap Ridge i co 100 777 | Bob Wire OK 1927-04-15 | M 1986-10-01 1965-04-01 1973-07-07 M SNOW Snowy View i co 84 855 Doh CA 1975-04-15 F STARIII Star View i co 72 888 | Penny Lane CA 1990-08-08 F TENTGGG Kamp Komfort i co NULL 890 Anita Break CA 1992-08-09 VACAYIK | Griswold Paradise co 67 901 | Peg Board | NY 1987-04-04 WEST | Desert View TX 95 902 Al B Tross CA 1957-07-12 903 BB Gum NULL NULL 904 Sally Hander 999 | Marcus Absent | NY NY NULL 1999-09-09 | Rental Table: custr propId starte totalCost I custe propid startot totalCost 111 | RV888 2019-09-09 60 777 SNOWFFF 2019-11-02 200 111 SAEEE 2019-09-09 200 777 TENTOGG 2019-11-03 50 111 STARIII 2019-09-09 200 777 WESTHM 2019-11-04 222 NYCCC 2019-11-11 | 200 855 BEANSBD 2019-11-01 68 60 m 222 OILAAA 2019-09-10 80 855 NYCCC 2019-11-13 200 222 RV888 2019-09-09 60 888 HOME 333 2019-12-03 200 222 SAEEE 2019-11-20 200 888 RV888 2019-12-01 200 200 222 VACAYKKK 2019-11-11 50 888 2019-12-02 | 200 200 SAFEE 333 SAEEE 2019-11-07 200 890 HOME333 2019-11-13 200 444 MINCOD 2019-10-10 200 890 RV888 200 2019-11-10 200 444 QUAKELLL 2019-11-15 200 890 444 SAEEE 2019-10-11 200 890 MESTUM STARIII 2019-11-12 600 WESTMMM 2019-11-11 200 444 SNOWNNN 2019-11-14 200 444 STARTIT 901 MTNDOD 2019-11-15 300 2019-10-13 901 QUAKELLL2019-11-17 | 200 444 444 VACAYKKK WESTMMM 2019-11-16 se 901 RV888 2019-11-14 200 2019-10-12 | 50 901 SNOWANN 2019-11-16 200 200 480 OILAAA 2019-11-11 80 902 MTNOOD 2019-11-18 | 600 600 480 SAEEE SAFEE 2019-11.1 200 903 MTNDOO 2019-11-19 | 600 555 BEANSBD 2019-09-09 100 100 904 MTNOOD 2019-11-29 | 600 555 MTNOOD 2019-11-05 200 904 STARIII 2019-11-22 400 555 NYCCC 2019-10-01 200 999 MTNOOD 555 QUAKELI QUAKELLL 2019-12-25 200 99 QUAKELLL | 2019-11-24 2019-12-24 800 60 555 RV888 2019-12-04 200 999 555 STARIII 2019-12-04 RVBBR 2019-11-23 200 600 666 TENTOGG 555 WESTMMM 666 | VACAYKKK 755 RVB 2019-09-09 | 200 2019-10-01 2019-11-11 80 SNOWNNN 999 STARIII 2019-11-01 200 2019-10-01 | 500 999 WESTMMM 2019-11-25 200 se i 2019-11-01 60
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started