{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]

Comfort Bus (CB) operates a bus company that specializes in traveling on freeways between major cities in California, Oregon, Washington, and Nevada states. The firm needs to create a passenger reservation system.
Background
The owner of CB wants to provide better service to customers. He decided to hire a professional to develop a passenger booking system. When the system is online, the customers can check the bus routes and schedule, book, or cancel their bookings from their computers or phones. The company can also run reports to show its sales and generate information to improve its operations. You are hired to help the owner design a database for supporting the system. In an interview with the owner, you found the following information about the expected system.

  1. CB currently has a fleet of 50 buses. The capacity of passenger seats depends on the bus model. The system must track the bus make, model, year, seat capacity, vehicle ID, and license plate.
  2. CB operates 10 routes now (e.g., San Francisco-to-Los Angeles), but it can add more routes in the future if its business goes well. Each route specifies a unique route number, departure, destination, departure time, and arrival time.
  3. The system also needs to maintain the drivers’ data, so they can be appointed to drive a route trip on a specific date. A driver’s data must include the first name, last name, date of birth, gender, driver’s license number, license expired date, and hire date.
  4. A route trip captures data about which route, bus, trip date, and trip price. The trip price is dynamic. The company will set the price for a route (e.g., SF to LA on 5/01 at 9 AM) on a specific date and time based on various factors (e.g., supply and demand). For example, the bus route trips on the same route, SF-to-LA, but on different dates may have different prices. Like buying an air ticket for an SF-to-LA flight, you may see a different price when choosing a different date. The trip price determines how much a bus ticket costs if the route trip is related to a bus ticket.
  5. The system needs passengers’ names and emails to deliver e-tickets and receipts when they make a booking (Note: only the passenger who makes the booking).
  6. The system records the booking date and which passenger makes the booking in each booking instance.
  7. Each booking must include at least one bus ticket up to many bus tickets. For example, John can make a booking of three bus tickets for his family.
  8. The system assigns a unique ticket number for each bus ticket and records which booking and route trip are related to it, so the system knows which booking has the ticket and which route trip is assigned to the ticket. With the route trip data related to a bus ticket, the system can retrieve the route, trip date, and trip price and show them on a bus ticket.
  9. For each bus ticket, the system can also record the passenger’s name and his/her special need (e.g., no special need, wheelchair, hearing impaired, sight impaired). These special needs can be predefined in the system and assigned to tickets.
  10. Here are some more essential rules.
    • A bus can be assigned to many route trips, whereas a route trip must have only
    one bus assigned to it
    • A route can be assigned to many route trips, whereas a route trip must have only
    one route. For example, the same SF-LA route (depart at 9 AM) can be used in
    different route trips (5/01, 5/10)
    • A driver can be assigned to many route trips, whereas a route trip can also have
    multiple drivers. It is common to have two drivers who take turns to drive a
    long-distance trip). Hint: an associative entity is needed between a Many-to-
    Many relationship
  11. Visit www.greyhound.com to experience how a ticket booking works, although the
    scope and assumptions of this project are different.
    Tasks
    Based on the background described above, complete the following tasks.
  12. Create an entity-relationship diagram (ERD) that models the CB ticket booking system
    a. Use LucidChart or a similar tool to create the ERD
    b. Use proper notations on the ERD
    a) Entities (each entity must have a name)
    b) Attributes (use the camel style, e.g., PassengerID, RouteTripNum)
    c) Primary keys (use underline)
    d) Relationships with cardinalities
  13. Use your ERD as a blueprint and create a database in Microsoft Access
    a. Create all tables and relationships
  14. Populate some sample data in your database tables
    a. Create at least three passengers
    b. Create at least five bookings
    c. Create at least five bus tickets
    d. Create at least five route trips
    e. Create at least five routes
    f. Create at least three buses
    g. Create at least three drivers

Sample Answer

Compelling correspondence is essential to the achievement all things considered but since of the changing idea of the present working environments, successful correspondence turns out to be more troublesome, and because of the numerous impediments that will permit beneficiaries to acknowledge the plan of the sender It is restricted. Misguided judgments.In spite of the fact that correspondence inside the association is rarely completely open, numerous straightforward arrangements can be executed to advance the effect of these hindrances.

Concerning specific contextual analysis, two significant correspondence standards, correspondence channel determination and commotion are self-evident. This course presents the standards of correspondence, the act of general correspondence, and different speculations to all the more likely comprehend the correspondence exchanges experienced in regular daily existence. The standards and practices that you learn in this course give the premise to additionally learning and correspondence.

This course starts with an outline of the correspondence cycle, the method of reasoning and hypothesis. In resulting modules of the course, we will look at explicit use of relational connections in close to home and expert life. These incorporate relational correspondence, bunch correspondence and dynamic, authoritative correspondence in the work environment or relational correspondence. Rule of Business Communication In request to make correspondence viable, it is important to follow a few rules and standards. Seven of them are fundamental and applicable, and these are clear, finished, brief, obliging, right, thought to be, concrete. These standards are frequently called 7C for business correspondence. The subtleties of these correspondence standards are examined underneath: Politeness Principle: When conveying, we should build up a cordial relationship with every individual who sends data to us.

To be inviting and polite is indistinguishable, and politeness requires an insightful and amicable activity against others. Axioms are notable that gracious “pay of graciousness is the main thing to win everything”. Correspondence staff ought to consistently remember this. The accompanying standards may assist with improving courtesy:Preliminary considering correspondence with family All glad families have the mystery of progress. This achievement originates from a strong establishment of closeness and closeness. Indeed, through private correspondence these cozy family connections become all the more intently. Correspondence is the foundation of different affiliations, building solid partners of obedient devotion, improving family way of life, and assisting with accomplishing satisfaction (Gosche, p. 1). In any case, so as to keep up an amicable relationship, a few families experienced tumultuous encounters. Correspondence in the family is an intricate and alluring marvel. Correspondence between families isn’t restricted to single messages between families or verbal correspondence.

It is a unique cycle that oversees force, closeness and limits, cohesiveness and flexibility of route frameworks, and makes pictures, topics, stories, ceremonies, rules, jobs, making implications, making a feeling of family life An intelligent cycle that makes a model. This model has passed ages. Notwithstanding the view as a family and family automatic framework, one of the greatest exploration establishments in between family correspondence centers around a family correspondence model. Family correspondence model (FCP) hypothesis clarifies why families impart in their own specific manner dependent on one another ‘s psychological direction. Early FCP research established in media research is keen on how families handle broad communications data. Family correspondence was perceived as an exceptional scholastic exploration field by the National Communications Association in 1989. Family correspondence researchers were at first impacted by family research, social brain science, and relational hypothesis, before long built up the hypothesis and began research in a family framework zeroed in on a significant job. Until 2001, the primary issue of the Family Communication Research Journal, Family Communication Magazine, was given. Family correspondence is more than the field of correspondence analysts in the family. Examination on family correspondence is normally done by individuals in brain science, humanism, and family research, to give some examples models. However, as the popular family correspondence researcher Leslie Baxter stated, it is the focal point of this intelligent semantic creation measure making the grant of family correspondence special. In the field of in-home correspondence, correspondence is normally not founded on autonomous messages from one sender to one beneficiary, yet dependent on the dynamic interdependency of data shared among families It is conceptualized. The focal point of this methodology is on the shared trait of semantic development inside family frameworks. As such, producing doesn’t happen in vacuum, however it happens in a wide scope of ages and social exchange.

Standards are rules end up being followed when performing work to agree to a given objective. Hierarchical achievement relies significantly upon compelling correspondence. So as to successfully impart, it is important to follow a few standards and rules. Coming up next are rules to guarantee powerful correspondence: clearness: lucidity of data is a significant guideline of correspondence. For beneficiaries to know the message plainly, the messages ought to be sorted out in a basic language. To guarantee that beneficiaries can without much of a stretch comprehend the importance of the message, the sender needs to impart unmistakably and unhesitatingly so the beneficiary can plainly and unquestionably comprehend the data.>

Our customer support team is here to answer your questions. Ask us anything!