Note the imperfect table below, try to pass through the set of stages in normalization to get a fairly good table StaffBranch Table staffNo name position salary branchNo branchAddress telNo S1500 Tom Daniels Manager 46000 BO01 8 Jefferson Way, Portland, OR 97201 503-555-3618 8 Jefferson Way, Portland, OR 97201 SO003 Sally Adams SO010 Mary Martinez Manager Assistant 30000 BO01 503-555-3618 S0000 BO02 City Center Plaza, Seattle, WA 98122 206-555-6756 Robert Chin Supervisor 3200ю City Center Plaza, Seattle, WA 98122 S3250 BO02 206-555-6756 S2250 Sally Stern Manager 48000 BO04 16 - 14th Avenue, Seattle, WA 98128 206-555-3131 S0415 Art Peters Manager 41000 BO03 14- 8th Avenue, New York, NY 10012 212-371-3000

Q: PLZ help with the following: Using Oracle SQL developper Translate your ER diagram into a…

A: E-R Diagram is given with different attributes and relationships between them.

Q: Note that primary keys are in BOLD. Note also that attributes with the same name in different tables…

A: Here have to determine about SQL statement of given problem statement.

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: 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: Create a table based on EMP and DEPT tables such that it list each employee’s name, job, hire date,…

A: Given two tables: emp- empno, ename, job, mgr, hiredate, sal, comm, deptno dept- deptno, dname,…

Q: i) manufacturer → model Answer: i) MID — сараcity Answer: iii) model → capacity Answer: iv) MID →…

A:

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: 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: there is no information provided for the solution ,in the question says:  The output of the…

A: The required PL/SQL function is defined in the next step.

Q: Translate your ER diagram into the form of SQL DDLs. Choose appropriatedata types for each attribute…

A: 1. Develop a logical information model for each known user combined structure for the application…

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: Note that primary keys are in BOLD. Note also that attributes with the same name in different tables…

A: Solution:   2.3)   Treatment table before increment by 2.5 % in costOfTreatment :

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: Customer ID Name Address Phone Card Password Usernam number number Employee

A: ERD diagram is given below

Q: PLZ help with the following: Using Oracle SQL Translate your ER diagram into a relational schema…

A: E-R diagram is given where different entities and attributes are given from this we will create SQL…