Logical Data Modeling for a Communication System

Logical Data Modeling for a Communication System You are modeling an emergency communication system used to contact teachers in case inclement weather emergencies cause delayed openings or closures of the school. You may reach teachers by phone and/or email. The school must have at least one means of contact (phone or email) for each teacher. Each teacher may have more than one of each contact type. Which type of entity would you use in conjunction with the TEACHER entity to model a teacher’s contact information? You decide to model a CONTACT table with primary key of Teacher-ID and Contact-Info, which is the contact information itself. The school principal, a major stakeholder, tells you she wants to track the area code for each teacher’s phone number(s): Will your original modeling concept work? If not, how would you change the model to reflect the principal’s request? How many entities would you need to represent the unique attributes of telephone numbers and email addresses so that no entity contained null values? The principal reminds you that every teacher must have at least one phone number, but having an email address is not a requirement. Where would you reflect the phone number constraint in your model? Deliver this modeling assignment as a 2- to 3-page paper that includes your models and your responses to the questions provided herein. Include a title page and reference page. Make sure your paper follows APA style according to the CSU-Global Guide to Writing and APA Requirements. Cite two to three scholarly articles or pertinent trade journal articles to support your choices of logical models. You may not use Wikipedia for any CSU-Global assignment. For this assignment, a credible source is defined as: A scholarly or peer-reviewed journal article A newspaper article A trade or industry journal article, publication, or website, including those from trade organizations