Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Post Please do my homework for me

    i have a case study here :

    Alpha Luxury Holidays is a travel agency and has 50 branches within the United Kingdom, with approximately 200 staff members. Opening hours are from 7.30 am to 10pm Monday to Saturday and 11am to 5pm on Sundays. They specialise in booking luxury holidays in various countries around the world.
    Alpha Luxury Holidays, over the past years, have been using Excel spreadsheets as well as paper based diaries to record holiday bookings. Having encountered many difficulties in customer service, for example, duplicating customer reference numbers, sending the incorrect holiday details and wasting time when trying to cancel or amend a previous booking, they are now intending to create a computerised database for the holiday booking activities as well as to include current staff details and their previous employment history.
    Each branch has a designated manager who has overall responsibility for the branch and the employees in the branch. However, to help manage the branch, an assistant manager supervises the staff. New employees who join the company must inform Alpha Luxury Holidays about their previous work history, for example, the company details and the job details.
    Customers can book their holiday reservations via telephone or by visiting any branch. When booking their reservations, the customer normally would inform the agency staff of the length of stay, inward and outward dates, the city and country they would like to visit, their preferred facilities and the type of resort, as well as the number of passengers. The customer must also inform the member of staff if they are only booking a flight or only accommodation or both. Details of the staff who took the booking must also be recorded.
    Once the holiday reservation is booked, the customer is invoiced for the holiday and must pay the invoice in full, either by cash, credit card, debit card or cheque. However, it is the responsibility of the staff to ensure that the supporting check-cards are correct and will be completed manually and does not need to be recorded in the system. All invoices must be paid at least eight weeks before the departure date.

    how many entities are there? i found five
    after you've found the entity can u help with E-R diagram? need 2 E-R diagram?

    thanks

  2. #2
    Join Date
    Mar 2012
    Posts
    2

    Post Please do my homework for me

    i have a case study here :

    Alpha Luxury Holidays is a travel agency and has 50 branches within the United Kingdom, with approximately 200 staff members. Opening hours are from 7.30 am to 10pm Monday to Saturday and 11am to 5pm on Sundays. They specialise in booking luxury holidays in various countries around the world.
    Alpha Luxury Holidays, over the past years, have been using Excel spreadsheets as well as paper based diaries to record holiday bookings. Having encountered many difficulties in customer service, for example, duplicating customer reference numbers, sending the incorrect holiday details and wasting time when trying to cancel or amend a previous booking, they are now intending to create a computerised database for the holiday booking activities as well as to include current staff details and their previous employment history.
    Each branch has a designated manager who has overall responsibility for the branch and the employees in the branch. However, to help manage the branch, an assistant manager supervises the staff. New employees who join the company must inform Alpha Luxury Holidays about their previous work history, for example, the company details and the job details.
    Customers can book their holiday reservations via telephone or by visiting any branch. When booking their reservations, the customer normally would inform the agency staff of the length of stay, inward and outward dates, the city and country they would like to visit, their preferred facilities and the type of resort, as well as the number of passengers. The customer must also inform the member of staff if they are only booking a flight or only accommodation or both. Details of the staff who took the booking must also be recorded.
    Once the holiday reservation is booked, the customer is invoiced for the holiday and must pay the invoice in full, either by cash, credit card, debit card or cheque. However, it is the responsibility of the staff to ensure that the supporting check-cards are correct and will be completed manually and does not need to be recorded in the system. All invoices must be paid at least eight weeks before the departure date.

    how many entities are there? i found five
    after you've found the entity can u help with E-R diagram? need 2 E-R diagram?

    thanks

  3. #3
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253

    Lightbulb

    Main data table:
    BRANCHES
    EMPLOYEES
    EMPLOYEE WORK HISTORY (EMP_WORK_HIST)
    CUSTOMERS
    RESERVATIONS

    Lookup tables:
    COUNTRIES
    CITIES
    FACILITIES
    RESORT_TYPES

    This is probably the simplest implementation. In practice, you may find that the "reservation" is more like an "order" and the flight and hotel (or any other additional requirements that may come later) are more like order items. For the simplistic "spec" given, you could fulfill the requirements using a single RESERVATIONS entity. No mention is given to the level of detail about the flight or accommodation. You would likely require more entities below RESERVATIONS to detail the flight and accommodation.

    In real life, I would use ORDERS/ORDER_ITEMS instead of RESERVATIONS. I think that it would cater better for expansion of the business offering which must inevitably come in the future (business always changes and adapts, make sure your software can too). I would then have FLIGHT_DETAILS/ACCOMODATION_DETAILS entities joining to the ORDER_ITEMS.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    I've combined your two message threads from the Adabas and Oracle forums into a single thread in the Database Design and Concepts Forum.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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