PROBLEM DESCRIPTION The Molly Mackenzie Marina and its surrounding property are located on Gippsland Lakes in Victoria, the Gippsland Lakes are a network of lakes, marshes and lagoons covering over 600 square kilometres. Marvin and Dean Mackenzie own and operate the Molly Mackenzie Marina. Currently, the marinas daily operating activities relies on a simple use of spreadsheet to capture data and manually processed. When necessary, reports are created using word processing package. The marinas popularity continues to grow, and Mr. Mackenzie is quickly realising the necessity of using web information technology to ease the marinas paperwork burden. In an effort to run the office in a more efficient manner, Mr. Mackenzie hires you to design a website for the marina. The website will be used to track information about customer reservations, customer payments, and the marinas rental properties. Current Situation The Molly Mackenzie Marina rents cabins, a variety of watercraft, and boat slips to its customers. When a customer requests a watercraft or a cabin, a price quote is given. The price quote is based on a daily rate. If a customer wants to rent a jet ski for a half day, then the daily rate is adjusted. Likewise, if a customer rents a cabin or boat slip for more than a day, Mr. Mackenzie will discount the daily rate, making a longer stay more attractive. Cabins can be rented for a weekend, week, or month at a reduced rate. Table 1 shows the discount codes and their associated percentage discounts. Table 1: Rate Codes and Discounts Rate Code Rate Description Percentage DL Daily 100.00% HD Half Day 65.00% SD Special Discount 25.00% SM Six Months 85.00% YR 12 Months 80.00% WK Weekend 90.00% While reserving the property, deposits are collected on following basis: The deposit is applied to the rental fees for the property or is forfeited if the customer cancels the reservation. Mr. Mackenzie is flexible on the deposit amount. Mr. Mackenzie requires a minimum deposit from frequent customers but does charge a hefty deposit for new customers. When a customer picks up the watercraft or checks into a cabin, he is required to pay the entire balance for the property, minus any deposit. If an advanced reservation was no made, the customer pays the entire balance when he/she rents the property. When a customer requests a particular property, following actions are carried out: Mr. Mackenzie, or an employee check to see if the property is available for the date's requests by the customer. If the requested dates are available, reservation data are captured on a reservation form. Based on the length of stay, Mr. Mackenzie determines which rate is applicable. Kent Institute Australia Pty. Ltd. Assessment Brief 4 ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version 2: 14 th November 2022 Page 3 of 8 TEQSA Provider Number: PRV12051 For a typical reservation, customer contact information (name, phone number, and mailing address), reservation dates, and property information (rental property number and rate), are recorded. When a reservation is made, the customer is given a reservation number. The customer uses the reservation number if he/she cancel the reservation or when he/she checks in. When a payment is made, the payment date, payment amount, and any comments are recorded. When the customer returns the watercraft or checks out of the cabin, he/she stops by the office and is given an invoice showing his/her rental transactions. Requirements Mr. Mackenzie asks you to create an informative, attractive, easily navigate page, and professional-looking website. Mr. Mackenzie wants the web pages from the website to serve as an information source for both current and future customers. This website will be used for marina management which involving functionalities such as customer reservations, customer payments, and the marinas rental properties. Considering the design of the Marinas website, you identify three major components: security logon, system maintenance, and marina management. The security logon component is the gateway to the whole system. A typical login screen asks the user for a username and a password. If the user passes this security check, the other parts of the application become accessible. The system maintenance part of the system keeps the applications that support the data in the database up to date. Typically, tasks involved are add information, edit existing information, or delete information. The web application has two levels of system permissions that are verified each time a user logs on and tries to perform a specific task. Level 1 access is given to system administrators, which means that any user with this level of access can manage this system support data as well the marina information. A user with level 2 access is not allowed into this system maintenance area but is allowed to access the marina data. The marina management component is the main portion of the system. It involves tracking information about customer reservations, customer payments, and the marina rental properties. Any user that gains access to the system is allowed to add, edit, or delete the data here. Data Specifications A few rounds of talk with Mr. Mackenzie, you realise that a database is needed for the marina website and that the database must capture and store data and information about the marinas customers, rental property, rental reservations. In addition, you realise that a number of web pages and forms are required for capturing information. Information about the marinas customers, rental reservations, and rental payments. For instance, a customer form with reservation and payment history forms is necessary. The customer form captures and displays the customers name, address, email, and phone number. Additionally, the customer form shows the customer identification number, total charges, the amount he/she has paid, and the balance due. The total charges field show the total amount owed for the customers current reservations. Likewise, the AmountPaid field shows the total paid toward the current reservations, and the Remaining Balance field indicates how much is still due. On the reservation form, Mr. Mackenzie wants to see at a minimum, the reservation dates, booking date, property identification number, rate code, discount percentage, daily rental rate, discounted daily rental rate, total usage cost, and comments. When using the Reservation form, Mr. Mackenzie wants to select the rental property number from a list of his rental properties and have the rental propertys description and rental fee displayed. On the payment form, Mr. Mackenzie wants to see the payment date, payment amount, and comments. Although Mr. Mackenzie encourages you to be creative with your form design, he requests that the forms have a consistent, professional appearance, be easy to use. Additionally, each form must include buttons that allow Kent Institute Australia Pty. Ltd. Assessment Brief 4 ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version 2: 14 th November 2022 Page 4 of 8 TEQSA Provider Number: PRV12051 Mr. Mackenzie to add delete, find, and display records. Where possible, you should use validation rules, default values, input masks, and proper formatting. Information Specifications On the Marinas website, it should have a function to display a Daily Rental Property Reservation Report, a function to display a Rental Availability Report, and a function to display a Customer Invoice. The Daily Rental Property Reservation shows which properties are reserved for the next day. This report sorts the properties by rental property category, then rental property number within each category. Employees use this reservation report to make sure that the reserved watercraft and cabins are in working order. Often customers will ask when a rental property is available. It is then required that the website provides ability to locate rental propertys record and check its availability. The Rental Property Availability report should be organised by rental category, showing which rental properties are available for rent the next day and the rental property should be sorted within each category. Mr. Mackenzie asks you to prepare a customer invoice. The invoice will serve as a receipt for the customer's rental transactions. As mentioned above, you are free to work with the design of the web pages layout and forms. You may need to create additional forms/pages or collect information that has not been previously specified. You can discuss with your lecturer to understand those requirements about the problem. DELIVERABLES In order to satisfactorily complete this assignment, you should build the database-driven website as described in the problem description and then prepare a written report. The following are required for submission of deliverables: First things first. You are not allowed to make use of a web framework (eg. CakePHP, CodeIgniter, Laminas Yii, etc.) in building your website. Your work will not be marked, and a zero grade will be given if an attempt was evident. A written report, written in Microsoft word format, details the design and implementation of your website. The report should contain two parts: Website design and Website implementation and programming. o Website design needs to provide information about analysing and designing your website for the case. Documents required in this part involve, for example, functional requirements, nonfunctional requirements, diagrams such as ERDs, DFDs, etc. o The second part, which is Website implementation and programming, of the report needs to provide information on developing the website which is based on the information indicated in the design part. Documents required for this part include a website structure, layout of pages, database design including tables, attributes, types of data for attributes such as numeric, text, etc. with their constraints such as max length, etc. The report should provide adequate information from a system design standpoint to address how your website was designed, coded, tested, and implemented. Discuss any assumptions you have made about the problem and the key elements of the problem. Additionally, what features did you add to make the website more functional? User friendly? (Please note that these assumptions cannot violate any of the requirements specified above and must be approved by your lecturer.) The report should also indicate what components/functionalities work (partially or fully), and those that do not (include why). Also, it is essential in this document to have a brief how-to on installing/using your program code on a local machine as a test bed for your web site. If your website requires login/password, information about login and password need to be provided. As part of this report include what validation you have included on the inputs and why.