Database Principle and Application - 4 ========================= There is a Company Database that manages the data of employee, department and project. The relational schemas are as follows: EMPLOYEE (Fname, Lname, Employee_id, Gender, Salary, DNO). The attribute means: First name, Last name, employee id, gender, salary, the department number in which the employee works. Each employee has a unique employee id, and can join in projects that in different department. DEPARTMENT (DNO, Dname, Manager_id, Dlocation). The attribute means: Department number, department name, department manager id, department location. The department manager is a type of the employee, thus the Manager_id is a foreign key that references the Employee_id in EMPLOYEE table. PROJECT (Project_NO, Pname, DNO). The attribute means: project number, project name, department number of the department that the project belongs to. Part of the data in the relations are as follows: Table1 EMPLOYEE Fname Lname Employee_id Gender Salary DNO John Smith 20182101 Male 40000 2 Franklin Wong 20182102 Male 50000 1 Jennifer Wallace 20183101 Female 35000 3 Joyce Clinton 20183102 Female 28000 3 Peter Bush 20184101 Male 33000 4   Table 2 DEPARTMENT DNO Dname Manager_id Dlocation 1 Research 20181105 Stanford 2 Technology 20182102 Houston 3 Service 20183101 Houston 4 Administration 20184101 Stanford   Table 3 PROJECT Project_NO Pname DNO 1001 TransportationMap 1 1002 TwitterFriendship 1 1003 PowerSystem 1 2001 Python 2 2002 Parallel 2 3001 Customer 3 Based on the above relational schema, please write the SQL scripts to do the question - 1. Notes: you do not need to give the query results. You only need to give the query script or the relational algebra expression. Question: Find the information of all employees.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Database Principle and Application - 4

=========================

There is a Company Database that manages the data of employee, department and project. The relational schemas are as follows:

EMPLOYEE (Fname, Lname, Employee_id, Gender, Salary, DNO). The attribute means: First name, Last name, employee id, gender, salary, the department number in which the employee works. Each employee has a unique employee id, and can join in projects that in different department.

DEPARTMENT (DNO, Dname, Manager_id, Dlocation). The attribute means: Department number, department name, department manager id, department location. The department manager is a type of the employee, thus the Manager_id is a foreign key that references the Employee_id in EMPLOYEE table.

PROJECT (Project_NO, Pname, DNO). The attribute means: project number, project name, department number of the department that the project belongs to.

Part of the data in the relations are as follows:

Table1 EMPLOYEE

Fname

Lname

Employee_id

Gender

Salary

DNO

John

Smith

20182101

Male

40000

2

Franklin

Wong

20182102

Male

50000

1

Jennifer

Wallace

20183101

Female

35000

3

Joyce

Clinton

20183102

Female

28000

3

Peter

Bush

20184101

Male

33000

4

 

Table 2 DEPARTMENT

DNO

Dname

Manager_id

Dlocation

1

Research

20181105

Stanford

2

Technology

20182102

Houston

3

Service

20183101

Houston

4

Administration

20184101

Stanford

 

Table 3 PROJECT

Project_NO

Pname

DNO

1001

TransportationMap

1

1002

TwitterFriendship

1

1003

PowerSystem

1

2001

Python

2

2002

Parallel

2

3001

Customer

3

Based on the above relational schema, please write the SQL scripts to do the question - 1. Notes: you do not need to give the query results. You only need to give the query script or the relational algebra expression.

Question:

  1. Find the information of all employees.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Transaction Processing
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education