Free Samples
ISY1002 Database Management For Business
.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}
ISY1002 Database Management For Business
0 Download3 Pages / 650 Words
Course Code: ISY1002
University: University Of The Fraser Valley
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Canada
Question:
Using MySQL, you are required to develop a demonstration prototype system that handles hotel bookings and payments. Use MySQL to create a new database called HMS. Create tables according to your ERD. Follow a standard naming convention for table names and also field names. Avoid using spaces and any special characters in table and also field names. Use underscore_case or use camelCase to separate parts of a name.
Create relationships between tables and enforce the referential integrity as shown below.
Relationships:
Guests can have one or more bookings.
Each room booking can have numerous service charges associated with it.
Each room is classified by room type, such as deluxe, suite, or twinshare.
Each room is also provisioned with various facilities such as TV, spa, etc.
Each guest record may require one or more notes so as to keep a history of information related to the guest record.
Notes may be assigned to a particular staff person (or database user) to follow up.
Each room booking may have one or many payments and each payment is identified as to the payment method.
The database should include suitable validation and integrity checks as well as appropriate referential integrity checks. That is, AS A MINIMUM, your system should ensure that the following events cannot occur:
Referential Integrity Constraints:
A booking record cannot be entered for a guest that does not exist.
A guest cannot be deleted for which a reservation or a booking has been recorded. Similarly a guest cannot be deleted once notes have been entered for the guest record. Likewise, staff (users) cannot be deleted once staff persons have been assigned to follow up a note.
A booking cannot be deleted once the booking has a service charge or payment details associated with it. Similarly a service type cannot be deleted once the service type has been entered against any service charge detail record for a guest booking.
Only service types that have been entered into the service types table may be entered as charges for service charge details.
Rooms cannot be deleted once rooms have been assigned to a guest room booking record.
Payment methods cannot be deleted once payment methods have been recorded against payments and room bookings that have matching payment details cannot be deleted once payment records have been entered.
Save the data in the Excel file provided in a CSV file format and import the data into your tables in MySQL.
a.Save a copy of HMS_Data.xlsx as HMS_ERD.xlsx and for each sheet delete the definition and arrange the data so that the sample data appears immediately below the column headings. Position the data for each table starting from cell A1.
b.Import your normalised data from Excel into your tables. Save your data in Excel in a CSV file format. Select your table in MySQL, click the Operations tab and then import the data from the CSV file. Refer to the document titled Import CSV into MySQL to learn how to save in a CSV format and import into MySQL.
Add at least two new records into the appropriate tables to include your details as a guest, room booking details of your own, and notes details related to your guest record.
Answer:
Background Information on the project
A local hotel in Sydney requires a system that can manage their day to day activities including the payment and booking systems.
The system should be able to enter new guests details and capture information about them this will entail their names, addresses, mobile-telephone numbers and other relevant information about the guests. After registration to the system they should be able to create reservations online and edit them before the date of checking in.
A reservation in the hotel would include details about the guests, this includes and not limited to, number of children and adults visiting the hotel, expected arrival and departure times, any special conditions can be added to notify the hotel in a note attached to the reservation.
On the check in day a room number is attached to the reservation and the timestamp of the date is recorded, walk in guests are also entered in the system and allocated rooms.
On check out the system calculates the invoice by getting the days of the stay and calculated by the room charges for each room occupied, any additional service charges are added to the bill and the guest can pay the invoice through a number of selected methods. An invoice can be paid through multiple payment methods.
The system also keeps a record of all the employees and those who have access to the system as users, the different types of rooms and their charges, the different methods of paying for invoices etc
Assumptions
Some service have variable costing while others costs are fixed. Sometimes these charges can be adjusted by a manager or by someone with sufficient rights within the system. Charges generated by the system are gotten by getting the product of the service charge by the number of times it was requested.
Purposes and needs of the database.
The purpose of this database is to:
Enable guests to do or cancel reservations for the type of rooms they want, for how long they will stay and for how many people will stay during the visit.
The system will then on check out be able to generate a bill of all the expenses incurred by the guest and those accompanying them, this also includes the room charges for the entire stay.
It will enable the guest to clear the bills through various payment methods.
The system will also keep a record of all employees of the hotel.
Mission Statement/ System Definition
DBMS Selection
The RDBMS of choice for this project is MySQL, the reason for using this type of database is because of its scalability and ability to handle large data sets with ease. Having a stable system while handling numerous request make MySQL ideal for handling the hotels large number of employees and potential guest and their companions.
The database also adds to its functionality by extending its use of SQL(Structured Query Language) with other programming languages like PHP and python for creating dynamic web applications that can do a myriad of functions.
Challenges and Solutions
Designing a payment system that accepts different payment types for different rooms.
This is due to the fact that most payment systems accept only one type of payment for the total amount of the invoice or invoiced amount.
This was mitigated by adding another entity to breakdown the many to many relationship that exists between the invoice and payment entities.
Implementing a system that can accept variable charges for additional cost and fixed charges for other costs, also any of these cost could be changed by the manager.
Reference
Clare Churcher, 2007. Beginning Database Design from Novice to Professional. Apress[Viewed 17 September 2018]. Available from: https://kva.es/Database.Design.From.Novice.to.Professional.pdf
Tutorials Point, 2015. Database Management Systems. Tutorials Point (I) Pvt. Ltd.[Viewed 17 september 2018]. Available from: https://www.kciti.edu/wp-content/uploads/2017/07/dbms_tutorial.pdf
Free Membership to World’s Largest Sample Bank
To View this & another 50000+ free samples. Please put
your valid email id.
Yes, alert me for offers and important updates
Submit
Download Sample Now
Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.
UploadUnique Document
DocumentUnder Evaluation
Get Moneyinto Your Wallet
Total 3 pages
PAY 2 USD TO DOWNLOAD
*The content must not be available online or in our existing Database to qualify as
unique.
Cite This Work
To export a reference to this article please select a referencing stye below:
APA
MLA
Harvard
OSCOLA
Vancouver
My Assignment Help. (2021). Database Management For Business. Retrieved from https://myassignmenthelp.com/free-samples/isy1002-database-management-for-business/design-from-novice-to-professional.html.
“Database Management For Business.” My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/isy1002-database-management-for-business/design-from-novice-to-professional.html.
My Assignment Help (2021) Database Management For Business [Online]. Available from: https://myassignmenthelp.com/free-samples/isy1002-database-management-for-business/design-from-novice-to-professional.html[Accessed 18 December 2021].
My Assignment Help. ‘Database Management For Business’ (My Assignment Help, 2021)
My Assignment Help. Database Management For Business [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/isy1002-database-management-for-business/design-from-novice-to-professional.html.
×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}
×
Thank you for your interest
The respective sample has been mail to your register email id
×
CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.
Account created successfully!
We have sent login details on your registered email.
User:
Password:
MyAssignmenthelp helps with a wide array of academic tools to ease out the life of students. We have a unique tool called paraphrasing tool which can be used to praphrase any book, articles, blogs and others in minutes. You just need to copy paste the content in the paraphrasing tool box and then submit to get a paraphrased work in minutes. The best alternatives of words and proper placement are the hallmarks of our paraphrasing tool.Online paraphrasing had never been so easier. To get a quality assignment, properly edited and reflecting 100% originality, connect with experts at myassignmenthelp.com.
Latest Management Samples
div#loaddata .card img {max-width: 100%;
}
MPM755 Building Success In Commerce
Download :
0 | Pages :
9
Course Code: MPM755
University: Deakin University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More
SNM660 Evidence Based Practice
Download :
0 | Pages :
8
Course Code: SNM660
University: The University Of Sheffield
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration
BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20
Course Code: BSBHRM513
University: Tafe NSW
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More
MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5
Course Code: MKT2031
University: University Of Northampton
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration
MN506 System Management
Download :
0 | Pages :
7
Course Code: MN506
University: Melbourne Institute Of Technology
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology
Next