Course Solutions Uncategorized (Solved) : Consider One Relation Database Following Attributes Employee Number Empno Date Hired Date Q30749079 . . . .

(Solved) : Consider One Relation Database Following Attributes Employee Number Empno Date Hired Date Q30749079 . . . .

 

Consider a one-relation database with the followingattributes:

Employee number (emp_no), Datehired (date), Job title (job), Phone number (phone_no), Officenumber (office_no), Area (area), Salary (sal), project number(proj_no), Project budget (p_budget), Department number (dep_no),Department budget (d_budget), and Department manager employeenumber (mgr_emp_no). The following business rules apply:

No employee can manage more than one department at a time.

No employee can work in more than one department at a time.

No employee can work on more than one project at a time.

No employee can have more than one office at a time.

No employee can have more than one phone at a time.

No employee can have more

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post