Question: read the task and instructions carefully and submit your solution before the given deadline. Please complete reading page 1 before going to page 2. In

read the task and instructions carefully and submit your solution before the given deadline. read the task and instructions carefully and
read the task and instructions carefully and
Please complete reading page 1 before going to page 2. In this task, you will be given a text that describes a company le pape 2. Each student should complete the two steps below to full solve the task and take the full mark. Step 1: Represent the company description as an Eragran, including all relevant constraints. To complete this step: Each student should download Lucidchart app using MS-Teams. A video about downloading lucidchart has been added to learning Every student should use Lucidchart to draw the ERD The student should take a screenshot of his solution showing his/her user lo as the example below in Rede: For each entity name in the ERD the student should concatenate his University ID as the example belowi Red Step 2: The student should transform (ERD Mapping the ERD to relational schema including all relations, PK and FK.constraints. Important Notes: 1. Students should follow the given instructions exactly, otherwise will not be given the grade 2. The solution of BOTH tasks (task 1 and task 2) should be included in a single PDF File. The student will submit this file to e-learning. No submission will be accepted via email nor alter the deadline 3. Deadline: Saturday 27" March at 11:59 PM Page - 2 Description of a company: Consider a company with several departments. Each department is identified by a name, ID, and a Location. A department may have several Locations. Each department has may employees. Employees are identified by their names, IDs, Addresses and job sites. Each employee is either an Engineer or a skilled worker. Furthermore, each employee in the company belongs to one department. Each department is controlled by a single director. A director is responsible for many employees in the department The date of joining an employee in the department is recorded. Each department is responsible for a number of projects. Although an employee works in one department, however he she can be involved to several projects. The number of hours worked by an employee in a project is recorded. Finally, each Employee may have one or more dependents, and each dependent is belongs to one employee BIVA I O. - Shapes TO ( * ) After each entity name include your university ID number when you create print screen, your user ID should be shown ODOU OB OOODDI OOSO OODO * BOO. Department 0190334 Employee 0190334 Name Dep_ID Name 00 OOOO

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 General Management Questions!