SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 213 Weeks Ago, 4 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 16 Nov 2017 My Price 8.00

Winfield is a small city with a population of 22,000.

Winfield Transportation System

Winfield is a small city with a population of 22,000. Until now, Winfield was served by a bus route from a nearby city. The Winfield City Council has held a bond sale to fund the purchase of several buses to serve three routes in Winfield and neighboring areas. As the city’s IT director, you have been asked to set up an information system and database to manage the new system. You directed your team to follow best practices to develop a normalized database to manage scheduling of drivers and buses that is simple, flexible and non-redundant.

Assume that drivers can be assigned to different buses, and multiple buses will run on each route. You can also assume the bus service is free for Winfield residents, so no ticket purchases are required.

Hint: The purpose of this assignment is to demonstrate an understanding of database modeling and design concepts and techniques. First, follow the examples on pages 287-291, 302 to build an ERD and decompose a M:N relationship using an associative entity. Assume a M:N relationship between drivers and buses. Thus, a driver can drive many buses and a bus can be driven by many drivers. Now, decompose this relationship using an associative entity. Next, assume a M:N relationship between bus and route. A bus can be assigned to multiple routes and a route can have multiple buses assigned. Decompose this relationship using an associative entity, as well. Next, convert the ERD to a normalized table design and include the primary data fields. While using MS Access is encouraged to describe the data table designs, it is not required. You can also use the text or graphical notations contained in chapter 9 (reference p. 298-303). Refer to the Activities Page for links to three short YouTube videos that describe normalization, and how to implement one-to-many and many-to-many relationships using MS Access.

Tasks

  1. Draw an ERD for the Winfield Public Transit Authority system and indicate the cardinality.
  2. Create 3NF table designs and include the fields for each of the tables.
 

Answers

SophiaPretty
(5)
Status NEW Posted 16 Nov 2017 12:11 PM My Price 8.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)