Please answer CLEARLY and LEGIBLE

Also give SQL code when needed.

Assume that the University designs a database with the following tables: (Primary keys underlined, foreign keys are in italics) STUDENT (StdNo, StdFName, StdL Name, StdCity, StdState, StdZip.StdMajor, StdClass StdGPA.) Example: StdNo StdF Name Stdl Name 123-45- Homer StdCity StdState StdZip StdMajor StdClass StdGPA Seattle WA Wells 981211- ICS FR 3.00 ENROLLMENT (OfferNo. StdNo, EnrGrade) Example: Offer No 1234 StdNo 123-45-6 EnrG 3.3 COURSE(CourseNo. CrsDesc, CrsUnits) Example: CrsUnits CrsDesc Fundamentals of Finance FIN300 OFFERINGC OfferNo, Course No, OffTerm, OffYear, OffLoc., Offlime, FacNo, OffDays) Example: OfferNo Course No Offferm OffYear OfLoc OffTime FacNo OfDa 1111 IS320 SUMMER 2013TCH33 10:30AM 1234 IS320 FALL 20 MW 12 TECH335 10:30AM 098-76 MW FACULTY(FacNo. FacFName, FacLName, FacCity, FacState, FacDept, FacRank, F FacSupervisor, FacHireDate, FacZipCode) Example: acSalary FacNo FacFName Fac Name FacCity FacState FactDept FacRank FacSalary ASST $65,000 098-76 Leonard Vince Seattle WA MS FacSupervisor 654-32 FacHireDate 10-Apr-2012 FacZipCode 98111