system analysis and design

Project Description:

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 neighbouring areas. as the city’s it director, you have been asked to set up an information system for the new winfield public transit authority. assume that multiple buses will run on each route.
source: valacich (2011)
3.1 based on the scenario above, draw an erd for the winfield public transit authority system. furthermore resolve many to many relationships.
(12 marks)
3.2 explain how you indicated the cardinality for the above erd drawn in task 3.1.
(1 mark)
3.3 identify all fields you plan to include in the tables.
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 1
1 Current viewersl
38 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.8
    60 Jobs 32 Reviews
    $500 in 10 Days