Retrieve the birthdate and address of the employee who is the manager of the department administration. Retrieve the first name and the last name of all employees whose salary is between 25000 and 45000. Retrieve all employees working on project number 2 with a number of hours lower than or equal to 10. Retrieve the department number, and department name for each department having at least three employees.
Retrieve the birthdate and address of the employee who is the manager of the department administration. Retrieve the first name and the last name of all employees whose salary is between 25000 and 45000. Retrieve all employees working on project number 2 with a number of hours lower than or equal to 10. Retrieve the department number, and department name for each department having at least three employees.
Principles of Information Systems (MindTap Course List)
13th Edition
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter5: Database Systems And Big Data
Section: Chapter Questions
Problem 3SAT
Related questions
Concept explainers
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Question
- Retrieve the birthdate and address of the employee who is the manager of the department administration.
- Retrieve the first name and the last name of all employees whose salary is between 25000 and 45000.
- Retrieve all employees working on project number 2 with a number of hours lower than or equal to 10.
- Retrieve the department number, and department name for each department having at least three employees.
Transcribed Image Text:Figure 5.6
Onc possible database state for the COMPANY relational databasc schoma.
EMPLOYEE
Fname Minit Lname
Bdate
Address
Sex Salary
Super_ssn Dno
M
Ssn
John
B Smith 123456789 1965-01-09 731 Fondren, Houston, TX
Franklin T Wong
333445555 1955-12-08 638 Voss, Houston, TX
Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX
Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX
Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX
1972-07-31 5631 Rice, Houston, TX
987987987 1969-03-29 980 Dallas, Houston, TX
M 30000 333445555 5
40000 888665555 5
25000 987654321 4
43000 888665555 4
F
F
M
38000 333445555
5
453453453
F
25000 333445555
5
Joyce A English
Ahmad V Jabbar
M
25000 987654321
4
James
E Borg 888665555 1937-11-10 450 Stone, Houston, TX
M
55000 NULL
1
DEPARTMENT
DEPT_LOCATIONS
Dname
Dnumber
Dnumber
Mgr_start_date
Mgr_ssn
333445555
Research
5
1988-05-22
1
Administration
4
987654321
1995-01-01
4
Headquarters
1
888665555
1981-06-19
5
5
5
Pno Hours
1
32.5
2
7.5
3
40.0
20.0
20.0
10.0
10.0
10.0
10.0
30.0
10.0
35.0
5.0
20.0
15.0
NULL
WORKS ON
Essn
123456789
123456789
666884444
453453453
453453453
333445555
333445555
333445555
333445555
999887777
999887777
987987987
987987987
987654321
987654321
888665555
1
2
2
3
10
20
30
10
10
30
30
20
20
PROJECT
ProductX
ProductY
ProductZ
Computerization
Reorganization
Newbenefits
DEPENDENT
Essn
Dependent_name Sex
Alice
F
M
333445555
333445555 Theodore
333445555 Joy
Abner
987654321
M
123456789
M
123456789
Michael
Alice
Elizabeth
F
123456789
F
Pname
Pnumber
1
2
3
10
20
30
Dlocation
Houston
Stafford
Bellaire
Sugarland
Houston
Plocation
Bellaire
Sugarland
Houston
Stafford
Houston
Stafford
4
Bdate Relationship
Daughter
1986-04-05
1983-10-25 Son
1958-05-03 Spouse
1942-02-28 Spouse
1988-01-04 Son
1988-12-30 Daughter
1967-05-05 Spouse
Dnum
5
5
5
4
1
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr