subject

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

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 18:00
Which if the following allows you to view and access important information about your documents all in one location
Answers: 3
question
Computers and Technology, 22.06.2019 10:30
What can tanya do now to start preparing for the college and scholarship application process? think about her grades, activities in which she can get involved, possible part-time jobs at which she can work, and standardized tests she can take. (10 points) apex
Answers: 2
question
Computers and Technology, 22.06.2019 23:00
Which factor is the most important when choosing a website host? whether customers will make secure transactions the number of email accounts provided the purpose of the website the quality of the host control panel
Answers: 3
question
Computers and Technology, 23.06.2019 08:00
Which argument is not a valid filter? does not equal this quarter filter by cell color all of these are valid filter arguments.
Answers: 2
You know the right answer?
Below is an ERD showing the 1:M relationship between Department and Employee entity types. This rela...
Questions
question
Engineering, 18.07.2019 04:20
question
Social Studies, 18.07.2019 04:30
Questions on the website: 13722360