A/618/7400 Unit 4 Level 4 Database Design & Development Assignment 1, ISMT College
| University | International School of Management and Technology (ISMT) College |
| Subject | Unit 4 Database Design & Development |
FACULTY OF COMPUTING
| UNIT TITLE | Unit 4: Database Design & Development | ||
| UNIT CODE | A/618/7400 | LEVEL | 4 (Core) |
| STUDENT NAME | CREDIT VALUE | 15 | |
| ASSESSMENT TITLE | Hotel Room Reservation System
|
WORD COUNT | |
| ASSESSOR | Ram Prasad Chaudhary | I.V. | |
| ASSIGNMENT ISSUE DATE | October 12, 2025 | ASSIGNMENT SUBMISSION DATE | December 20, 2025 |
| ORIGINAL SUBMISSION | ASSIGNMENT NO. | 1/1 | |
Are You Searching Answer of this Question? Request Malaysian Writers to Write a plagiarism Free Copy for You.
ASSESSMENT CRITERIA TO BE ASSESSED IN THIS ASSIGNMENT
(Identify all criteria to be assessed in this assignment)
| Assignment Criteria | P1 | P2 | P3 | P4 | P5 | ||||||
| Achieved | |||||||||||
| Merit Criteria | Distinction Criteria | ||||||||||
| Assignment Criteria | M1 | M2 | M3 | M3 | M4 | M5 | D1 | D2 | D3 | ||
| Achieved | |||||||||||
Important:
- Read the plagiarism notice and requirements at Page 6
- Word-limit- 8000 words (excludes cover page, table of content, figures, graphs, reference list, appendix and logbook)
- Accepted Sources: Research Papers (Journal Articles, Conference Proceedings, Thesis), Text Books, Governmental Data, Websites (only a registered organization, an educational institution, government agency)
- Information taken from unreliable sources will not be accepted
- Must follow Harvard Reference Style
- Assignment must be submitted through the Plagiarism Detection Tool
Assignment Submission Format
Each student has to submit their assignment as guided in the assignment brief. The students are guided on what sort of information is to produce to meet the criteria targeted. You are required to make use of headings, paragraphs, and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system.
Learning Outcomes Covered
- LO1 Use an appropriate design tool to design a relational database system for a substantial problem
- LO2 Develop a fully-functional relational database system, based on an existing system design
- LO3 Test the system against user and system requirements
- LO4 Produce technical and user documentation.
Scenario
The “Evath Hotel” is a new upcoming boutique hotel, located in a scenic location near Pokhara. The management of the hotel has decided to implement a robust, secure hotel reservation system to use at the front desk.
Whenever a new guest arrives at the hotel, the front desk staff look into the system for availability and reserve rooms for the guests as per their request. All the information of the guest (including name, contact number, duration of stay etc) is entered during check in. One guest may book more than one room, but a room can be booked under only one person’s name.
The guest may request for additional services during their stay, including extra beds, food, airport pick up, sightseeing services etc. The total amount payable has to be calculated at the time of check out.
The manager would require regular reports- weekly and monthly regarding occupancy and sales. Further he should be able to add/ edit rooms in the system.
Your task is to conduct a thorough software investigation and prepare a DBMS for the system.
ASSIGNMENT TASKS
Task
Activity 1: Designing the Database as per the scenario
Before you start the development process, you need to prepare a proposal document to be submitted to your manager. The document should contain:
1. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables.
2. Clear statements of user and system requirements.
You would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include interface and output designs, data validations and cover data normalization.
Your manager would like a separate report on your assessment of the effectiveness of the design in relation to user and system requirements.
Activity 2: Development and testing of the database system
Create and fully implement the database system showing evidence of user interface, output and data validations and querying across multiple tables using a query language. The system must also be fully secure and maintainable.
Include code snippets and screenshots of the system functionalities as evidence wherever required.
For a higher grade:
You would want to include more than just the basics so you will implement a fully functional database system which will include system security and database maintenance features.
Further provide a detailed assessment of whether meaningful data has been extracted through the use of query tools to produce appropriate management information. and an evaluation of the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.
Further,
Develop and action a test plan with effective tests that includes effective data, and extreme and erroneous data in order to build an accurate picture of the viability of the database
Tests must assess the breadth and usability of the programme as well as the requirements in the brief
Tests must include meaningful data and elements that would demonstrate a successful implementation
Further Produce a written report:
To assess the effectiveness of testing, including an explanation of the choice of the test data used. and evaluate the effectiveness of the database against user requirements and suggest improvements.
5) Produce a series of user videos and a detailed technical and user documentation:
● Technical: showing the backend of the system and its associated setup, including data flow diagrams and flowcharts, describing how the system works
● User: showcasing the system from a user perspective.
For a higher grade, You would want to provide some graphical representations for ease of reference in the technical guide, so you need to produce technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works.
Lastly, Evaluate the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
LEARNING OUTCOMES AND ASSESSMENT CRITERIA
| Pass | Merit | Distinction |
| LO1 Use an appropriate design tool to design a relational database system for a substantial problem |
LO1 D1 Evaluate the effectiveness of the design in relation to user and system requirements. |
|
| P1 Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements. |
M1 Produce a comprehensive design for a fully-functional system, which includes interface and output designs, data validations and data normalisation |
|
| LO2 Develop a fully-functional relational database system, based on an existing system design |
LO2 & LO3 D2 Evaluate the effectiveness of the database solution in relation to user and system requirements and suggest improvements.
|
|
| P2 Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables.
P3 Implement a query language into the relational database system. |
M2 Implement a fully functional database system, which includes system security and database maintenance.
M3 Assess whether meaningful data has been extracted through the use of query tools to produce appropriate management information. |
|
| LO3 Test the system against user and system requirements | ||
| P4 Test the system against user and system requirements.
|
M4 Assess the effectiveness of the testing, including an explanation of the choice of test data used. | |
| LO4 Produce technical and user documentation |
LO4
D3 Evaluate the database in terms of improvements needed to ensure the continued effectiveness of the system |
|
| P5 Produce technical and user documentation. | M5 Produce technical and user documentation for a fully-functional system, including data flow diagrams and flowcharts, describing how the system works. | |
Plagiarism Notice
You are reminded that there exists Academic Misconduct Policy and Regulation concerning Cheating and Plagiarism.
Extracts from the Policy:
Section 3.4.1: Allowing others to do assignments / Copying others assignment is an offence
Section 3.4.2: Plagiarism, using the views, opinion or insights / paraphrasing of another person’s original phraseology without acknowledgement
Requirements
● It should be the student’s own work – Plagiarism is unacceptable.
● Clarity of expression and structure are important features.
● Your work should be submitted as a well presented, word-processed document with headers and footers, and headings and subheadings.
● You are expected to undertake research on this subject using books from the Library, and resources available on the Internet.
● Any sources of information should be listed as references at the end of your document and these sources should be referenced within the text of your document using Harvard Referencing style
● Your report should be illustrated with screen-prints, images, tables, charts and/or graphics.
● All assignments must be typed in Times New Roman, font size 12, 1.5 spacing.
● The center policy is that you must submit your work within due date to achieve “Merit” and “Distinction”. Late submission automatically eliminates your chance of achieving “Merit and Distinction”. Also, 80% attendance is required to validate this assignment.
Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services.
Get Help By Expert
Facing challenges designing the Hotel Room Reservation Database System for your A/618/7400 Database Design & Development Assignment at ISMT College? Get expert help from professionals through Database Design Assignment Help to build ER diagrams, normalize data, and create secure SQL queries. Our Assignment Helper Malaysia offer ISMT Assignment Help with accurate documentation, testing reports, and programming assignment help that ensures top grades and 0% plagiarism.
Answer
Recent Solved Questions
- PGBM01: Relying only on accounting figures from Income Statement and Balance: Financial Management and Control Assignment, UOS, Malaysia
- Business Ethics Assignment, CU, Malaysia Offering a bribe is wrong because it is an inducement to act dishonestly, disregard one’s duties, and betray a trust
- BBCA1033 Introduction to Accounting Assignment, CUM, Malaysia
- SBFS1103: Thinking Skills and Problem-Solving Assignment, OUM, Malaysia In the 21st century, it has become essential for companies to be digitally literate in a challenging business environment
- LAW434: Malaysian Legal System Assignment, UITM, Malaysia With reference to decided cases discuss the application of the doctrine of stare decisis in Malaysia
- Economic Principles and Issues Assignment, UiTM, Malaysia In the study of microeconomics, the understanding of Price Elasticity of Demand is paramount to the strategy
- Python and Java Coding Assignment, CU, Malaysia Create an Ed workspace for your team and share it with the other members Upload the code sca old into the workspace
- BBPB2103: Human Resource Management Assignment, OUM, Malaysia Select any organization of your choice. Explain the environmental factors and the impacts on the practices of human resource
- ITS63504: Human Computer Interaction Assignment, TU, Malaysia You are recently hired by Hilti and are appointed as an International IT Consultant cum UI-UX Designer at Hilti Corporation
- Environmental Science Assignment, UON, Malaysia Enzim E memangkin hidrolisis substrat S Kinetik E (V0) sebagai satu fungsi S diukur dan data diperoleh seperti dalam Jadual
