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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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