Modeling an emergency communication system

Assignment Help Basic Computer Science
Reference no: EM131218820

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?

Reference no: EM131218820

Questions Cloud

What is the role of sql dcl in enforcing them : Explain the necessity of defining processing rights and responsibilities. How are such responsibilities enforced, and what is the role of SQL DCL in enforcing them?
An expression for the values of the prediction coefficient : Find an expression for the values of the prediction coefficients which minimize the mean-square prediction error.
What are your most distinguishing leadership traits : What are your most distinguishing leadership traits? What traits do you strive to learn to develop? As a follower, what leadership approach do you prefer from your leader?
Selecting a wan service provider : The type of support and traffic can be the factors when selecting a WAN service provider... Would reliability an important factor? Would security (such as data integrity) an important factor? Please explain
Modeling an emergency 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.
Find a general expression for the autocorrelation function : Show that the autocorrelation function of the AR(2) process satisfies the difference equation.- find a general expression for the autocorrelation function of an AR(2) process.
Demonstrate most important dimensions of the hofstede model : Demonstrate the most important dimensions of the Hofstede model for a U.S. company to consider when opening in the countries chosen. Predict the economic opportunities of your recommendations.
Create the picture table in the media database : Use the Microsoft SQL Server Management Studio to submit the SQL statement in Review Question 10.3 to create the PICTURE table in the MEDIA database.
Find the absolute bandwidth : A random process has a PSD function given. - Find the absolute bandwidth. - Find the 3 dB bandwidth.  - Find the RMS bandwidth.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Create a method to iterate through the list

Create a method to iterate through the list and have the three characters jump each of the heights contained in the list.

  Determine the minimum of f x by hand

Determine the minimum of f ( x ) by hand. Report the values of the optimum x and the function value at this point.

  Benefits of creating web presence for a small business

What are some of the benefits of creating web presence for a small business, including marketing and increased customer base?

  Summarize the key points of the individual assignments

Identify regulatory compliance requirements for business managerial situations including those that relate to Sarbanes-Oxley Act of 2002 (SOX).

  Display the status of a process

Use this code snippet as your guidance. You need to add the following options in this program 1. Give the user an option to enter different status for a process 2. Display the status of a process after a process's state has been changed by the user.

  Menu selection and organization

Describe the considerations that you would take into account when selecting the menu style for an application and why. Support your response with examples.

  Provides permanent storage for data and instructions

Provides permanent storage for data and instructions that do not change, such as programs and data from the computer manufacturer.

  Flowchart for batch control tape

Design a document flow chart to depict each of given situations. Batch control tape is prepared along with set of transactions to make sure completeness of the data.

  Are robots remotely controlled by humans really robots

Are robots remotely controlled by humans really robots?

  Business process engineering

Does LEAN practice concepts align closely with Business Process Engineering?

  What is the output of this code sequence

What is the output of this code sequence?

  Draw erd with key attributes

The database should keep track of the date he/she started managing the school. Data stored on each school includes the school’s code, name, address (town, street and postcode) and phone. For the above scenario, you need to perform the following tasks..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd