Computers and Technology

Below is an ERD showing the 1:M relationship between Department and Employee entity types. This relationship is modeled as a Department JSON object as:Department: deptID, deptName, deptRoom,{deptPhone},{employee: empID, empName, empPhone,{empEmail}}Where {} indicates multi-valued. Part 1: Open the mydb database we created earlier and create a new department table with two fields:documentid (as an integer field) Jsondocument (as a JSON field)And add around 3 departments and each with 2 or 3 employees. Part 2: Use SQL to answer the following questions:Q1: Select all the records in the table. Q2: List the department names with their phones. Q3: A query to show the deptName and number of employees of the department. Q4: A query to show all the employees of a department of your choice using deptName as criteria. USE MYSQL

answer
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 02:30, lauriepdx
The cm is responsible for overseeing the actions of the crisis management team and coordinating all crisis management efforts in cooperation with disaster recovery and/or business continuity planning, on an as-needed basis
Answers: 1
image
Computers and Technology, 22.06.2019 04:30, fatherbamboo
Dr. wisteria is a prominent chiropractor in the chicago area. she wants to provide a forum for her patients to discuss their health concerns and to seek and offer advice to other patients. which telecommunications tool is most appropriate for dr. wisteria's needs?
Answers: 3
image
Computers and Technology, 23.06.2019 18:00, taiyana74
Ramona enjoys her job because she is able to kids in an after school program. the work value ramona feels strongest about is a. leadership b. risk c. independence d. work with people select the best answer from the choices provided a b c d
Answers: 1
image
Computers and Technology, 23.06.2019 19:30, alangonsales6232
2. fluorine and chlorine molecules are blamed fora trapping the sun's energyob forming acid rainoc producing smogod destroying ozone molecules
Answers: 2
Do you know the correct answer?
Below is an ERD showing the 1:M relationship between Department and Employee entity types. This rela...

Questions in other subjects:

Konu
Mathematics, 24.07.2019 23:30
Konu
Biology, 24.07.2019 23:30
Konu
Mathematics, 24.07.2019 23:30
Konu
Advanced Placement (AP), 24.07.2019 23:30