dcsimg
Results 1 to 1 of 1

Thread: Some problems with ERD

  1. #1
    Join Date
    Oct 2011
    Posts
    0

    Some problems with ERD

    Hi Guys,
    I am a first year business student and our teacher has given us a scenario to create ERD from. I have came up with a design but I am a bit confused. It would be fantastic if I could get your opinion whether it is correct or not or if somebody could point me to the mistakes I am making. I have attached my diagram to this post. Here is the scenario:

    "The American Railway Co has 19 routes in US most of which offering at least two departures each day. To cover all these routes, the company has many trains. Some trains are always assigned to the same route but most trains cover more than one route. Most trains have different classes: economy, business, and first class. Some trains have only one class.

    Some routes have many departures each day. Each departure is assigned a train some of which only have economy seats while others offer all classes.

    Customer selects the departure, the system shows the available categories on the train. The customer selects his preferred category and the system provides the price for the trip. "


    I would really appreciate your help.
    Best Regards,
    John
    Attached Images Attached Images

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •