HomeworkLib
Question

Train Company ER diagram

Draw an ER diagram for the following application (use Cardinality ratio for relationships not (min, max)). A Train Company owns a number of trains. Each train is allocated to a particular route, although some routes may have several trains. Each route passes through a number of cities. One or more drivers are allocated to each stage of a route, which corresponds to a journey through some or all of the cities on a route. Some of the cities have a garage where trains are kept and each of the trains is identified by a unique number and can carry different numbers of passengers since the trains vary in size and can be single or double-decked. Each route is identified by a route number, and information is available on the average number of passengers carried per day for each route. Drivers have an employee number, name, address, and sometimes a telephone number.

Databases   Computer-Science   Concepts-Of-Databases   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Train Company ER diagram
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Consider this Entity-Relationship model, drawn for the following business rules. • A route is uniquely identified...

    Consider this Entity-Relationship model, drawn for the following business rules. • A route is uniquely identified by a route number • A bus is uniquely identified by bus registration number • A route can have one or more busses assigned to it at any given time • A bus is assigned to only one route at any given time. • Not all busses are assigned to routes (some may undergo servicing or kept on reserve). Bus Route 0..1 RegNo {PK}...

  • Information: All trains need to run to a timetable so that passengers may find the train...

    Information: All trains need to run to a timetable so that passengers may find the train they want to use easily and conveniently. When the line is opened a timetable must be produced. The government have stated that they require three trains per hour to run between London and Birmingham and also three per hour to run between Birmingham and London. The government have stated that: the journey time will be 49 minutes, it takes 6 minutes to empty the...

  • Create an ER model for the scenario. Make sure that you read the description carefully. Your...

    Create an ER model for the scenario. Make sure that you read the description carefully. Your diagram should reflect all entities, attributes, and relationships in the description. You should make sure each entity has a primary key (a unique identifier). Use the relationship types we used in class (one-to-one, one-to-many, or many-to-many). Don't forget, attributes can describe both entities and relationships. Scenario 2: Tracking Trips for the SchUber Taxi Service A new Philadephia startup called SchUber is a matching service...

  • Create ER model to a taxi company

    The company is composed of many offices: Each office has:o A name, a city and a telephone number.o Each office has a Manager, several taxi owners, drivers and one administrative staff. The Manager is responsible for the day-to-day running of the office:1. Check the number of Jobs2. Check the number of complete jobs3. Check the number of failed jobs and the reason.Each manager has a name, ID, Office number, address, age(Less than 64) and telephone number (can have more than...

  • 3. (12 points) For each of the descriptions below, develop an ER diagram using draw.io. Create...

    3. (12 points) For each of the descriptions below, develop an ER diagram using draw.io. Create a new page in your draw.io file for each diagram and name them appropriately (e.g., “3a” and “3b”). Include entities, attributes (identifier, simple, composite, derived), relationships (cardinality, modality). a. A car company has a database where each car has an identifying serial number and a manufacturing completion date. Each car is an example of a certain model. All models have an identification number, name...

  • Create an ER Diagram showing all entities and relationships that describe the scenario below: You are...

    Create an ER Diagram showing all entities and relationships that describe the scenario below: You are commissioned to design a database to keep records of a small college. You talked with various key members of this community and obtained the following information: The college keeps information about students and student performance. Every student is known by her/his first name, initials and last name. They are also identified by a unique StudentID provided by the University. Every student also belongs to...

  • 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s),...

    1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or...

  • C++ ONLY Please TRAINS DESCRIPTION You are completing a program that allows for several different types...

    C++ ONLY Please TRAINS DESCRIPTION You are completing a program that allows for several different types of passenger trains. One train can hold only cats. Another train can hold only wizards. You are going to create a Wizard class, a Cat class, and a Train class. You are provided the driver, lab2.cpp. The Train class should be a template class where the type of passenger is the template data type. Specifications cat class Attributes: name of cat breed of cat...

  • Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...

    Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities, attributes (if there are less than three specified in the business statements, please add some extra attributes), identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. .b) Extend Q1.a) to apply generalization/specialization technique to construct an Enhanced-ER (EER) diagram. The EER diagram should specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization....

  • AGE and TRAINS Andrew Gilbert Edwards (AGE) a Native-American employed-at-will had been a commuter train operator...

    AGE and TRAINS Andrew Gilbert Edwards (AGE) a Native-American employed-at-will had been a commuter train operator for Pond Pacific Railway (PPR). The company began with a steam locomotive during President Warren Harding’s administration. He logged over 12 hours per shift and received every award and commendation the employer had to offer for being ahead of time, on time but never behind time. In the past year, his supervisor was looking to hire some female conductors. As train designs improved, AGE...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT