Question: Remodel the employee database shown below and translate it into a document database. Employee Database: Document Database EXAMPLE: There are 6 tables as follows: salaries

Remodel the employee database shown below and translate it into a document database.

Employee Database:

Remodel the employee database shown below and translate it into a document

Document Database EXAMPLE:

database. Employee Database: Document Database EXAMPLE: There are 6 tables as follows:

There are 6 tables as follows: salaries dept_manager dept_no CHAR (4) emp_no INT (10) from_date DATE to_date DATE Indexes > emp_no INT (10) salary INT (11) from_date DATE to_date DATE Indexes titles employees emp_no INT (10) birth_date DATE first_name VARCHAR(14) last_name VARCHAR(16) #gender ENUMCM',F) hire_date DATE Indexes departments dept_no CHAR(4) dept_name VARCHAR(40) Indexes emp_no INT (10) title VARCHAR(50) from_date DATE to_date DATE Indexes dept_emp emp_no INT (10) dept_no CHAR(4) from_date DATE to_date DATE Indexes Document modeling { "_id": "", "contacts": [ { "name": "John Doe", "address": [{"type": "home" "street": "12 main"}, {"type": "work", "street": "18 main"}], "phone": [{"etc."}, {"etc."}, {"etc."}], "email": [{"etc."}, {"etc."}, {"etc."}], "pp_info": {"pp_num": 123455, "pp_country": "US"}, "groups": ["group1", "group2", "group3"]}, {"name": "Jane Doe", } ] }

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!