Question
Please provide SQL statement for the question below: Configure who has been most frequently working as a banner? Please provide a name. To note: Students
Please provide SQL statement for the question below:
Configure who has been most frequently working as a banner? Please provide a name.
To note: Students can lease university flats and some of the details of lease held by students for places in 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 stores addresses of flat university apartment. Banner table use bannerNo as a primary key and stores resident assistant student names. Flat_room tables stores placeNo and flatNo. placeNo as a primary key and flatNo as foreign key.
leaseNo banneriD flatNo flat Address F56 F78 11 Storrie Road, Paisley F79 4 High Streer, Paisley B017706 B017706 88 B01339989 B012124 102 B034511 01/09/2010 109/2011 01/09/2011 01/09/2011 01/09/2012 30V06/2011 30V06/2012 10259 10364 10566 11067 120 Lady Lane, Paisley 0V06/2012 30v06/2013 banneriD fName B017706 ane BO13399 Tom B012124 Karen B034511 Watt Jones Black F78 F78 Figure 14.24 Tables (in 3NF) displaying sample data of university accommodationStep 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