Modeling an emergency communication system

Assignment Help Basic Computer Science
Reference no: EM131223128

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

Dealership is moving into a newly built facility in a suburb

America One Car (AOC) dealership is moving into a newly built facility in a suburb town of Washington, D.C.. You are retained as a consultant by AOC dealership to design

Sophistication to your dbms application

You may choose to add more sophistication to your DBMS application, but you are not required to do so. While the more you do, the better your performance will be judged, it

Number of liters of gasoline

A liter is 0.264179 gallons. Write a program that will read in the number of liters of gasoline consumed by the user's car and the number of miles traveled by the car and wi

Differentiate system software and application software

Write down the difference between system software and application software? Choose two of the application you listed and describe how you determine version of these programs.

Design a program that prompts the user to enter a number

Design a program that prompts the user to enter a number within the range of 1 to 10. The program should display Roman numeral version of that number. If the number is outsi

What is the regular selling price of the office furniture

Miranda purchases office furniture for a wholesaler listed at $800, less discountes of 20% and 10%. She has overhead expenses of 20% of the cost and wants to have an operati

Given a 3 millisecond seek time

Given a 3 millisecond seek time for a disk drive and assuming that once you reach the starting track you will write the file as contiguous sectors, how long will it take to wr

Reasonable parameters of the law

1. Explain your method of attack and operation within reasonable parameters of the law. 2. Discuss specific malware, social engineer, or any other type of attacks you would de


Write a Review

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