3. Scheduling at the Bank of Tacoma The Bank of Tacoma is open Monday through Friday from 9am to 5pm. From past experience, the bank knows that it needs the number of tellers shown in the table below at various times of the day. Bank of Tacoma hires two types of tellers. Full-time tellers work 9am to 5pm, 5 days a week, with 1 hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 11am and noon, noon and 1pm, or between 1pm and 2pm. Full-time employees are paid $24 per hour, including a paid lunch hour. The bank can also hire part-time tellers. Each part-time teller works exactly three consecutive hours each day, starting at any specified hour (e.g., 10am-1pm), the same time every day of the week. A part-time teller is paid $16 per hour. To maintain adequate quality of service, the bank has decided that at all times there must be at least three full-time tellers working for each part-time teller. Determine how to meet the bank's teller requirements at the minimum cost. Build a linear programming spreadsheet model and solve it using Solver. Tellers Required Time of Day 9am-10am. 10am - 11am 11am-noon Noon-1pm 1pm-2pm 2pm-3pm 3pm - 4pm 4pm-5pm 34686STO 5 10 hhhF Pr

COLLEGE (CollegeName, ZipCode, CarnegieClass)LECTURER (LectureID, Name, Email, PhoneNumber)EXPERTISE (TopicOfExpertise, LevelOfExpertise, LecturerID)CONTRACT (ContractDate, CollegeName, LecturerID, Salary)ZIP (ZipCode, City, State) Also assume that there are frequent queries involving the following information:a. List of colleges sorted by zip code.b. Access to information on a specific lecturer—their name, email address, and phone number.c. List of lecturers sorted by their area of expertise and within each area of expertise, their expertise level.d. List of colleges sorted by their CarnegieClass and within the CarnegieClass by zip code.e. Access to information on a specific lecturer based on their email address. For each situation above, specify the types of index(es) you would recommend. Justify your decisionsbased on the given relational model.

ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear