fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

4 Pages
COMP2750 Applications Modelling and Development

Task:  Task Descriptions   Your tasks in this assignment are as follows:Task 1: UI Process Flow DiagramYou are required to design screens using a wireframing technique. Use the use ...

Course

comp 2750

Type

Programming

Subject

Database

University

Macquarie University

11 Pages
NIT6160- Data Warehousing and Mining

Task Objective In this assignment, we are building a data warehouse for an online brokerage company. The company makes money by charging commissions when customers buy and sell stocks. We are planni ...

Course

NIT6160

Type

Programming

Subject

Database

University

Federation University

5 Pages
BISY2003 Object Oriented Programming

Task: Requirements:1. Create a Use Case with detail descriptions for the new Online Medical System.2. Create a Domain Model for the online Medical System.3. Create a Sequence Diagram for the use ca ...

Course

BISY2003

Type

Programming

Subject

Database

University

Australian Institute of Higher Education

5 Pages
Investment Analysis

Task Task 1  Load the Ionosphere.arff dataset in Weka to perform rule classification using the following methods  JRip  Ridor For each method produce a summary of the rules produce ...

Type

Programming

Subject

Database

COIT20247-Database Design and Development

Question

Answered

Case Study: CQ Grand Motels database system

Central Queensland Grand Motels (CQGM) are a group of chain-branded motels, distributed in the towns of central Queensland region such as Rockhampton, Gladstone and Mackay etc. Each motel in the group is also referred to as a branch, providing accommodations and amenities for customers. The management of CQGM has invited you to build a relational database that will be used as the critical backend software component in their enterprise management system so that the relevant business data will be recorded appropriately and further information query will be processed efficiently. The major requirements of the proposed database system should maintain correct records on information such as branches, staff, customers, rooms, booking, room maintenance as well as advertising activities. Consider the following user requirements carefully and design a database conceptual schema (i.e. E-R model) to support such an application.

The data stored on each branch (i.e. a motel at a specific location) include the branch address, telephone number, a branch name and an identification number. Each branch hires a few administrative staff and has a local manager. Besides, each branch usually outsources the room maintenance job to the external staff. The data required on members of staff include a staff identification number, first name, last name, sex, date of birth. Each motel may own up to one hundred rooms available for accommodations. The data on each room includes a room identification number, the maximum number of people that the room can hold, the number of beds in the room, as well as the room type, which can be categorized as standard room, superior room, deluxe room and deluxe executive suite, with the different price per night for a different type. The information about room type and price should be held in a small lookup table  

The system will keep track of customer information, which includes a customer identification number, first name, last name, address, mobile phone number, date of birth (optional) and driver’s license number. The customer identification number should be a unique number allocated automatically by the system. When a prospective customer books a room, the details on his or her booking should include a booking ID, start date and end date, the room type, the number of people required and total charge.

From time to time, any room of a branch may need some maintenance service or minor repair job (for example replacement of window glass, repair of toilet water leaking etc.). The motel has contracted the maintenance task to the qualified external staff, referred to as a contractor (whose valid trade license number is an essential data stored in the system). The details on the maintenance or repair job must be recorded with the room identification number, labor cost, material cost, completion date and an additional comment concerning the job description.

Every year there are several times of promotion activities when each motel may advertise in the local or state-wide newspapers. The advertised dates, cost, as well as the name of newspapers must be recorded. The data stored on each newspaper includes the newspaper name, address, telephone number, and the contact person name

The specification of above application scenario may not be presented explicitly with every detail on the entities or relationships in the required E-R model, because one of your tasks for this assignment is to analyze the requirement of users, identify necessary entities and relationships, and build the E-R data model for the case study. You may need to do some research on the data and possible model in general motel or hotel management with complete attributes or under some assumptions, which should make sense for such an application scenario.

Assignmentt Requirements

In this assignment, you need to create an Entity Relationship (ER) diagram relevant to the above case study and optionally perform logical design to produce appropriate 3NF Relations. The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.

COIT20247-Database Design and Development

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

18 More Pages to Come in This Document. Get access to the complete answer.

Looking for corporate assignment help? Then MyAssignmenthelp.com is your one-stop answer. We render custom-made assistance with corporate as well as with IT assignment. We are available 24*7 to offer operating system, database, MATLAB, web development and lots of other IT subject based assignment help. We work round the clock to ensure 100% students satisfaction with our delivered service and to make sure that students get assistance on urgent basis.

More COIT20247 COIT20247-Database Design and Development : Questions & Answers

Q
icon

We aren't endorsed by this University

COMP2750 Applications Modelling and Development

Task:  Task Descriptions   Your tasks in this assignment are as follows:Task 1: UI Process Flow DiagramYou are required to design screens using a wireframing technique. Use the use case provided above for creating the UI Process Flow (Navigation) diagram using wireframes. You can ...

View Answer
Q
icon

We aren't endorsed by this University

NIT6160- Data Warehousing and Mining

Task Objective In this assignment, we are building a data warehouse for an online brokerage company. The company makes money by charging commissions when customers buy and sell stocks. We are planning to have a Trades fact table with the grain of one row per stock trade. We will use the following ...

View Answer
Q
icon

We aren't endorsed by this University

BISY2003 Object Oriented Programming

Task: Requirements:1. Create a Use Case with detail descriptions for the new Online Medical System.2. Create a Domain Model for the online Medical System.3. Create a Sequence Diagram for the use case Book for an appointment of the Online Medical System.4. Create a Class Diagram for Online Medical ...

View Answer
Q

Investment Analysis

Task Task 1  Load the Ionosphere.arff dataset in Weka to perform rule classification using the following methods  JRip  Ridor For each method produce a summary of the rules produced and comment on their accuracy using performance metrics used in Weka.  Task 2 Load the Vote ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Graham Buchanan

PhD in Pharmacy

1638 - Completed Orders

Hire Me
student rating student rating student rating student rating student rating
Sam White

Chemistry Champion

1313 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Albert Stevenson

I have completed my PhD in Literature from the University of Birmingham

110 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Michael Chua

PhD in Biology with Specialization in Genetics

749 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
24 Jan 2022

Maths

Home Work: 1 Page, Deadline: 5 days

I just want to thank the person who worked on this assignment, and let them know that I appreciate the care and detail they did on this assignment. I ...

flag User ID: 4***77 United States

student rating student rating student rating student rating student rating
24 Jan 2022

Assignment

Home Work: 6 Pages, Deadline: 9 days

well written assignment, thank you for the help. it is very helpful and written to top standard

flag User ID: 7***74 Australia

student rating student rating student rating student rating student rating
24 Jan 2022

Management

Essay: 4 Pages, Deadline: 9 days

Good job, I am happy with the amazing services and completed work given that meet the requirement asked. Thank you very much for helping me receive a ...

flag User ID: 2***91 Kuala Lumpur, Malaysia

student rating student rating student rating student rating student rating
24 Jan 2022

Management

Assignment: 4 Pages, Deadline: 12 days

Good job, I am happy with the amazing services and completed work given. Thank you very much for helping me receive a good mark. Will definitely work ...

flag User ID: 2***91 Kuala Lumpur, Malaysia

student rating student rating student rating student rating student rating
23 Jan 2022

English

Home Work: 2 Pages, Deadline: 11 hours

I got a good mark and I am happy with the results of the work. I would definitely recommend

flag User ID: 7***20 Kuala Lumpur, Canada

student rating student rating student rating student rating student rating
23 Jan 2022

Statistics

Programming: 4 Pages, Deadline: 9 days

Plenty of work, well expanded and explained with graphs and tables. Satisfied with the work done

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
23 Jan 2022

Operations

Assignment: 3 Pages, Deadline: 5 days

the works are relevant and correct gramma. with proper research as evidence and correct situation and circumstances

flag User ID: 5***21 United Kingdom, Canada

student rating student rating student rating student rating student rating
23 Jan 2022

Nursing

Assignment: 0 Pages, Deadline: 5 days

The expert did his/her job well. I will always submit more assignments and recommend friends to the site because I am really impressed with the job. t ...

flag User ID: 8***32 United Kingdom, United States

student rating student rating student rating student rating student rating
23 Jan 2022

Physics

Programming: 1 Page, Deadline: 5 hours

very good service with excellent turnover time to assist my assignment. Definitely recommend this service

flag User ID: 7***81 Perth, Australia

student rating student rating student rating student rating student rating
23 Jan 2022

Chemistry

Home Work: 0 Pages, Deadline: 1 day

GREAT!!! Outstanding performance and very well scored. I received plenty of help and guidance and knowledge.

flag User ID: 8***17 Perth, United States

student rating student rating student rating student rating student rating
23 Jan 2022

Programing

Programming: 4 Pages, Deadline: 9 hours

Python assignment was due in under 24hrs, order was delivered in a timely manner with thoroughly completed tasks

flag User ID: 7***52 Perth, Singapore

student rating student rating student rating student rating student rating
23 Jan 2022

Finance

Home Work: 2 Pages, Deadline: 5 days

Thank you very much for doing an extraordinary job! The graph was beautiful, and I appreciate you adding the graph and the document was written with c ...

flag User ID: 8***35 Saint Louis, United States

student rating student rating student rating student rating student rating
22 Jan 2022

Economics

Assignment: 3.2 Pages, Deadline: 6 days

I was very delighted with the work but please your method of payment should be educated and more steps should be taking

flag User ID: 3***17 Saint Louis, Ghana

student rating student rating student rating student rating student rating
22 Jan 2022

It Write Up

Programming: 12 Pages, Deadline: 11 days

Good work , Thanks for your fast response , just please next time take care of the citation , because it was wrong.

flag User ID: 2***73 Muscat, Oman

student rating student rating student rating student rating student rating
22 Jan 2022

Physics

Home Work: 1 Page, Deadline: 7 days

The expert delivered on time, and even before the due date! Really great results!

flag User ID: 6***06 Atlanta, United States

student rating student rating student rating student rating student rating
22 Jan 2022

Physics

Home Work: 1 Page, Deadline: 7 days

Did a really great job again! Multiple assignments have been completely in a true expert fashion.

flag User ID: 6***06 Atlanta, United States

student rating student rating student rating student rating student rating
22 Jan 2022

Networking

Programming: 40 Pages, Deadline: 14 days

The work was done on time. I am pretty happy with the work has been done. Excellent service

flag User ID: 1***91 City Of Sydney, Australia

student rating student rating student rating student rating student rating
22 Jan 2022

It Write Up

Assignment: 8 Pages, Deadline: 9 days

Thanks for the instant revise my requirementsyou changed and now i will get a good marks

flag User ID: 5***15 Leichhardt, Australia

student rating student rating student rating student rating student rating
22 Jan 2022

Maths

Home Work: 1 Page, Deadline: 2 days

the assignment has been completed on time. Very reasonable price and quality work.

flag User ID: 7***81 Perth, Australia

student rating student rating student rating student rating student rating
22 Jan 2022

Finance

Assignment: 6 Pages, Deadline: 9 days

wow i cant believe the grade i got its the best thing ever I for sure will be back with you guys again because this is the best service ever thank you ...

flag User ID: 3***37 Dubai, United Arab Emirates

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?