Convert the following ER Diagram (Figure 1) into a database schema in implement it in SQLite db Browser. Add atleast two records in each of the table. regions region_id region_name jobs job_id...


Convert the following ER Diagram (Figure 1) into a database schema in implement it in SQLite<br>db Browser. Add atleast two records in each of the table.<br>regions<br>region_id<br>region_name<br>jobs<br>job_id<br>job_title<br>min_salary<br>max_salary<br>dependents<br>dependent_id<br>countries<br>country_id<br>country_name<br>first_name<br>last_name<br>relationship<br>employees<br>*employee_id<br>first_name<br>locations<br>Font<br>last_name<br>location_id<br>departments<br>* department_id<br>department_name<br>email<br>street_address<br>phone_number<br>hire_date<br>postal_code<br>city<br>state_province<br>salary<br>manager_id<br>Figure-1<br>Rubrics for Part-B (50% Overall Weightage)<br>1. All the above-mentioned entities and attributes are implemented. Student have submitted<br>the evaluation in the format specified. (20%)<br>2. Atleast two records are added into each of the table. (20%)<br>3. Overall correctness of the Implementation including specification of Primary key,<br>Foreign Key, Data Type and other constraints added. (40%)<br>4. Student research about Recursive relationship and how it is implemented in the database.<br>(20%)<br>

Extracted text: Convert the following ER Diagram (Figure 1) into a database schema in implement it in SQLite db Browser. Add atleast two records in each of the table. regions region_id region_name jobs job_id job_title min_salary max_salary dependents dependent_id countries country_id country_name first_name last_name relationship employees *employee_id first_name locations Font last_name location_id departments * department_id department_name email street_address phone_number hire_date postal_code city state_province salary manager_id Figure-1 Rubrics for Part-B (50% Overall Weightage) 1. All the above-mentioned entities and attributes are implemented. Student have submitted the evaluation in the format specified. (20%) 2. Atleast two records are added into each of the table. (20%) 3. Overall correctness of the Implementation including specification of Primary key, Foreign Key, Data Type and other constraints added. (40%) 4. Student research about Recursive relationship and how it is implemented in the database. (20%)

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here