Data modelling and normalization methodology, Database Management System

Assignment Help:

MOSS VALE is a town with 15000 inhabitants. The fire department wishes to develop a system that automates the despatch of fire engines to attend fires. The ERD below describes the system.

The fire department leases three fire engines and employs 14 people. Each year, there are approximately two hundred despatches. Currently, the system is manual and all records are retained in a file system. The fire department has a duty manager on duty 24 hours a day for each day of the year and the duty manager is in charge of all despatches.  If the system is automated, it is unlikely that there will ever be more than two concurrent users.

The mayor has hired an outside consultant who recommended that the town council purchase a despatch package developed by a software company. This package comes with the ORACLE DBMS and the smallest configuration allows for a maximum of ten concurrent users. The package covers all the requirements very well - indeed, it has many functions that the fire department will never use. The council does not use ORACLE at present and would need to use contract staff for DBA tasks. The total cost of the package is approximately $150000 per annum, excluding contract staff, who should cost no more than $10000 per annum.

Very few people on the town council understand the database approach and many believe that the current manual system does not require upgrading.

You are the CIO for the town council. Write a memorandum to the mayor and comment on the solution provided by the consultant as well as the option of retaining the current manual system. If you believe that neither solution is optimal or most cost efficient, recommend an alternative solution. Whether or not you choose to use a database, briefly explain the database approach and provide an overview of benefits / advantages and  potential costs relevant to a database solution. Your memorandum should be no longer than 500 words.


Related Discussions:- Data modelling and normalization methodology

EER models, Ask question #MinimThe Georgia Tech Library (GTL) has approxima...

Ask question #MinimThe Georgia Tech Library (GTL) has approximately 16,000 members, 100,000 titles, and 250,000 volumes (an average of 2.5 copies per book). About 10 percent of the

Define a table in sql known as client for store information, Define a table...

Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

Illustrate the class diagram for class room scheduling, Illustrate the clas...

Illustrate the class diagram for class room scheduling system If in any college, the number of classrooms are limited which have to be allocated to various classes and instruct

Sql, Events4Fun is an event management company in Europe with branches in S...

Events4Fun is an event management company in Europe with branches in South America as well. The company is well-known for its efficiency, good-quality services, and affordable char

Commercial database architecture, At its most essential level the DBMS arch...

At its most essential level the DBMS architecture can be divide into two parts: the back end and the front end. The back end is responsible for managing the physical database an

Customer service, as a customer service employee, explain five measures you...

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

Illustrate the collaboration and relationship diagram, Illustrate the colla...

Illustrate the collaboration and relationship diagram A collaboration is the society of interfaces, classes and other elements which work together to provide some cooperative b

Windows 8 Administrative Tools, Which two tools are used to administer user...

Which two tools are used to administer users for Active Directory?

SQL, Ask Write the SQL code that will create the table structure for a tabl...

Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in

Non-redundant cover and canonical cover, Given the following set of functio...

Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

Write Your Message!

Captcha
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