******PLEASE USE HTTPS://ERDPLUS.COM/STANDALONE (ERDPLUS) TO CREATE RELATIONAL SCHEMA******

E1.1 Figure 1 displays the Buzz Company ER-diagram from the Assignment 1. Please map this ER-diagram into the relational schema. Do not forget to mark all columns with unique values and optional values (including FKs) if any. Attach the screenshot of the relational schema into section E1.1 of the Answer book. Figure 1. Buzz company ER-diagram First_name Last_name Rater_ID Score intern_ID (Full Name) Rater's comments (0) Intern IsRated Evaluation Intern_Phone number Hires Dept_name Department Dept_address Years since establishment Dept establishment date E1.2 Figure 2 displays an ER-diagram of a software company. Map this ER-diagram into the relational schema. Do not forget to mark all columns with unique values and optional values (including FKs) if any. Attach the screenshot of the relational schema in the section E1.2 of the Answer book. Figure 2. Software company ER-diagram Mentors (Buglio BugiD Bug description reports (0) Emp ID Software developer Bug Emp_name Emp_skill fixes E1.3 Figure 3 displays an Enhanced ER-diagram of the sponsors (superclass) and their subtypes for different college events. Map this ER-diagram into the relational schema. Do not forget to mark all columns with unique values and optional values (including FKs) if any. Attach the screenshot of the relational schema in the section E1.3 of the Answer book. Figure 3. Sponsorship ER-diagram Sponsor ID Address Event ID SPONSOR Holds EVENT EVENT Sponsor Type Event Name DEPARTMENT TEAM TEAM CLUB Team Name ( Club name Sport Dept Name Club President E1.4 Figure 4 displays a Trucking dispatcher ER-diagram. Map this ER-diagram into the relational schema. Do not forget to mark all columns with unique values and optional values (including FKs) if any. Attach the screenshot of the relational schema in the section E1.4 of the Answer book. Figure 4. Trucking dispatcher ER-diagram TruckID DriverlD Truck Model DriverLicenseNo Driver Owns Truck DriverName Provides RegionlD Region Receives Service RegionName E1.1 Figure 1 displays the Buzz Company ER-diagram from the Assignment 1. Please map this ER-diagram into the relational schema. Do not forget to mark all columns with unique values and optional values (including FKs) if any. Attach the screenshot of the relational schema into section E1.1 of the Answer book. Figure 1. Buzz company ER-diagram First_name Last_name Rater_ID Score intern_ID (Full Name) Rater's comments (0) Intern IsRated Evaluation Intern_Phone number Hires Dept_name Department Dept_address Years since establishment Dept establishment date E1.2 Figure 2 displays an ER-diagram of a software company. Map this ER-diagram into the relational schema. Do not forget to mark all columns with unique values and optional values (including FKs) if any. Attach the screenshot of the relational schema in the section E1.2 of the Answer book. Figure 2. Software company ER-diagram Mentors (Buglio BugiD Bug description reports (0) Emp ID Software developer Bug Emp_name Emp_skill fixes E1.3 Figure 3 displays an Enhanced ER-diagram of the sponsors (superclass) and their subtypes for different college events. Map this ER-diagram into the relational schema. Do not forget to mark all columns with unique values and optional values (including FKs) if any. Attach the screenshot of the relational schema in the section E1.3 of the Answer book. Figure 3. Sponsorship ER-diagram Sponsor ID Address Event ID SPONSOR Holds EVENT EVENT Sponsor Type Event Name DEPARTMENT TEAM TEAM CLUB Team Name ( Club name Sport Dept Name Club President E1.4 Figure 4 displays a Trucking dispatcher ER-diagram. Map this ER-diagram into the relational schema. Do not forget to mark all columns with unique values and optional values (including FKs) if any. Attach the screenshot of the relational schema in the section E1.4 of the Answer book. Figure 4. Trucking dispatcher ER-diagram TruckID DriverlD Truck Model DriverLicenseNo Driver Owns Truck DriverName Provides RegionlD Region Receives Service RegionName