Question: Create an Enhanced Entity Relation (EER) model for the following description: Softech software house company has different types of employees working for the success of

 Create an Enhanced Entity Relation (EER) model for the following description:
Softech software house company has different types of employees working for the

Create an Enhanced Entity Relation (EER) model for the following description: Softech software house company has different types of employees working for the success of the company. The software house keeps record of a unique employee number, employee name, dob, address, hiring date and contact number. Types of employees include secretary with a typing speed, software programmer with a specialised programming language name, system analyst with a total experience. Some of the employees are assigned a role of manager to manage different software development projects. The company hires employees as either salaried employees, who are paid monthly or hourly employees, who are hourly wages employees. The company records salary for a salaried employee and pay scale for an hourly employee. Hourly employees belong to an employee union. Consider the following tables/relations of a company and answer the following question. Emp(eid: int, ename: varcahar(20), age: int, salary: float) Works(eid: int, dept_id: int, pcttime: int) Dept(dept_id: int, dname: varchar(20), budget: float, managerid: int) Give an SQL example of a foreign key constraint that involves the Dept relation (Create a table from the above relations which involves a foreign key referring to the Dept relation). What are the options for enforcing a referential integrity constraint when a user attempts to delete a record/tuple from Dept table

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!