comm 226 erd case school of business n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
COMM 226 ERD case: School of Business PowerPoint Presentation
Download Presentation
COMM 226 ERD case: School of Business

Loading in 2 Seconds...

play fullscreen
1 / 7

COMM 226 ERD case: School of Business - PowerPoint PPT Presentation


  • 300 Views
  • Uploaded on

COMM 226 ERD case: School of Business. Chitu Okoli Associate Professor in Business Technology Management John Molson School of Business, Concordia University, Montréal. School of Business case.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'COMM 226 ERD case: School of Business' - tallulah-glenn


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
comm 226 erd case school of business

COMM 226ERD case:School of Business

Chitu Okoli

Associate Professor in Business Technology Management

John Molson School of Business, Concordia University, Montréal

school of business case
School of Business case
  • A School of Business keeps track of its alumni (graduates from its programs). It stores basic information about the alumni, such as their names and contact addresses. It also stores the major (or majors, maximum two) from which the alumnus graduated.
  • The School keeps in touch with alumni by mail, e-mail or telephone. Whenever an alumnus responds to a contact, the School records information learned from the alumnus during that contact.
  • To maintain strong ties to its alumni, the School holds various events around the world. Events have a title, date, location, and type (e.g., reception, dinner, or seminar). The School keeps track of which graduates have attended which events. Whenever an alumnus attends an event, the School might record a comment, which might include information that the School officials learned from that alumnus during that event.
  • When a School official knows that he or she will be meeting or talking to a graduate, a report is produced showing the latest information about that graduate and the information learned during the past two years from that graduate from all contacts and events the graduate attended.
step 1 exercise
Step 1 exercise
  • Identify the entities
  • For each entity, identify the attributes
  • Specify the relationships between entities
step 2 exercise
Step 2 exercise
  • Draw the entity relationship diagram
sources
Sources
  • This case is adapted from material provided by the Coordinator and instructors of COMM 226
  • Other sources are noted on the slides themselves