1. Print average Salary of all employees from EMPLOYEE table..

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: If 15% of the product has been returned to the company and the company decided to recycle the…

A: Answer to the above question is in step2.

Q: In a city there is a mini market called B-Mart that sells various types of snack. Specified min_sup…

A:

Q: From worksheet sheet3, in cell E11, find the sum of all Total Sales for 2nd half Bonus which are…

A: The given problem is related to MS Excel where the formula is to be used to solve the problem using…

Q: Find the range of salaries (min, max) of each department in the following table:EMP(EID, ENAME, SAL,…

A: EMP is the name of the table Employee.EMP table has four rows named EID, ENAME, SAL, and DEPT. Find…

Q: Q5) what is the normalization of the following table, where the primay keys are underlined: Product…

A: Find the required answer with explanation given as below :

Q: For the following data : X (starting hourly wage) = [2, 3, 4, 5, 6] and %3D Y (Number of work…

A: Refer to step 2 for the answer

Q: .Show a number of primary and secondary cities (Province column only). The expected output is…

A: It is simply a group by question.

Q: Use the XYZ Apartment Rental Company ERD shown on Figure 1 to answer questions 9 through 12:…

A: In the given ER diagram we have 3 entities,out of which 2 entities Building and Builder is strong…

Q: In a city there is a mini market called B-Mart that sells various types of snack. Specified min_sup…

A:

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: Using Relational Algebra- A) Find the total number of books published by Macmillan Publishers B)…

A: Relational algebra:   A. Find total number of books published Macmillan Publishers.…

Q: Using the attached table, choose the correct answer *: The highest "total salary" among employees is…

A: Salary has been calculated on the below formula Basic Salary+ 5% of (actual salary-planned salary) +…

Q: (check all that apply) Find all the employees located in DallasA) select ename from dept where loc =…

A: Checking all the given SQL query to find all the employees located in dallas,Creating table from the…

Q: 1) List all products with their highest unit price, i.e. not discounted. 2) List the average unit…

A: There are following aggregate functions used in the SQL queries: To find the highest unit price,…

Q: all the related employee attributes for those employees whose salary is above 5000

A: all the related employee attributes for those employees whose salary is above 5000

Q: Question 14 We want to select all employees from a table named EMPLOYEE for employees whose last…

A: ANSWER : Option: c We want to select all employees from a table named EMPLOYEE for employees whose…

Q: The spreadsheet model for Sam’s Bookstore contains a two-way data table for profit versus order…

A: Sam’s Bookstore places orders in different locations of United States. The spread sheet of model for…

Q: a) What is the minimum number of entries in Undergrad entity set? b) What is the maximum number of…

A: Part (1) The student entity is related to two other entities of the database which are Enrolls and…

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: Find the rank of each department in terms of total salary

A: since question has not provided name of sample tables so we assume table1 and table2  as name of…

Q: Solve the following queries: 1. Display all details of the item table. 2. Display item name, section…

A: Note: Since your question contain multiple sub-parts but we can answer only 3-subparts at a time due…

Q: How date difference function is used, give a example to count age using datediff function ?

A: Excel application is a collection of spreadsheets where each spreadsheet is a collection of rows and…

Q: Use the XYZ Apartment Rental Company ERD shown on Figure 1 to answer questions 9 through 12:…

A: In the given ER diagram , We have three entities BUILDING, BUILDER and a Weak entity APARTMENT. For…

Q: 5) If we have the following relationship Enrolment Student Course Student number Student name Course…

A: Given: We are given two entities and a relationship between them.  Goal: We have to discuss how…

Q: Question 14 A fair is visited by at least one visitor. One visitor visits at least one fair. Visitor…

A:

Q: Find the 5 earliest hired employees

A: the query to find the 5 earliest hired employees from the table is mentioned in step 2. please note…

Q: Query to display the lowest average cost of books within a subject and the highest average cost of…

A: Inline view concept is used here, getting data from output of table which is again treated as table.…

Q: Vacation days are based on status. Using the information in the lower table below, do a lookup in…

A: A lookup function is used to match a lookup value in a one-column or one-row range, and returns the…

Q: From worksheet Adidas, in cell D5, count the number of models from the Sales table which has sales…

A: 1) in cell D5 count the number of models from sales table where sales during the july FORMULA :…

Q: [Question-2] Use a one-dimer salespeople on a their gross sales f week receives $20

A: Code: using System;  namespace ConsoleApplication11 {     internal class Program     {…

Q: Consider the table EMPLOYEE EmployeelD EmployeeName RolelD RoleName 111 John TML Team Lead 222 Emily…

A: Answer: Correct option is (B) Two separate tables

Q: Find employees who earns highest salary for their job

A: = operator :- = operator is used with WHERE Clause in SQL. It allows comparison of attributes with…

Q: Consider the below EM JALARY ON N TIMMY 5000 L identify the potential anomalies that might arise…

A: The answer is

Q: We have two tables: • employees - This table contains each employee's ID, name, and department ID id…

A: SQL script is given as

Q: 6. Using Employees table with sub-queries, • Display the Department_Id, job_id and maximum Salary.…

A: A query is created using the following syntax having all the clauses required in the given question.…

Q: Interpret the size and magnitude of the estimated coefficient of owner. Why is the estimated…

A: Below i have answered:

Q: 4. Find the name of employees who have salary less than the average salary of employees who are in…

A: As per our guidelines we are supposed to answer only one question. Kindly repost other questions as…

Q: The graph below shows different function growth complexities (Big-O orders). Label each line with…

A:

Q: Find top 2 largest departments in terms of number of employees

A: The given two tables record the data about EMPLOYEES and DEPARTMENTS.   An Employee has one…

Q: 1. Determine the total profit generated by sales to customer 1017. Note: Quantity should be…

A: Description: Each customer can place multiple orders whose details will be stored in the relation…

Q: 3. To check whether a hospital ward is to con the table given below.

A: QUESTION NO-3 It can be solved using simple if-else statements. #include <iostream> using…

Q: Using update statement to increase the salary of a manager by 10% if he/she works on more than 1…

A: SQL stands for the structured query language. It enables users to manage relational database…

Q: Show all the related employee attributes for those employees satisfying both following conditions…

A: CODE: SELECT (mention all emp attributes here or use *) FROM EMPLOYEE WHERE DEPARTMENT_ID = 100;

Enhanced ER Model

The enhanced ER model is an abbreviation for Enhanced Entity-Relationship (EER) model. As you know, the entity-relationship (ER) model is a pictorial illustration of the relationship between various entities of a domain. In the case of a large amount of data with multiple interrelated entities, the ER diagrams become complex and tough to interpret. For such cases, the need for enhancement in the ER model was observed, and thus, the EER model was designed.