The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 406 Weeks Ago, 6 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
You are required to produce an Entity Relationship Model (diagram) for a very simple electrical utility company prior to a full implementation of a relational database for the company’s activities. Your model should capture the key relationships (mappings) that exist between a small number of Entity Sets. These are provided for you below. In your completed Entity Relationship Model, you should define the Relationship Sets that describe the relationships that exist between the Entity Sets. Entity Sets Customers Call Centres Repair Departments Installation Departments Account Departments Equipment Departments Relationships (Mappings) Many Customers call many Call Centres Many Call Centres inform a single Repair Department Many Call Centres inform a single Installation Department Many Call Centres inform a single Account Department A single Repair Department visits many Customers A single Installation Department visits many Customers A single Account Department deals with many Customers Many Equipment Departments deal with many Repair Departments
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll