10 Jul database Conceptual Design: ER Modeling
Question Description
Deliverable: Draw an Entity-Relationship Diagram using ER-Assistant or equivalent software. The deliverable is a complete ER model for the following scenario.
The ER diagram must include the necessary entity classes and all attributes specified in the description.
Identifiers for all entity classes must be shown clearly.
Relationships must be named, with cardinalities clearly shown.
Identifying relationship must be shown clearly
Document any assumption you have to make in a word document.
UPLOAD a zip file INCLUDING THE ER MODEL AND THE ASSUMPSTION (a separate word document) to Canvas, Assignment 1. All entity class names and attribute names should start with your initials.
Case Description
Embassy International wants to develop an application that will keep track of their customer comments and any follow-up action that has taken place on the comments received.
Customers are identified by their Honors Card number, a 9 character number given to each customer whether they join the loyalty program or not. Customer information includes name and address, email address, home phone number, cell number, and company name/phone number (if available). The system records each stay the customer makes in an Embassy International hotel, they have about 200 properties throughout the world. Information stored on each location includes country, city and state (in US), number of rooms, whether there is a health club, and whether there is a restaurant.
Each customer is asked to complete a customer satisfaction survey with has five questions with responses from 0 to 7 and a general comment area. The survey includes the customer number, the hotel location, and the start and end date of the stay.
The follow-up information to be collected includes the date of contact, the name of the person who made the comment, the property involved, the type of contact (email, direct mail, phone), whether a coupon was offered and, if so, it’s monetary value, and the date of response. There may be multiple contacts with the same customer over the same property.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.