![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 21.02.2020 01:02 nally6636
Deli has hired you as a consultant to design a database for the deli. They have provided you with the following information:
Every employee has a social security number, name, salary, and date of hire.
The deli is organized into several departments. Each department has a unique name.
Each department has exactly one employee as its manager but an employee may manage more than one department. The database should record the date when the most recent manager of each dept. was appointed in that position.
Every employee must be assigned a department.
Every employee has a supervisor who need not be the manager of any department.
The deli has these four departments:
hot foods
sandwich
snacks
beverage
You are provided the following additional information, which should be inserted into the database using SQL queries (not using any GUI interfaces):
Jim Jones (ssn: 134-56-8877, salary: $28,000, dept:hot foods, date of hire: 1/26/2015, supervisor: Rita Bita)
Rita Bita (ssn: 138-56-8050, salary: $32,000, dept: beverages, date of hire: 2/15/2017, supervisor: Holly Dew. manages: beverages, starting 3/18/2018)
Holly Dew (ssn: 334-55-8877, salary: $29,000, dept:sandwich, date of hire: 1/15/2016, supervisor: Pablo Escobar)
Pablo Escobar (ssn: 666-56-6666, salary: $48,000, dept:snacks, date of hire: 1/26/2014, supervisor: Rita Bita, manages: snacks, starting 5/5/2015)
Al Capone (ssn: 888-91-8870, salary: $40,000, dept:hot foods, date of hire: 1/26/2015, supervisor: Pablo Escobar, manages: hot foods, starting 1/1/2016)
Bonnie Clyde (ssn: 111-22-3333, salary: $42,000, dept: sandwiches, date of hire: 4/7/2015, supervisor: Al Capone, manages: sandwich, starting 1/1/2016)
![ansver](/tpl/images/cats/User.png)
Answers: 1
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Computers and Technology
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 02:00, magicalunicorns47
Arecipients list has been loaded into a document. which commands should be clicked in order to filter the list so that letters will not be printed for recipients who live in a certain state? mailings tab, start mail merge, select recipients, type new list, then insert only contacts from the desired states mailings tab, rules, select recipients, use existing list, then choose a recipients list that includes only contacts in certain states mailings tab, select recipients, use existing list, rules, fill in, then type in certain states mailings tab, rules, skip record select “state” under field name, then type in the state name under “equal to”
Answers: 2
You know the right answer?
Deli has hired you as a consultant to design a database for the deli. They have provided you with th...
Questions in other subjects:
![Konu](/tpl/images/cats/istoriya.png)
![Konu](/tpl/images/cats/istoriya.png)
History, 03.04.2020 02:55
![Konu](/tpl/images/cats/fizika.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 03.04.2020 02:55
![Konu](/tpl/images/cats/fizika.png)
![Konu](/tpl/images/cats/fizika.png)
![Konu](/tpl/images/cats/biologiya.png)
![Konu](/tpl/images/cats/informatica.png)
Computers and Technology, 03.04.2020 02:55
![Konu](/tpl/images/cats/mat.png)
Mathematics, 03.04.2020 02:55