Consider the following tables containing sales information: Sales Location LociD City Well Nets Auck TimID Amnt 230 LocID PeriD Time TimiD Day Mon 300 310 Tue Wed SalesPerson 50 Thu PeriD Name 550 Fri John 100 Sut Susan 880 San James Mon Susan 60 Ann 140 Use Cross tabulation to explore and reveal the relationship between: | i) Location and Time i) Personnel and Time N N 66 N

Q: Draw flow chart to estimated salary for the proportion of workers 6 people 5 ID per hour where…

A: 1) For start and stop we have to use oval symbol  2)For calculation we have to use rectangle  3)For…

Q: Product Name Sales Rep Country   Product 1 Paul China   Product 1 Paul Singapore   Product 1 John…

A: A sorting algorithm is defined as the algorithm that puts elements of a list into an order as…

Q: Use the following tables to write the SQL queries: Table Name: Employees EMPLOVE FRST NAME HDATE…

A: LIKE operator in MySQL is used when column entries needs to be compared as per a given pattern.

Q: Use the given data to classify the record below using the​ k-NN algorithm for  k=1 to 5. Loan…

A: The python code for the model is given below with self-explanatory embedded  comments:1import pandas…

Q: O consider the consider the followlng tables :- table names : sales city paris Salesman-id…

A: SQL is used to communicate with the database. It supports several queries to create a table, insert…

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: Normalize the following unnormalized table using the three normalization rules and describe each…

A: Dear Student, The three normalization rules are nothing but the normal form conversion of the table,…

Q: Refer to the WORKERS table: WORKERS Empno Empname Job Mgr HireDate Sal Comm Deptno 24000 2.405 17000…

A: Given :

Q: Consider the following customer records. Rescale the Age of the first customer using 0-1…

A: We need to normalise the age of first customer using 0-1 normalisation.

Q: ponring table the followoing gramman Buld CLR E-> E+T/T T→ T*F/F

A: Given Grammar : E -> E + T E -> T T -> T * F T -> F F -> ( E )  F -> id

Q: Normalize the following table to 3NF. 4 PK StudentNo CourseID StudName | GradeReceived StudCity…

A: Dear Student, In 3NF form the table must not have any transitive dependency , all dependency must be…

Q: Note the imperfect table below, try to pass through the set of stages in normalization to get a…

A: Normalization is a database design practice that decreases data redundancy and removes unwanted…

Q: se the given data to classify the record below using the​ k-NN algorithm for  k=1 to 5. Loan…

A: To classify the new record for each value of k using the k-NN algorithm, we need to calculate the…

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: Consider the following Account table and express in Relational Algebra each of the questions below:…

A: a)  SELECT * FROM Account WHERE accountType = 'Saving' ;   b)  SELECT amount FROM Account WHERE…

Q: Apply normalization of the following data table showing all required details patient patient patient…

A:

Q: Use the following un-normalized data and prepare a set of tabled that is in its third normal form.…

A: Objective: Given a relation as follows, SO# Date Item# Description QTY Unit price Cust # Cust…

Q: List the names of customers who are from the city of “Muscat”.  List the details of customers who…

A: We'll use the attribute's names to extract data from the relation.

Q: Use the given data to classify the record below using the​ k-NN algorithm for k=1 to 5.   Loan…

A: Based on the information you provided, we can classify the record with the given loan purpose,…

Q: Unit PartQ Supplie Suppli Suplli Suppl Suppli Supplier erNam erStre Order Orde PartN Part Num rDat…

A: Primary key for the given relation is {OrderNum , PartNumber} The FDs are OrderNum -> OrderDate…

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: 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: write SQL query that returns average price per product

A: SELECT- selects data from the database. AVG()- used to give average of that particular attribute…

Q: Show the number of staff for each position. • Show the number of staff for each gender in each…

A: The SQL queries for the given questions are provided below.

Q: 1. The table below shows several records about the order from the Mcdonalds Normalize the given…

A: 1NF: A relation will be 1NF if it contains an atomic value Note: All the records in row are not…

Q: Identify the relational keys in the following two tables. Вranch branchNo street city postcode | 22…

A: Super Key – A super key is a group of single or multiple keys which identifies rows in a table.…

Q: Problem List with Expected Results Problem 1 For all departments, display department number and the…

A: To satisfy the given requirement, SQL code was developed using Oracle as below ((the question did…

Q: Customer ID Name Address Phone Card Password Usernam number number Employee

A: ERD diagram is given below

Q: Draw the result after applying each of the relational algebra operations on the following table

A: note that sigma is selection operation that can select only based on condition.  pi is projection…

Q: Write the suitable SQL statement to answer the following questions based on the following tables (…

A: Given question: Write the suitable SQL statement to answer the following questions based on the…

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: Write the standard MYSQL query to retrieve the average customer balance grouped by SalesRepNo Write…

A: I have provided answers in step 2.

Q: Is the following table in First Normal Form? If so, how would you get it into first normal form.

A: Redundancy from a relation or group of relations is minimised through the process of…

Q: The data in this table is as follows: Team Opponent Tigers Dragons Carp Swallows Bay Stars Marines…

A: The correct answer is given below with explanation

Q: Normalize the graph below in 3rd normal forml.

A: The Third Normal Form (3NF) is a crucial concept in database normalization, a process used to…