DATABASE SYSTEM Exercise Represent each of the following requirements with an EER/ER diagram: O Assume that you

DATABASE SYSTEM

Transcribed Image Text:

Exercise Represent each of the following requirements with an EER/ER diagram: O Assume that you are a database specialist for Kulliyyah of Information and Communication Technology (KICT). You are required to create a conceptual data model for Industrial Attachment Program (IAP). This program is designed for KICT students to gain industrial experience. Participating companies signed- up with this program offered IT projects and research assignments. The following are the data requirements gathered for the IAP: O Final year undergraduate or postgraduate students in KICT are authorized to participate in IAP. Students must belong to either one of the two groups. OUndergraduate students are recognized with the following attributes: Student ID, Name, Major, Department, Sex, Credit Hours and Start date. While attributes for postgraduate students are Student ID, Name, Major, Department, Sex, Thesis and Research Domain. Exercise Represent each of the following requirements with an EER/ER diagram: O Assume that you are a database specialist for Kulliyyah of Information and Communication Technology (KICT). You are required to create a conceptual data model for Industrial Attachment Program (IAP). This program is designed for KICT students to gain industrial experience. Participating companies signed- up with this program offered IT projects and research assignments. The following are the data requirements gathered for the IAP: O Final year undergraduate or postgraduate students in KICT are authorized to participate in IAP. Students must belong to either one of the two groups. OUndergraduate students are recognized with the following attributes: Student ID, Name, Major, Department, Sex, Credit Hours and Start date. While attributes for postgraduate students are Student ID, Name, Major, Department, Sex, Thesis and Research Domain.

Answer rating: 100% (QA)

Identified strong entities are Student Undergraduate Postgraduate Lecturer ResearchAssignmen... View the full answer