a) List the names (Fame and Lame) and SSN of all male employees (Sex='M). b) List the last name and SSN of employees who work on project 'City Tower', sorted by alphabetical order of last na c) Retrieve the average salary of all female employees (Sex='F').

Q: The Primary Key is (doctorID, patientID).   i. Explain why the above table is not in 2nd Normal…

A: Below is the answer with explanation:

Q: 12. Report the names of the professors who supervise more than one student. 13.  Report the names…

A: In order to find professors who supervise more than one student, we will need a COUNT() function on…

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Provide a summary of customer balance characteristics for customers who made purchases. Include the…

A: Actually the given information is Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Q: Show all the different positions in the Staff table. • Show all the different branchNo in the Staff…

A: The SQL queries for the given question are provided below -

Q: Consider the scores of 50 Grade 7 students in Math.

A: Given is a question to find grades of 5 subjects for about 7 students. Pesudocode: First We will…

Q: Q1: Show all the information from the employee table. SELECT * FROM emp; Q2: Show the employees…

A: The select statement is used to select a value from the database. The selected columns are displayed…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Switch to the Melbourne Swim Teams In cell B14, use the INDEX function to display the value in the…

A:

Q: Show Customer name (concatenate First Name and Last Name with a space between) and total number of…

A: The given data samples have the details about a Customer in CUSTOMER table and corresponding orders…

Q: Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with…

A: A relational database contains tables. Tables are also called relations and they contain rows and…

Q: Task 12: List the item ID, description, and category for each pair of items that are in the same…

A: Creating table ITEMS: create table ITEMS(item_id varchar2(5) Primary Key,Description…

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table:   INSERT INTO OWNER…

Q: If  the functional dependencies are consistent with the above relation,  put TRUE. If they are not,…

A: functionally dependent defines the relationship between attributes, how they are related.  A-> B…

Q: Problem 7 Write a query to produce the total number of hours and charges for each of the projects…

A: Here you have simply used the ROUND(value,2) function. This will simply round the value to 2 places…

Q: 4) Give the UML class diagram.

A: Note: As per Bartleby's policy, we can solve only one question at a time. Please repost the…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: Find the staff name who has the maximum salary for each branch Find the staff name who has the…

A: SQL is the Structured Query Language, which is the computer language for storing, manipulating and…

Q: 2. Can you describe the below operation with example? (Give some data in section table and then…

A: The query is given. Let's assume the sample table

Q: Given the employees of medium-sized semi-conductor firm, find the employee that joined November 8,…

A: The Excel INDEX function returns a value in an array based on the row and column numbers you…

Q: There are 9 workers for ASH Development Sdn. Bhd. as shown in Table Q4. Unfortunately, there are…

A: According to question there are 9 workers and 4 rooms. The Ids of workers selected for the jobs are…

Q: Find the first names and last names of employees if they got a salary increase more

A: create table commands and inserting sample data into the table for query  create table employees…

Q: creat the following tables and insert your own values: emp(eno, ename, bdate, title, salary, dno)…

A: The SQL INSERT INTO Statement is used to add new rows of data to a table in the database

Q: Q16) List the V_CODE and V_NAME of vendors that provide products Q8) List the product description,…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: Financial Aggregated Data Average Revenue Largest Expenses Lowest Revenues Smallest Expenses # of…

A: the answer is

Q: Write a query to display the first name, last name, and email address of employees hired from…

A: In this question we have to write a query to display the first name, last name, and email address of…

Q: List details of all customers from Canberra that have enrolled in a course order by Customer Number.

A: Answer

Q: 3. Modify the CUSTOMER table: a) to include the customer's date of birth (CUST_DOB), which should…

A: Actually, database is a used to stores the data.

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: Question 1 Use Index and math functions to fill in a table that extracts the amounts shipped…

A: The task at hand involves using Excel's Index and math functions to populate a table displaying the…

Q: MEMBER (memberID (PK), profession, name, address, telNo, areaCode (FK) VOLUNTEER (volunteerID (PK),…

A: The answer as given below;

Q: Activity 7: Sorting Data Using ORDER BY In this activity you will sort rows by using the ORDER BY…

A: The ORDER BY clause in MySQL is used to sort the results of a query in ascending or descending…

Q: (Consider table employees with the following colunms (EMPLOYEE ID, FIRST NAME, LAST_NAME , EMAIL…

A: Select CONCAT(M.First_Name,' ', M.Last_Name) as MANAGER_NAME , M.Department_ID from Employees E…

Q: Product a report showing the distinct first and last names of customers from the state of New York…

A: In the Database , a SQL query which refers to the one it is a request for data from a database. SQL…

Q: 1 2 3 4 Name Blake James King Allen City Fee Saida 2850 300 1100 1300 Saida Zahle Beirut What is the…

A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :