Assignment3 University Accommodation Students can lease university flats and some of the details of lease held by students for places irn university flats are shown in Figure 14.24. Lease table use leaseNo as a primary key and bannerID and placeNo as foreign keys. Flat table use flatNo as a primary key and -university stores addresses of flat apartment. . Banner table use bannerNo as a primary key and stores resident assistant student names. o Flat room tables stores placeNo and flatNo as a composite primary key as well as foreign keys to keep track of flat and place(room) association *Note: For each question, you need to provide SQL statements with screenshots No screenshots -3 points; Incorrect answer -3 points per question StartDate & FinishDate Date format- You can change to DD-MMM-YYYY, which is Oracle default