Modeling an emergency communication system

Assignment Help Basic Computer Science
Reference no: EM131220719

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: EM131220719

Questions Cloud

Challenges of integrating the international hrm function : MGT307 - international human resource management - Analyse the importance and challenges of integrating the international HRM function and organisational strategy in the multi-national organisation. How can the challenges identified be managed effe..
Derive a formula giving the 4 year interest rate : Using the expectations theory without term premiums, derive a formula giving the 4-year interest rate in 2020 as a function of 2-year rates in 2020 and the future.
What does this correlation tell you : Is this correlation evidence that having a high family income causes one to have high SAT scores? Is this correlation evidence that high SAT scores are a cause of higher income? Or, does this tell you something else? Explain your answer.
What happens to the yield curve in given situation : Suppose that some event has no effect on expected interest rates, but raises uncertainty about rates. What happens to the yield curve?
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. You may reach teachers by phone and/or email.
Program to scan 2 integer numbers from user : Write a program to scan 2 integer numbers from user, then check for below conditions: a). If both the numbers are equal, print a message "Both numbers are equal".
What are likely values of p explain : Assume that Acme pays the $107 with probability p. With probability 1 - p, Acme defaults and pays nothing. What are likely values of p? Explain.
Develop and write an alternative imc plan : Develop and write an alternative IMC plan that involves the company you currently work for or the company you want to start up. You must address the following in your IMC plan.
Relationship between the two variables across decades : Compute the average T-bill rate and average inflation for each decade from the 1960s to the 2000s. - Graph the relationship between the two variables across decades, and explain your results.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Could you empirically answer this question

Does the computer aspect of the research make this research less generalizable than traditional research, or does the fact that people throughout the world can participate make it more generalizable? Could you empirically answer this question?

  Distinguishing property of big data

Volume is the most distinguishing property of Big Data. However, Volume also interacts with the other properties of Big Data. For this Assignment, you will consider how the six 'V' properties of Big Data (Volume, Velocity, Variety, Veracity, Varia..

  Explain the relationship between the parameters

The assignment is to prepare a general plot that enables one to calculate the drag coefficient for flow past any submerged object as long as the sphericity can be calculated. This is needed to calculate the pressure drop from Eq. (1). The y-axi..

  File sharing on a local network

File Sharing on a Local Network

  Determines the change to be dispensed from a vending machine

Write a program that determines the change to be dispensed from a vending machine. An item in the machine can cost between 25 cents and a dollar, in 5-cent increments(25,30,35,..90,95,100), and the machine accepts only a single dollar to pay for t..

  Explain response time for jobs in observed system

Explain the response time for jobs in observed system? As function of N, number of terminals, give high-load bounds for throughput and response time; also provide low-load bounds.

  Write a function which prints the unique numbers in an array

Write a function which prints the unique numbers in an array.

  Determine if it is possible for the 185-lb woman to hoist

what smallest force must she exert on the horizontal cable? The coefficient of static friction between the cable and the rock is µs = 0.2 , and between the shoes of the woman and the ground m's = 0.8 .

  How do you determine the type of malware

How do you determine the type of malware that is present on the computer or device and provide a rationale for doing so? In your opinion, do you think that the vulnerabilities can be minimized in the future

  Explain what type of attack

A person in possession of a sample of the ciphertext and the corresponding plaintext is capable of what type of attack

  What is the probability p[b > 500,000] that a fax

What is the probability P[B > 500,000] that a fax has over 500,000 bits?

  A database command defining a table expressed

A database command defining a table expressed using the five database operators

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