A car rental company owns mini-buses that are used for charter trips to other states in the United States. The company has created a computer system to track the buses it owns, including each bus's ID number, name, and seating capacity. The company also tracks information about the various states, such as their names and populations. Every time a bus is chartered, it is important to know the date that the trip is to take place and the number of people on the trip. The company also keeps information about each driver, such as Social Security number, name, birthdate, and contact information for next of kin. Buses travel to only one state per visit.
- Using MS Visio, create a 1-2 page data model ER diagrams.
- Copy and paste in MS word document.
- Include entities, attributes, identifiers, and relationships.
- Which entities are dependent? Which are independent?
- In addition to the lecture, be sure to review the readings as you work on this project.