Consider a database schema with three relations:
emp (eid(underline):integer, ename:string, a...
Computers and Technology, 25.02.2020 19:02 gakima57
Consider a database schema with three relations:
emp (eid(underline):integer, ename:string, age:integer, salary:decimal(10,2))
works (eid(underline):integer, did(underline):integer, pct_time:integer)
dept(did(underline):integer, dname:string, budget:decimal(10,2), managerid:integer)
The keys are underlined in each relation. Relation emp stores employee information such as unique identifier eid, employee name ename, age and salary. Relation dept stores the department unique identifier did, unique department name dname, the department budget and managerid which is the eid of the employee who is managing the department. The managerid value must always be found in the eid field of a record of the emp relation. The works relation tracks which employee works in which department, and what percentage of the time s/he allocates to that department. Each eid and each did in works appears in emp or dept respectively. Note that, an employee can work in several departments. Note that this setup is almost exactly what we have specified in createdb. sql, where "string" is translated to char or varchar.
a. Explain how to change the create tables in createdb. sql to match these specifications. Put this answer in the paper submission.
b. Create a view ManagerSummary that lists for every department the department name, manager ID and manager name, manager salary and the number of employees in that department. The view will have five columns with headings: DeptName, MgrID, MgrName, MgrSalary and EmpCount. Put this SQL in createview. sql and drop-view in dropview. sql.
c. Query the view above to retrieve the set of distinct salaries of managers who manage a department called "Sales". Put this SQL in queryview1.sql.
d. Query the view above to find the name of the manager who manages most employees. If the same employee works in several departments, that employee is counted once in each of the departments. The manager is included in the count the same as all other employees, i. e., based on his or her records in the Works table. Put this SQL in queryview2.sql.
Answers: 1
Computers and Technology, 22.06.2019 19:00
How is the number 110 written when expanded out to place values in the base 2 (binary) number system? options: 2 x 4 + 3 x 2 + 4 x 1 1 x 2 + 1 x 2 + 0 x 2 1 x 100 + 1 x 10 + 0 x 1 1 x 4 + 1 x 2 + 0 x 1
Answers: 1
Computers and Technology, 23.06.2019 16:30
20 points archie wants to use a reflector as he photographs a newlywed couple. what would he consider in his choice? a. shadow and sunny b. homemade and professional c. lamps and boards d. incident and reflected e. neutral density and enhancement
Answers: 3
Computers and Technology, 24.06.2019 07:30
Consider the folloeing website url: what does the "http: //" represent? a. protocal identifier. b. ftp. c. domain name d. resource name
Answers: 2
Computers and Technology, 24.06.2019 07:50
Write a defining table and then a program that determines if you can sleep in or not. your program should get all its input from your computerâs clock. on all weekdays (monday through friday) that are not holidays, your program should output âget up! â on all other days (weekends and holidays), your program should output âsleep in.â the three holidays that your program must check for are january 1 (new yearâs day), july 4 (u.s. independence day), and december 25 (christmas). you donât need to include other holidays in your program because most other holidays do not occur on a fixed day each year.
Answers: 1
Social Studies, 05.05.2020 02:38
English, 05.05.2020 02:38
Mathematics, 05.05.2020 02:38
English, 05.05.2020 02:38
Chemistry, 05.05.2020 02:38
Mathematics, 05.05.2020 02:38
Mathematics, 05.05.2020 02:38
Mathematics, 05.05.2020 02:38
Social Studies, 05.05.2020 02:38
Social Studies, 05.05.2020 02:38