5. Convert the following ERD to a relational model. SEATING RTABLE Seating ID Uses RTable Nbr Nbr of Guests Start TimeDate RTable Nbr of Seats RTable Rating End TimeDate EMPLOYEE Employee ID Emp Lname Emp Fname ASSIGNMENT Start TimeDate End TimeDate Tips Earned WAITER MANAGER Hourly Wage (Specialty) Manages Monthly Salary Manages

Task Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did”field of the Department table.    Through Java application, use SQL to insert (random but meaningful) data records in the above tables:1) Create two different departments (named: Marketing and Human Resources)2) Create at least three employees per department (6 employees in total). A rank of an employee is an integer value between 1 and 3.3) Create at least three different projects per department (6 projects in total). The start year is between 2018 and 2020.

All entity names, relationship names, and attribute definitions must be correct.

which rules apply to desigining table with less redundancy? a) Binary Relationship b) Reflective Relationship c) Weak entity d) Normal form