Show all female’s first names and their salary. Show the branchno that has a supervisor whosesalary is greater than 15000.Show the first name and birthday for all femalestaff whose birthday is before 1950-01-01.List of monthly salaries for all male staff,showing the staff number, the first and lastnames, and the salary details. | staffNo | fName | 1Name | position| MaryHoweFord| Assistant FSupervisor | M| David| Beech | Assistant | FF| M| FSA9SG14SG37SG5SL21| SL41Ann| Susan | Brand | ManagerJohnWhiteManager| Julie | Lee| AssistantsexDOB| 1970-02-19 |1958-03-241960-11-10| 1940-06-03|1945-10-011965-06-13salary | branchNo |9500.00 B007| 18000.00 | B003| 12000.00 | B003| 24000.00 | B00330000.00 B0059000.00 | B005

Relational database is a type of database which stores and provides the access to data which are…

Show all female’s first names and their salary. Show the branchno that has a supervisor whose salary is greater than 15000. Show the first name and birthday for all female staff whose birthday is before 1950-01-01. List of monthly salaries for all male staff, showing the staff number, the first and last names, and the salary details.

Show all female’s first names and their salary. Show the branchno that has a supervisor whose salary is greater than 15000. Show the first name and birthday for all female staff whose birthday is before 1950-01-01. List of monthly salaries for all male staff, showing the staff number, the first and last names, and the salary details.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…
BO File Page 1 of 1 Home Insert Design 114 words Layout References Mailings Review View Help Accessibility: Investigate Assignment #9 9. Suppose five processes A, B, C, D and E arrive at the times indicated, and each of them is executed for the amount of time specified against it in the table below: Process A determine: B C CS304 ASSIGNMENT 9 - Word D E Arrival Time 0 2 5 Tell me what you want to do 9 11 For each of the following three scheduling schemes, • First-come-first-served (FCFS), Round-Robin (RR) with a time quantum, q = 4 Service Time 7 4 5 4 6 (1). the finish time for each process. (ii). the turnaround time for each process (iii). the normalized turnaround time for each process. (iv). the mean turnaround time for all processes (v). the mean normalized turnaround time for all processes. delinki asylum F I + 9 + x 100%
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE 6/1/1999 Male 12/30/1994 Female 6/1/1999 Male 5/6/1995 Male 10/15/1992 Male S103 Hisham 90 D102 A102 Level 1 22 S102 Sara 45 D103 A104 Diploma 27 S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 s100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 S104 Faisal 4/5/1998 Male 90 D104 A101 Advanced Diploma 23 S105 Fatima 2/23/1992 Female 90 D102 A102 Level 2 29 9/12/1999 Female 8/13/1991 Female S106 Arwa 45 D102 A102 Level 3 22 S108 Ibtisam 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level
Business Rules: Each musician at NewTalent should have a name, address, and phone number on the system. The Instruments used in the songs have a unique name, musical genre (i.e. rock, pop, hip hop), and type (i.e. string, piano, guitar). Every album recorded under the NewTalent label has a title, copyright date, format, and an album identifier. Each song recorded has a title and an author. Musicians can play several instruments, and an instrument can be played by multiple musicians. Every album contains several songs, but a song can only appear on one album. Songs are performed by one or more musicians, and a musician can perform numerous songs. Each album has one musician acting as its producer, although a musician can produce multiple albums. Create an ERD for the above scenario that describes its business rules. Use Crow's Foot notations and make sure to include all of the following: All entities correctly identified with Primary key and any foreign key attributes.…
student takes ID ID course_id sec_id semester year grade пате dept_name tot_cred section course department course_id sec_id semester year building room_no time_slot_id course_id title dept_name credits advisor dept_name building budget s_id i id time_slot time_slot_id day start_time end_time prereq instructor classroom COurse_id prereg_id ID building пате dept_name salary room_no сараcity teaches ID course_id sec_id semester year Consider the relation that results from the expression: course natural join department Which of the following functional dependencies hold for this relation? (Mark all that apply) O {title, credits} -> building O dept_name -> budget O course_id -> {budget} O {building, budget} -> dept_name O title -> credits O {course_id, title} -> credits
Exercise Wellmeadows Hospital Patient Medication Form • Illustrate the Patient Number: P1O034 Full Name: Robert MacDonald Ward Number: Ward 11 process of normalizing the data shown in the form on your Bed Number: 84 Ward Name: Orthopaedic Drug Number Name Description Dosage Method of Units per Start Date Finish Date Admin Day right side. 10223 Morphine Pain Killer 10mg/ml Oral 50 24/03/04| 24/04/05 10334 Tetracyclene Antibiotic | 0.5mg/ml IV 10 24/03/04| 17104/04 10223 Morphine Pain Killer 10mg/ml Oral 25/04/05 | 02105/06 10
10. Display the names of all employees where the third letter of their name is an A. ENAME BLAKE CLARK ADAMS 11. Display the name of all employees who have two Ls in their name and are in department 30 or their manager is 7782. ENAME ALLEN MILLER
Hospital Appointment System Draw Business Flow/Function
Tairiq MinesError! Bookmark not defined. Tairiq Mines in Texas has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate). Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number. 1.Represent the above as a single Entity Relation model. Provide any assumptions necessary to support your model 2.Write an SQL query that displays the parking space number, location as well as the name of the staff member to whom the parking space has been allocated.
Using the following entity information, the primary key of the student who lives in Eastpoint, FL is, O Start Page A MOTerm Exam L Relaional, 1 Untited 1 CIS25SOISTUDENT VARCHARZ S EYTED VARCHARZ 130 BYTE VARDAA2 (3 BYTD SLAST SIRST SMI SADORESS S CITY SSTATE CB2550LFACULTY NUMEER I VARCHARZ 0 YTE VARCHARZ GO BYTE CHARYT CHAR LEYTE VARDARZ 125 YTD VARCHARZ 20 BYTE FAST EARST MI FPHONE VARCHARZ 10 BYTE RANK FUPER CHAR 2YTE VARCHARZ 0 YTD VARCHAR2 (10 BYTE CHAR 2 BYTE DATE NUMSER 4 NUMBER INTERVAL YEAR TO MONTH VARCHARZ OBYT NUMBER NUMBER FACULTYFJD JD SPHONE SCLASS 5.006 SUPN FACULTYFJDFK FJD TIME DROLLID STUDENTSID RD STUDENT F ID K F D STUDENT SID PK 6JD Seriat Outut Query Result SOL I AlI Ros Fetched: 5in 0.74 seconds rDrLASTLIRST M HONE LRANK rSUPERFMIN 1 Marx 2 Zhulin Mark 3 Lang ley ColinA 4 Broun JonnelD 5 Sealy Janes L Teresa 4075921695 Associate 6338 4073875682 Full (null) 1121 4075928719 Assistant 9871 4 4078101155 Full (null) 8297 4079817153 Associate 1 Script Output Query…
Tairiq MinesError! Bookmark not defined. Tairiq Mines in Glen Austin has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number. Write an SQL query that displays the parking space number, location as well as the name of the staff member to whom the parking space has been allocated. Please make the solution clear.
Tairiq MinesError! Bookmark not defined. Tairiq Mines in Glen Austin has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number. Write an SQL query that displays the parking space number, location as well as the name of the staff member to whom the parking space has been allocated