Computer Science THREE TABLES: 1. PROJECT WORKER_TABLE COLUMNS leavedate, worker_id, joindate, project_id, performance 2. PROJECTS TABLE COLUMNS projectid, project_name, capacity, startdate 3. WORKERS table COLUMNS worker_id, worker_name, gender, companyjoindate, birthdate, birthday, supervisory_id USE MYSQL TO ANSWER QUESTION BELOW Q: Find the ID and name of the project(s) that have a gender ratio of greater than one [Gender ratio = #of females/# of males]

Q: display all fields in the JOB table sorted by the largest hourly charges for the job first

A: SELECT * will fetch you all record in 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: 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: Convert to normalization

A: Given that, The given database tables are: Person, Employee, Department, Invoice, Customer, Supplier…

Q: Q. List all the attributes of movie in the given Model.

A: Q. List all the attributes of movie in the given Model.  Answer. All the attributes of movie in the…

Q: he following shows a training company’s workshops, the number of days of each, and their…

A: In this question we have to calculate and display the total cost of attending a workshop, including…

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: Dete Adess Year of_death Purchase date Number_of entais Nane Year of Jath Code Times eted Number…

A: we need to convert given E-R diagram to Relational schema. For N: M relation we have created a New…

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

Q: Figure 2. The relationship diagram of the NorthWind database. a. Use the ERDPlus tool to design a…

A:

Q: Write a SQL statement to get the list of all the team members in the database. Include only the name…

A: Given two tables are TeamMember and Task The attributes of TeamMember table are TeamMemberID,…

Q: List the last name and first name of every owner not located in Lewiston

A: given, owner table content all required fields that we want last name, first name, city.

Q: Please see the attached and assist with below question. Using the “Aggregates” worksheet, complete…

A: The given problem is to complete the given excel for an income tax calculation using MS EXCEL and…

Q: Normalize the below given Student Course Plan to First Normal Form, Second Normal Form and Third…

A: Normalization : is the process of minimizing redundancy from a relation or set of relations.   1NF :…

Q: lter table product so that column productlype is an integer instead of a varchar, not null should be…

A: Lets see the solution.

Q: Display only the sales territories that have more than one salesperson.

A: The HAVING clause is used in SELECT statement as we cannot use the WHERE clause with aggregate…

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

A: Given :

Q: Question - 4 For each department retrieve the department number, number of employees and their…

A: by bartleby guidelines i am able to do only first question.

Q: Normalize the below given Student Course Plan to First Normal Form, Second Normal Form and Third…

A: From the given question we can identify the below functional dependencies which are violating the…

Q: Creating factory Database SUPPLIER CUSTOMER Id ld CompanyName FirstName ContactName LastName City…

A: How to Add a New Column with ALTER TABLE To add a new column, you first need to select the table…

Q: Based on the ERD below, display all columns in the JOB table for those job descriptions that have…

A: 2) Query to display all columns in the JOB table for those job descriptions that have both analysts…

Q: Ryan Car Rental LLC. Quarterly Turnover Report Report ID.: 7686 Reporting period: Jan 2019-Mar 2019…

A: Need to find First Normal Form, Second Normal Form and Third Normal Form of the given database :

Q: ITEM (ITEM ID, DESCRIPTION, ON HAND, CATEGORY, LOCATION, PRICE, NUM, INVOICE _ DATE, CUST PRICE))…

A:

Q: Considering the un-normalized relational table PROJECT below: PROJECT (Project Title, EmpeName,…

A: Functional dependencies are... ProjectTitle, EmpeName -> HoursWork ManagerName -> ManagerPhone…

Q: a Write in SQL a command that creates the table Products according to the above description a. Write…

A: Given :

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: J. K. Does this relation contain a transitive dependency? If so, what is it? Redesign the relation…

A: SOLUTION -From the given table we have given a table PROJECT with ProductId, EmployeeName,…

Q: Question 2: For the following table find the relevant Functional Dependencies and resolve them till…

A: Third normal form: The Third Normal Form (3NF) is a normal form used in the normalization process of…

Q: Given the following Staff2 table, please write a SQL statement to find the superno who supervised 4…

A: To find the superno where COUNT(superno) is greater than or equal to 4.

Q: Considering the un-normalized relational table PROJECT below: PROJECT (ProjectTitle, EmpeName,…

A: Solution: Normalizing the relational table PROJECT into a minimal number f relational tables in…

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: Course evaluation must have a student, the students relation contains a unique student id, full name…

A: An Entity–relationship model (ER model) describes the structure of a database with the help of a…

Q: raw ERD for these tabels The system must contain tables such as category(catNo,catogeryName)…

A: ERD diagram:

Q: Hotels Rooms Hotel ID Room Number. Zipcode Room Type Reservation City 太 Rates Room location…

A: the below is relational schema for above given ER diagram

Q: Convert the table "Vehicle" into BCNF normalization and please explain how to do it. In the table,…

A: A relation is said to be in BCNF if all its functional dependency is of type x->y where X is key…

Q: Write SQL statements to create the normalized schema of the following. Lawsuits ID Authority…

A: The question is to write the SQL statements for the given problem.

Q: Select the best answer from the given choices: Using the company schema, when creating the…

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

Q: Your university runs many hundreds of courses each semester and needs to keep track of key…

A: the code is given below:-

Q: Assuming that all functional dependencies are apparent in this data, which of the following are…

A: The topic at hand is the concept of functional dependencies within a relational database, which is…

Q: Consider the table (employee) below: Emp_qualification Dept_id BSc, A01 Emp_no Emp_name Dept_name…

A:

Q: CUST_ID 78   CUST _ID 54     NAME YORK UNIVERSITY   NAME SENECA COLLEGE     LOCATION…

A: Given, CUST _ID NAME LOCATION SALES_REP 78 YORK UNIVERSITY NORTH YORK ANDRE MARTIN 54 SENECA…