Create a simple entity-relationship diagram to illustrate the entities, attributes, and their relationships to one another. Do mark primary keys and foreign keys

(This is urgent, please)

Bills Travel Service

Bills Travel Service (BTS) books discounted spring break trips for students. During summer and fall Bill contacts various resorts who are interested in hosting students. The resort indicates the number of rooms, each rooms capacity, and room rates for each different week that students are on break. Keep in mind that not all colleges & universities have the same week off, so for the actual resort (and BTS) spring break is normally 4-6 weeks in length.

Each resort offers bookings for a different number of weeks, and rooms have different rates depending on the week. A variety of room types and capacities are usually available at each resort. So, for example, a resort might offer rooms with a capacity of 2 guests for $75/day one week and $85/day the next. Capacity is a minimum of two, but there is no real maximum (for example a ski chalet).

During November & December BTS creates lists of resorts, rooms, capacities and room rates showing each week the resort / room is available. This list is distributed to a wide variety of colleges and universities. BTS then opens the phone lines and takes bookings. Only phone orders are accepted. BTS keeps track of what is being booked and for when, and send confirmations (regular mail or email, students choice) for what has been booked. Updated lists are sent to the campuses weekly. When the cutoff date for booking arrives, normally about a week before Break Week Starts, BTS creates a list for the resort of who has booked, which type of room they were assigned, dates, prices, etc. This list basically becomes the Check-In list for the resort of who they are expecting.

When the student arrives at the resort they pay the resort directly. The resort sends commission cheques to BTS, which is fed into the BTS Accounting System. Accounting is a completely separate system from the Room Booking system and is not what you are developing in this assignment. Similarly, you should not concern yourself with human resources concerns (ie. staffing, positions, payroll).

When break week is over students leave the resort and get back to classes to work on fun things like systems development assignments.

BTS is looking for ways to improve their processes and managing of data, starting by digitizing the flow of data into a database system.