CSE2/4DBF (2016) – Assignment 1, Part 1 Page 1/7 ______________________________________________________________________________________ CSE2DBF and CSE4DBF 2016 Assignment 1 – Part 1 (7.5%) Due date: 10.00am Thursday, April 7th 2016 AIMS AND OBJECTIVES: ? to represent a problem description given in natural language as an (Enhanced) EntityRelationship model This is an individual Assignment. You are not permitted to work as a group when writing this assignment. Copying, Plagiarism: Plagiarism is the submission of somebody else’s work in a manner that gives the impression that the work is your own. The Department of Computer Science and Information Technology treats plagiarism very seriously. When it is detected, penalties are strictly imposed. No extensions will be given: Penalties are applied to late assignments (5% of total assignment mark given is deducted per day, accepted up to 5 days after the due date only). If there are circumstances that prevent the assignment being submitted on time, an application for special consideration may be made. See Student Handbook for details. Note that delays caused by computer downtime cannot be accepted as a valid reason for a late submission without penalty. Students must plan their work to allow for both scheduled and unscheduled downtime. SUBMISSION GUIDELINES: This assignment is to be submitted in hard-copy format to the relevant submission box on the first floor of the Beth Gleeson Building by 10:00 am Thursday April 7th, 2016. SUBMISSION CHECKLIST: ? Your (Enhanced) Entity-Relationship Model (EER) for the proposed database Students are referred to the Department of Computer Science and Information Technology’s Handbook and policy documents with regard to plagiarism and assignment return, and also to the section of ‘Academic Integrity’ on the subject learning guide. CSE2/4DBF (2016) – Assignment 1, Part 1 Page 2/7 ______________________________________________________________________________________ PROBLEM DESCRIPTION: Getaway Holidays Reservation Database System Getaway Holiday Destination is a family owned holiday resort specially designed for group visits or couples retreat. The business was established in 1990’s by an Australian adventurist and travel enthusiast Mr. Edward Green. The Green family has been taking care of the business ever since. They have a dedication and passion towards what they have to offer to their guests and in order to do that, each and every member of the family work towards the maintenance and continuing improvement of the establishment. The business is mainly aimed at the concept of providing the guests with actual adventures along with a great experience of a family getaway. The resort is situated in the middle of a huge land with natural diversities. It has a great country-side river and some gorgeous hills, not very far from the city of Melbourne. The guests of the resort register with the business in order to put their reservation ahead of time as the demand is always high during the holiday seasons. As the registration and reservation process is maintained in paper-based format till date, the customers have to physically come down to the location and fill up a Client Registration Form provided in Appendix-A. As it can be seen from the registration form, the basic information about a client is kept on record so that they do not have to register again for any future trip they wish to book with the resort. As the resort provides different indoor and outdoor activities for the duration of the stay, they are also concerned about the physical fitness of their clients. Any condition that a client may have can restrict the client from booking a trip with some of the activities. For example, a person with Acrophobia (the fear of height) should not be allowed to book a trip that contains mountaineering outdoor activity. The registered clients are targeted and sent different package offers and brochures highlighting the activities that the resort facilitates. A sample brochure is provided in Appendix-C for outdoor activities and a similar brochure for indoor activities is provided in Appendix-D. After being registered, a client can book a package trip with his/her friends and family by completing the Client Reservation Form (Appendix-B). All the information in the form helps the resort to plan and execute a perfect holiday trip for their individual clients. The preferences of the clients are the first priority to them. Some of the questions that need to be answered in this form include what kind of accommodation they are looking for, how many guests they will be bringing along, what are the indoor and outdoor activities they will be looking forward to. This information will help the resort officials to make a decision and plan an entire trip. The resort has four different types of accommodation namely the deluxe cottage (suitable for a group of 4-5 people), the honeymoon cottage (suitable for newly married couples), the deluxe accommodation with a double bed and finally the deluxe accommodation with a single bed. Each of the room in the resort belongs to one of the accommodation types. The rooms have unique room numbers and the floor level. Also, there are connected rooms on each floor so that a group of friends can reserve two adjacent rooms when the deluxe cottage is not available. However, for security purposes, currently the room has only maximum of one adjacent room. Each of the accommodation types has a fixed daily rate which has to be paid by the client upfront along with the payment for activities. The daily rate of a deluxe cottage is $120, the daily rate of honeymoon cottage is $100, and the daily rate for the double and single bed deluxe accommodation is $75 and $55 respectively. The resort does not allow a client to pay part of the expenses upfront and the rest of the money upon arrival, which makes the payment system a bit simple and straight forward. CSE2/4DBF (2016) – Assignment 1, Part 1 Page 3/7 ______________________________________________________________________________________ Focusing on the client preferences of activities, they are offered a group of indoor and outdoor activities and the activities are properly planed for a specific day of the stay and on a specific time so that the client can plan their free times with friends and family. The resort has many outdoor instructors, masseuse and swimming instructors who work on a part time basis. For the outdoor instructors along with the basic contact information, their fields of expertise are recorded. For the masseuse, their single qualification area (i.e. Thai massage, Therapeutic massage) is recorded. The outdoor instructors, masseuse and swimming instructors have their own unique ids and are maintained separately as they are overseen by different administrative team. Only a few of them are assigned a role of an Activity Supervisor who is in-charge of an indoor or outdoor activity for a specific time on a specific day. The Activity Supervisor is responsible for the safety of the guests. At least one activity supervisor is assigned for each activity on a specific day of a trip. There are some discount schemes available for the clients who bring more business to the resort in order to increase their level of satisfaction. If a client books a second trip in the same year, he/she is offered a discount of 10% on the overall price of the second trip. Then again, if a client books more than two outdoor activities in the same trip, they are offered a 15% discount on the price of the outdoor activities combined. Also, if the length of a trip exceeds 5 days, the client is offered a 5% discount on the overall stay. The business owns a lot of equipment for these outdoor activities and they also maintain some of the information about this equipment and their suppliers. At present they have about 100 sets of mountaineering gears, 15 rafting boats, 10 sets of bungee jumping ropes and safety gears, about 5 large air balloons and so on. They arrange inspection of these equipment on a regular basis and based on the report on their condition they order for new ones to be built and delivered by the suppliers. As for the suppliers, their business name, contact person details, contact number and biller code are recorded for administrative purposes. Information about the activities are kept in the records as well. These include the name of the activity, their description, risk level and cost per day. Also, there are some information which are specific for indoor activities which are mentioned in the brochure. It is to be mentioned that the activities in the brochure in appendix C and D are sample set of activities only. The resort offers a much bigger range of activities to the clients. The business is growing day by day and the family is facing difficulty keeping record of all this information in physical files. So, Mr. Green has decided to migrate all the kept information into a Database management system so that online form submission facilities can be provided to the clients. TASKS: You are required to develop an EER model for the above problem description. The EER should contain all necessary information such as entities, attributes, primary keys, relationships (including specialization/generalization if any), cardinalities, and participation (including (min, max)). All specialization/generalization and union type must be represented accordingly, instead being treated as simple association relationships. Any assumptions should also be stated clearly. If assumptions are made, it is important to make sure that the assumptions reflect possible real practice for a tourism industry and do not contradict with the problem description above. Assignment should be typed, not written/drawn by hand. Use CASE tool or any software to draw figures in your assignment. [100%] CSE2/4DBF (2016) – Assignment 1, Part 1 Page 4/7 ______________________________________________________________________________________ Appendix-A: ‘Client Registration’ Form Getaway Holidays Client Registration Form CLIENT INFORMATION Name: M/F: Address: City: State: Postcode.: D.O.B: Contact Number: ( ) Email: Occupation: …………………………………………………………………………………………………………………………. Marital status: ………………………………………………………. Spouse: ………………………………. Anniversary: …………………………………………………………………………………………………… Please check the boxes below for the health conditions you might have: Blood pressure Heart condition Acrophobia (Fear of height) Aqua Phobia (Fear of water) Photophobia (Sensitive to sunlight) Hypersensitivity to Chlorine water Client’s Signature: Date: Agent’s Signature: Date: CSE2/4DBF (2016) – Assignment 1, Part 1 Page 5/7 ______________________________________________________________________________________ Appendix-B: ‘Client Reservation’ Form Getaway Holidays Client Reservation Form Client No: Reservation No: Client Name: No of Guests: Reservation Date: ………………………………………………….. Trip Duration: ………………………… Start Date: ………………………………………………………….. End Date: Please select the activities you would like to take part in: Indoor: Swimming Sauna Spa Outdoor: Ballooning Mountaineering Bungee Jumping Rafting Fishing Please select the type of accommodation: Deluxe Cottage Honeymoon Cottage Deluxe Single Deluxe Double No of rooms required: Connecting Rooms?: YES NO Client’s Signature: Date: Agent’s Signature: Date: CSE2/4DBF (2016) – Assignment 1, Part 1 Page 6/7 ______________________________________________________________________________________ Appendix-C: ‘Brochure (Outdoor activities) Getaway Holidays Outdoor Activities Hot Air Balloon Ride: Take a ride above the horizon to discover the scenic beauty from a unique angle nothing else can provide. Price: AUD 200/= per person (1 hour ride along the mountain line) Risk level: Medium Mountaineering: Take the challenge to overcome a mountain and stand at the top to get the ultimate adventure. Price: AUD 300/= per person (2 days’ activity including the training) Risk level: High Bungee Jumping: Face the fear and let go. Price: AUD 100/= per person Risk level: High Rafting: Head towards the strong tide and beat the pressure to get a feeling of refreshing achievement. Price: AUD 350/= per person (2 days’ activity including the training) Risk level: Medium Fishing: If you like the challenge of mind game and patience, this is the perfect sport for you. Price: AUD 50/= per person (For the whole day) Risk level: Low CSE2/4DBF (2016) – Assignment 1, Part 1 Page 7/7 ______________________________________________________________________________________ Appendix-D: ‘Brochure (Indoor activities): Getaway Holidays Indoor Activities Swimming: Exercise in style in our heated swimming pool with a range of diving boards and different water depths. Price: AUD 25/= per person (2 hours) Risk level: Medium Location: Level 1, Indoor swimming pool Opening hours: 7:00 A.M – Midnight Sauna: Refresh yourself for an hour of the traditional Finnish bath. Price: AUD 50/= per person Risk level: Low Location: Level 2 terrace, Sauna room. Opening hours: 9:00 A.M – Midnight Spa: Take the advantage of a world class experience of pampering and relaxation. Price: AUD 100/= per person Risk level: Low Location: Level 2 terrace, Spa parlor. Opening hours: 8:00 A.M – 10:00 PM

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center. 

Instructors, training on how to grade is within the Instructor Center.

Assignment 2: Analyzing a Major Issue

Due Week 8 and worth 260 points

Before starting the paper:

• Review the major concepts of social psychology in the textbook.
• Select a topic from the list.
• • Affirmative Action (may focus on affirmative action for racial or minorities, gender, or sexual orientation)
  • Bullying (may focus on school bullying or cyberbullying)
  • Violence in the media
  • Development and influence of gangs
  • Hate crimes against gays or other minorities
  • Domestic violence (may focus on married couples or dating couples)
• Locate and read at least three (3) peer reviewed articles on the issuein the Strayer Library.
• • At least one (1) article should discuss the historical event(s) or legal decision(s) that make the issue a major one in the United States.
  • Two (2) of the articles should have different views about causes, effects, and ways to address the issue.

Write a five to seven (5-7) page paper (1,000 to 1,200 words) in which you:

1. Provide an introduction to the paper with a thesis statement.
2. Describe at least three (3) key historical events and / or legal decisions that make the issue a major or important one in the U.S.
3. Discuss at least three (3) social psychology concepts addressed in the course that are related to the issue.
4. Analyze at least three (3) challenges individuals and law enforcement agencies face with the issue.
5. Explain your agreement with at least three (3) statements by authors of the references cited.
6. Explain your disagreement with at least two (2) statements by authors of the references cited.
7. Recommend at least two (2) ways that individuals should address the issue to help improve social elements involved in the issue.
8. Suggest at least two (2) ways those in criminal justice (police officers, prosecuting attorneys, and  / or judges) should address the issue.
9. Provide a conclusion to the paper that includes a reference to the thesis statement and contains a summary of the main points.
10. Provide at least three (3) external peer-reviewed references to support your paper.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length or word count.

The specific course learning outcomes associated with this assignment are:

• Describe the major theories within the field of social psychology.
• Develop an increased understanding of the dynamic between society and individuals.
• Use technology and information resources to research issues in social psychology.
• Write clearly and concisely about social psychology using proper grammar and mechanics.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1. You have agreed to loan a friend $5000 for 5 years at asimple interest rate of 8% per year. How much interest will youreceive from the loan? 2. To raise money for a new business, a friend asks you to loanher some money. She offers to pay you $3000 at the end of 4 years.How much should you give her now if you want to earn 12% interestper year on your money? . . .

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

CASE 10-29 EVALUATING A COMPANY’S BUDGET PROCEDURES1. Identify the problems that appear to exist in Ferguson & Son Manufacturing Company’s budgetary control system and explain how the problems are likely to reduce the effectiveness of the system.2. Explain how Ferguson & Son Manufacturing Company’s budgetary control system could be revised to improve its effectiveness.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"