Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Task: The following is the relational schema of part of the database that Acme Pty Ltd recently implemented [06] [15 Marks] Staff (Staffld. FirstName. LastName
Task: The following is the relational schema of part of the database that Acme Pty Ltd recently implemented [06] [15 Marks] Staff (Staffld. FirstName. LastName City, Phone, Email, Fax, Salary, DeptNo) Department DeptNo. DeptName, Phone, Fax, Location Address) Project ProjectId Title Duration Location, Extension) Task (StaffId. ProiectId. StartDate. CompletionDate) Using the above schema, write SQL queries that will answer/process the following: 1. List staff id, first name, and fax of all staffs. [1 Mark] [1 Mark] 2. List all department names in the department table but eliminate duplicates. 3. List department name and location of all departments ordered by location in descending order [2 Marks] [2 Marks] 4. List all details of all of the staffs that are in the city of Sohar
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started