Question

(a) The students from the Faculty of Computing will go for an internship during the last semester. Each student has information including the student ID, name, phone number, email, and address. All students need to find at least one company before going for an internship. Although they get many offers from companies, the student needs to choose only one company for their internship. Each company has the company ID, company name, company email, company address, company phone number, and company type either it is a Multinational Company (MNC) or Government Linked Companies (GLC). MNC refers to a company that has offices in countries around the world. Meanwhile, GLC refers to a company linked with the government sector. A company can have more than one student for the internship. The application of the internship information consists of the start date, end date, and job scope that relate to the computer science field. If the job scope is not related to computer science, students need to decline the offer. Upon receiving the offer and both parties agree (student and company), the company needs to assign an industrial supervisor to the students. Besides the industrial supervisor, each student will also have a faculty supervisor assigned to them. Both supervisors need to contact each other to discuss student progress or problems during the internship. Supervisors can have many internship students, but each student can only have one industrial supervisor and one faculty supervisor. Information on staff id, name, phone number, and email are required for both supervisors (industry and faculty). Given that information, using Crow’s Foot notation, create an Extended Entity Relationship Diagram (EERD) containing all primary keys, foreign keys, connectivity, and main attributes.

I NEED A COMPLETE EERD DIAGRAM... ASAP.. PLEASE

THANK YOU

Answer 1

Please find below the steps to obtain the EERD for the given system:

Step 1: List entities and sub-entities:

System will have below major entities:

i. Student: To store student details

ii. Company: to store company details

iii. MNC: Company type MNC

iv. GLC: Company type GLC

v. JobOffer: A weak entity with student and company as owner entities to store the offer details along with its status of acceptance or rejection

vi. Staff: The industrial and faculty supervisor details

Step 2: List relationship between the entities:

i. Company has two sub types –MNC and GLC, where sub types will have a primary key from its parent entity.

ii. Staff will work for one company, thus will have a foreign key to its company.

iii. Student gets many offers from many Companies and a Company makes many offers to many Students. It is a M:N relationship which will be stored as separate entity with additional attributes (start_date, end_date, job_Scope)

iv. Few of the jobs from JobOffers will be selected with status = accepted. That needs to be stored as separate table having assigned one staff member as industrial supervisor and another as faculty supervisor.

v. MNC has office in many countries, thus an additional table OfficeCountry is needed to store multiple countries for MNC type company as OfficeCountry(Country_ID, Name, Company_ID)

Step 3: Attributes to the entities:

i. Student( ID, name, phone number, email, address)

ii. Company(company_ID, company_name, company_email, company_address, company_phone_number, company_type)

iii. MNC(company_ID, Office_Country)

iv. GLC(Company_ID, Sector_name)

v. jobOffer(student_id, company_id, start_date, end_date, job_Scope, offer_status)

vi. Staff( staff_id, name, phone_number, email, position, company_id)

Step 4: EERD (Enhanced Entity Relationship Diagram)

*PK is primary key and FK is foreign key