The queries you write to create views should be formatted neatly in a style similar to the one used for problem \#1 above: CREATE VIEW AS SELECT , FROM 1> WHERE > IN (SELECT > WHERE 2>; The above sample is provided for formatting purposes only. You will be responsible for ensuring your queries use the correct syntax to answer the problems. 1. Specify the following views in SQL on the COMPANY database (elmasri_company -from exercise 2) schema shown a. A view that has the department name, manager name, and manager salary for every department Use elmasri_company; Create View Manager As Select d.Dname, e.fname, e.Iname, e.salary from department d, employee e where Mgr_ssn=ss; b. A view that has the employee name, supervisor name, and employee salary for each employee who works in the 'Research' department c. A view that has the project name, controlling department name, number of employees, and total hours worked per week on the project for each project d. A view that has the project name, controlling department name, number of employees, and total hours worked per week on the project for each project with more than one employee working on itNot the question youre looking for?Post any question and get expert help quickly.Start learning Chegg Products & ServicesChegg Study HelpCitation GeneratorDigital Access CodesGrammar CheckerMath SolverMobile AppsSolutions ManualPlagiarism CheckerChegg PerksCompanyCompanyAbout CheggChegg For GoodCollege MarketingInvestor RelationsJobsJoin Our Affiliate ProgramMedia CenterSite MapChegg NetworkChegg NetworkBusuuCitation MachineEasyBibMathwayThinkfulCustomer ServiceCustomer ServiceGive Us FeedbackCustomer ServiceManage SubscriptionEducatorsEducatorsAcademic IntegrityHonor ShieldInstitute of Digital Learning 2003-2024 Chegg Inc. All rights reserved.Cookie NoticeYour Privacy ChoicesDo Not Sell My InfoGeneral PoliciesPrivacy PolicyHonor CodeIP Rights