1 / 9

Entity Relationship Diagram (ERD) of Kaplan Singapore Group 8, Q. 01 By Anna Tserlingas

Entity Relationship Diagram (ERD) of Kaplan Singapore Group 8, Q. 01 By Anna Tserlingas. The Five Major Data Entities in focus are: (for part-time programme ). Partners Programmes / Courses Students Staff Facilities.

tracey
Download Presentation

Entity Relationship Diagram (ERD) of Kaplan Singapore Group 8, Q. 01 By Anna Tserlingas

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Entity Relationship Diagram (ERD) of Kaplan SingaporeGroup 8, Q. 01By Anna Tserlingas

  2. The Five Major Data Entities in focus are:(for part-time programme) Partners Programmes/ Courses Students Staff Facilities

  3. The fundamental relationship of Student and chosen course: Programme Has more than 1 Have Courses Mr. Ron K Shiflet Lecturers Have Helena Johnson Have HooSen Kai Course terms/semesters Have Facilities Have Have Orchard campus Email Wilkie Edge campus Materials Students Name Student no Study Guides Handouts

  4. Example of Kaplan’s Programme structure (Part-time): Business Admin Has more than 1 Has Course level Programme Diploma Financial Mgmt Adv Diploma Has more than 1 MktgMgmt Mgmt Partner ie; Murdoch CommMgmt Commerce Offer Offer Hosp & Tourism Degree Masters MBA Mgmt HR Mgmt Prof Acct Mktg Prof Acct Environ Science Psych Prof Acct

  5. An example of a list of data attributes: Students are given ID no. and assigned to an available class no. (intake)

  6. An example of a list of data attributes:

  7. A simple overall Entity Relationship Diagram (ERD) of Kaplan Singapore will look something like this:

  8. Awards & Accredition Mission Vision Name Has Kaplan Has Students Facilities Student ID Classrooms Has partners Mobile Has more than 1 Has more than 1 Library Email Courses Universities Staff Cafe Murdoch Lecturers Consist of Diploma Monash Program Manager Adv Diploma Part time/ Full Time Swineburn Degree Student Relationship Officer Northumbria Masters

  9. References Source of images from: www.montana.edu www.skyscanner.net www.kaplan.com.sg www.indiatalkies.com

More Related