Analysis of data modeling and database design

Assignment Help Database Management System
Reference no: EM13954359 , Length: word count:1500

Topic: Data Models and Technologies

Details: Scenario

The directors of Uxbridge College have recently decided to harness the pool of talent within the School of Computing to conduct an internal review of how to implement a new improved Management Information System (MIS.) As part of this exercise, you have been approached to investigate the possible data model designs for a new MIS (Management Information System) and produce a written report detailing your findings.

Task 1 : Analysis of Data Modeling and Database Design

1. The directors have stated that the old MIS was developed using the Network Model but have specified the new systems must be developed using the Relational Database Model.

Critically compare the Network and Relational data models and schemas. Within your critical comparison, include why you think the relational model is widely in use today. (P1.1)

2. Three possible database technologies have been identified as options to be used for the implementation of the database system.

i. Microsoft Access
ii. MySql
iii. Oracle

Select two of the database technologies and critically discuss their benefits and limitations. (P1.2)

No# of Pages: 6 pages (1,500 words)

Subject Area: Computational Science

Paper Style: Harvard

No# of Sources Required: 5

Language: English (U.K)

Reference no: EM13954359

Questions Cloud

Discuss the key factors that impact location decisions : Discuss the key factors that impact location decisions. As an example, if locating a facility in India, what location decisions would a fast-food chain have to consider as compared to the location decisions of a software company?
Determining the cash receipts in a bookstore : You were recently hired by a large retail bookstore chain. Your training involved spending a week at the largest and most profitable store in the district. The store manager assigned the head cash- ier to train you on the cash register and closing..
Discuss the importance of recognizing and implementing : Discuss the importance of recognizing and implementing different entry strategies and organizational arrangements which result in shared control and oversight through collaborative relationships, as illustrated in the Chapter 9 opening-discussion ..
Determine economic order quantity in gallons : The demand for coconut water at SLC WalMart is 600 gallons per week. The setup cost for placing an order to replenish inventory is $25. Orders are delivered by the supplier, who charges SLC Walmart $3/gallon for coconut water. Determine SLC WalMart’s..
Analysis of data modeling and database design : Analysis of Data Modeling and Database Design -As part of this exercise, you have been approached to investigate the possible data model designs for a new MIS (Management Information System) and produce a written report
Find the probability of the indicated result. : Assume that two marbles are drawn without replacement from a box with 1 blue, 3 white, 2 green, and 2 red marbles. Find the probability of the indicated result.
Not all companies are viewed as equal : In the land of free trade, the public does not view all industries as equal. Do you believe that is ethical? Do you believe that some industries are unfairly targeted? Should it be consumers' choice to partake in products that are not healthy for ..
How such tragedies affect productivity on global economy : Corporations have been affected by such tragedies as Hurrican Sandy, Japan's large earthquake. Explain how such tragedies affect the productivity on the global economy?
What is the energy of the emitted photon : A hydrogen atom initially in the n =3 level emits a photon and ends up in the ground state. What is the energy of the emitted photon? If this atom then absorbs a second photon and returns to the n =3,state what must the energy of this photon be?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Create a new test02 class

Write a toString method that will return a String containing all the relevant data for each of your objects.

  Data extraction and transformation

Prepare a project task list to include all the detailed tasks needed for data extraction and transformation.

  List full details of all hotels

List full details of all hotels

  Produce a distributed data design for enterprise

Produce a distributed data design for this enterprise. Show data fragmentation/partitioning and replication for each regional database location. Indicate what attributes are in each fragment

  Oracle sql complete the following steps to create a

complete the following steps to create a procedure to calculate the tax on an order. the bbtax table contains the

  Determine the manufacturing overhead cost

Determine the manufacturing overhead cost per unit of each of the companys two products under the traditional costing system.

  Dml stands for

DML stands for

  Write a join query that for every order placed on september

Write a join query that for every order placed on September 5, 1998, (use '05-SEP-1998') will list the order number and order date along with the customer number, last name, and first name of the customer who placed the order

  Create a database using professional principles and standard

Create a database using professional principles and standards

  What actions the dlbc should address avoiding or mitigating

what actions the DLBC should address avoiding or mitigating

  Prove that armstrongs axioms are sound and complete for fd

Prove that Armstrong’s Axioms are sound and complete for FD in-ference. That is, show that repeated application of these axioms on aset F of FDs produces exactly the dependencies in F+.

  What is the note about loretta swits character in mash

What is the note about Loretta Swit's character in MASH and Who were the two leading men who played the leading role in Bewitched

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