Modeling an emergency communication system

Assignment Help Business Economics
Reference no: EM131217907

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

Questions Cloud

Estimate and evaluate a model of household saving : Estimate and evaluate model of household saving. Assessing whether the significant impact increase in household saving rate soon after the onset of the 2008 financial crisis can be considered permanent or a transitory development.
Categories virtual reality and medical diagnosis : 1) Alapplications fall into two broad categories virtual reality and medical diagnosis 2) Neural networks are patterned after computer networks, with one computer connected to another
How has our thinking about categories such as the color-line : How has our thinking about categories such as the color-line, mestiza, borderlines, minority-majority sexuality, or ability-disability changed or influenced the way we talk about cultural diversity today? When we consider cultural diversity, does ..
How does international trade affect each market structure : How does the role of the government affect each market structure's ability to price their products? How does international trade affect each market structure?
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.
Is it bad to have a trade deficit or does it not matter : Trade is designed to create bigger market opportunities, so why is the balance of trade so out of balance for the U.S.? Is it bad to have a trade deficit, or does it not matter?
How various provisions of the treaty hurt germany economy : Do you agree with the authors of the document that Germany was being poorly treated? What response to their complaints might defenders of the treaty have made?
If both the numbers are equal : 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".
Derive an expression for equilibrium output : Derive an expression for equilibrium output. What is the multiplier? Now suppose that G = G- (i.e. that G is an exogenous constant). Derive an expression for equilibrium output and the multiplier. Is this multiplier larger, smaller, or equal to the..

Reviews

Write a Review

Business Economics Questions & Answers

  Q each day matt eats lunch at school he likes only twinkies

q. each day matt eats lunch at school. he likes only twinkies t and soda s and these provide him a utility of utility

  Sale of used goods do not add to income of a country

Why do sale of used goods do not add to income of a country in a particular year? If you think of income as the inflow in your bank account. All outflows are just expenditures. So I think of income as how much stuff can someone buy in a particulate y..

  Rival firm cuts its price-best strategic response of firm

When a rival firm cuts its price, the best strategic response of the firm, in many cases, is to retaliate with a price cut of its own. What practical advices or tactics would you provide to business executives as to what they can do that won’t land t..

  About the increasing geometric gradient

You are told that the present worth of an increasing geometric gradient is $88,146. If the cash flow in year 1 is $25,000 and the gradient increase is 18% per year, what is the value of n? The interest rate is 10%per year.

  In addition to agricultural products and manufactured goods

The largest corporation based in the United States is: In addition to agricultural products and manufactured goods, the United States is also the world's largest exporter of: In order for a marketer to operate efficiently in a foreign country, it is ..

  Selling baskets made out of tree vines

Sarah earns $500 per week selling baskets made out of tree vines. With this money she buys sushi and rose bushes. Each piece of sushi costs $1 and each rose bush costs $10. If Sarah spends $170 per week on sushi, the maximum quantity of rose bushes c..

  How much money must be invested in an account

How much money must be invested in an account that pays 6% per year interest to be worth $20000 at the end of 8 years of (forgetting the leap years and making "convenient" assumptions) : annually

  What is the short run equilibrium level of each firms output

Assume that there is a competitive industry composed of five identical firms, each of which has the following cost schedule: The firm's level of marginal cost is equal to a quarter of its own level of output. For example, at an output level of 10, ma..

  Qa mechanical engineer who recently graduated with a

q.a mechanical engineer who recently graduated with a masters degree is contemplating starting his own commercial

  Gasoline futures contracts-the initial margin requirement

You are short 30 gasoline futures contracts, established at an initial settle price of $7.62 per gallon, where each contract represents 42,000 gallons. Your initial margin to establish the position is $13,875 per contract, and the maintenance margin ..

  More transactions occur in the economy

As income and the GDP increase, more and more transactions occur in the economy. These transaction demands for money are associated with money's property as a medium of exchange. Please comment on different type of these demands and provide some exam..

  General monetary model

This question uses the general monetary model, where L is no longer assumed constant.

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