FIT9132 Introduction to DatabasesDatabase Design代写 Monash Cabins is a chain of resorts (holiday destinations) located around Australia. At each of these resorts, MC provides2018 Semester 2Assignment 1 Database Design Monash Cabins (MC)Database Design代写Monash Cabins is a chain of resorts (holiday destinations) located around Australia. At each of these resorts, MC provides cabin-based accommodation for its guests – any given resort consists of several independent cabins. A resort is located in a particular town. MC maintain details of points of interest (POI) in the local area that guests might wish to visit. Each POI is associated with only one town.For each town in which a resort or point of interest is located MC records the town name, the state the town is located in, the latitude and longitude of the centre of the town, the average summer and winter day temperatures, the town s elevation above sea level and its population. MC only records details of towns which have a resort or point of interest. MC does not record a town s postcode since they are only interested in it as a location, not as a postal location.Database Design代写For points of interest MC records the street and town in which it is located, the name of the point of interest (eg. Merimbula Aquarium), a brief description of the point of interest, its opening hours (if appropriate), and the type of point of interest (café, museum, restaurant, national park etc). The opening hours are recorded as the time at which the POI opens and the time at which it closes, only one set of these times are recorded (ie the POI is assumed to open and close at the same time all year). Each POI is only classified as one type of point of interest, for example, a cafe in a national park will be classified as a cafe. A scan of the potential MC data has indicated that some towns contain two POIs of the same name.Each resort is assigned a unique resort id.Database Design代写MC has several resorts in some towns and only a single resort in others depending on the location s popularity. Each resort has a name (eg. Merimbula Beach Cabins). A resort s street address and town name are recorded. MC also records for each resort the star rating of the resort, which is determined from the average of all guest reviews, whether guests may bring their pet dog/s while staying at the resort and if the resort manager lives at the resort.Each resort has a single manager. MC assigns a manager id to each manager and records the manager s name, postal address (including town and postcode) and the manager s contact phone number. Some managers live on site (ie. at the resort); others live at their own private residence, however, MC does not need to record the manager s residential address, only their postal address. Where a location has several resorts, a manager may manage several different resorts.Database Design代写Each resort consists of a number of cabins – the cabins are numbered starting from cabin 1 at each resort. MC records how many bedrooms there are in each cabin, the sleeping capacity of the cabin (how many people it can sleep) and a description of the cabin to provide potential guests with some details to assist their decision making.MC guests, those staying at the resorts,are assigned a unique guest number when they first register with MC. The guest name, postal address, country, email and contact phone number are recorded. A guest makes a booking with MC by choosing the resort they wish to stay at and the cabin they wish to stay in. Guests are required to provide the date they wish to book from and the date they wish to stay to. They must also supply MC with the number of adults, the number of children and the number of pets (if applicable) who will be staying. MC record the total charge for the particular booking, based on the cabin rate and the number of days of the guests stay.Database Design代写Guests are offered the opportunity to provide a review of the resort they are not required to do so, but if they do, they provide a comment and a rating from 1 (poor) to 5 (outstanding). These reviews are treated as general reviews of the resort rather than being related to a particular cabin or stay. A guest may complete many reviews of a particular resort during their stay. The review may also be made after the guest has left the resort. The date of the review is recorded (a guest is not permitted to complete two reviews on the same day).The rates charged for a cabin depend on the cabin itself(some cabins have special features such as a spa) and the time of the year in which the guest is staying. For example, for seaside resorts, the highest rates are charged in the peak summer period (eg. Jan – Feb) when demand is at its highest. The rate for each cabin is recorded for each of these charge periods – rate periods may vary between different locations. Where a booking spans several rate periods, the booking is charged at the rate which applies on the first day of the booking.When a guest vacates a cabin, MC use contract cleaners to clean the cabin. MC maintain a running sheet, for each resort, to record cleaning activity (a small sample of this is shown below):Document AA cleaning contractor is assigned a unique contractor number when first taking up work with MC.Contract cleaners may work as casual staff or fixed term staff. Fixed-term staff sign a contract to clean for a set period of time such as three or six months. Casual cleaners are not locked into any fixed period to clean, they are available on a weekly basis as work is available or suits them.Database Design代写Casual cleaners are contacted when work is available to clean a particular cabin and may accept or reject the job. Contract cleaners may shift between these two modes depending on what suits them better.MC maintain a record of the contract history for all cleaners ( a small sample of this record is shown below):Database Design代写Documents B and CTASKSPlease ENSURE your name and ID are shown on every page of any document you submit. If a document is a multipage document, such as for the normalisation, please also make sure you include page numbers on every page.Moodle Part A Submission:Using LucidChart, prepare an INITIAL conceptual model (Entity Relationship Diagram) for Monash Cabins(MC).For this initial conceptual model, include what you see as identifiers (keys) for each entity only (other attributes are not required) and allSurrogate keys must not be added to this model. Participation and connectivity for all relationships must be shown on thediagram.Database Design代写

所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。