1.This is a step-by-step development process. It is not advisable to skip ahead.

2. Review the provided business case below. Identify entities, attributes, relationships, constraints and list out the business rules evident from it. If you analyze it thoroughly enough, you should have questions to your professor to add clarification.

3. Based on the case and its business rules, create a data-flow diagram showing processes and its flow of data between external entities to illustrate the flow of data throughout the organization. Make sure to add data stores in it. Share your draft work with your professor to ensure you arent doing anything really weird.

4. Based on everything youve done in the first 3-steps, take the final step of creating a simple entity-relationship diagram to illustrate the entities, attributes and their relationships to one another. Do mark primary keys and foreign keys.

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.

THE PROMPTS ------------------------------------------

1x MS Word - List of Business Rules 10 marks.

Based on the business case provided, provide a well-organized list of business rules you have identified that you will be using to complete the diagrams in this assignment.

1x MS Visio - Contextual Data-Flow Diagram 30 marks.

Create a contextual data-flow diagram that accurately records and conveys the flow of data throughout the provided business case.

Use written and/or spoken words to describe your diagrams to the audience so that they will understand the details meant to be recorded and conveyed by them, as well as your approach to developing them.

1x MS Visio - Entity-Relationship Diagram 45 marks.

Identify all necessary entities (including any associative) with their relevant attributes and relate them effectively using Crows Foot notation to depict connectivity. In addition to connectivity, ensure you have indicated appropriate cardinalities based on the business rules.

Use written and/or spoken words to describe your diagrams to the audience so that they will understand the details meant to be recorded and conveyed by them, as well as your approach to developing them.