The table given below contains information about different students from the same school. In this question, you are asked to normalize the data given until the 3rd normal. You may work in excel

Q: List the years and their total gross earnings (sum of earnings per year), but do not include gross…

A: ANSWER:-

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: Q2: Do these queries: 1. Show department name and instructor name who is having salary greater than…

A: Due to company policies I am compelled to solve only one question and that is the first question.…

Q: SQL Querry Find the list of courses who haven’t got any section opened in Spring 2019. (Use outer…

A: It is simple SQL query to fetch the list of courses who haven't got any section opened in Spring…

Q: SQL compile a list of all orders placed on day X by calculating the total number of repairs and the…

A: Solution:   Note :  You didn't mention the table schema so assume by myself.   Given,

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: Write SQL Command to display employee first name , department name and the county id.

A: i have provided answer in step2.

Q: Write SQL statements to list the name of Lee’s subordinate employee.    (Data Update)     Write…

A: Lees Employee ID is 2 So, to get the lees subordinate then we need to search for this employee ID in…

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: 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: If every student at a school is assigned a 4-digit person ID number, but 0 and 1 are not used in ID…

A: The question asks about the potential number of student ID numbers in a school where each student is…

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: Given that there are two tables Employee and Orders. The attributes of each table are:…

Q: USE MY SQL  List all the data in your table movie_prod, sorted by the id of the movie (smallest…

A: MySQL is based on the SQL programming language and allows developers to store, organize, and…

Q: Show all female’s first names and their salary.  Show the branchno that has a supervisor whose…

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

Q: What was the amount of the total sale of all products (sum of quantity * price of the product) for…

A: The SQL query for the given question is provided below using the the class diagram reference.

Q: 1. The data type for Borrower_name in Borrowers Table is: A. Short text C. Currency B. Long text D.…

A: As the schema design tabular structure of the Borrowers table in question indicates that it is…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition.  student…

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: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: Write SQL Command to display all employees details whose job id is either AD_VP or PU_MAN. Order the…

A: We are given Employess table which contain all the attributes asked in query, so we will use…

Q: Use Column level constraint setting while designing the below given table in sql named as…

A: Column constraints: In Structured Query Language, the column level constraints are used to specify…

Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…

A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…

Q: Write a program in assembly language to compares the elements of two arrays, A(1) and B(1), each…

A: Comparing elements of array A(I) and B(I) After comparing, if two arrays are unequal, store the…

Q: For each sale made on June 1, 2015, show the following information: CustomerID, Customer name…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: How many patients in the database have been diagnosed with acute bronchitis (ICD9Code = 466) and…

A: Count Query :- SELECT COUNT(column_name) FROM table_name WHERE condition; Groupby Query :-…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Given:

Q: Write an SQL Query to list the name(s) and address(es) of employees who work at the department…

A: The solution is written in SQL. Please check the solution in the next step. Note:  As per the…

Q: They need all the service requests with the category of Plumbing (category number 1) and Heating…

A: The given requirement is to be solved in the form of SQL command where the only service requests are…

Q: D03 Testing Retrieve the Department names and the count of employees work in each Department, but…

A: In this question we have been given with the tables where we need to retrieve the department name…

Q: 4. Create the Order_Product table as follows: • id is the primary key and its data type is serial…

A: 4. Query: CREATE TABLE Order_Product(    ID serial NOT NULL PRIMARY KEY,    quantity int NOT NULL…

Q: how do you Calculate a query in access database on how many customers there are for each lawn size?…

A: To write SQL query  directly on MS Access, Open the Database. 1. Select Design View, and click OK.…

Q: List only the movies that have a value for gross (not NULL values). Include all columns in the…

A: The SQL query you provided is used to retrieve data from the "movies" table. The query selects…

Q: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…

Q: 1.Write SQL Command to, display employee id and ob id who gets salary within the range of 4000 and…

A: SELECT keyword is used to display particular columns  BETWEEN is the keyword used to specify the…

Q: Find the number of staff for each city. Find the staff name who has the minimum salary for each…

A: In this question we have to understand the given tables in mariaDB and write the queries for the…

Q: Some rows of the table STUDENT are shown below:   CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI…

A: To find thе dеpartmеnts with a GPA avеragе in thе yеar 2004 grеatеr than thе global GPA avеragе,…

Q: (a) Add the following record into the SALESPERSON table. SALES_NAME POSITION AREA JOYCE SENIOR…

A: As per the guidelines of bartleby:“Since you have posted a question with multiple sub-parts, we will…