Provide diagrams such as ERDs, DFDs, etc from the database, gave: Data Specifications A few rounds...

Transcribed Image Text:

Provide diagrams such as ERDs, DFDs, etc from the database, gave: 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 marina's 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 marina's 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 customer's 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 customer's 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 property's description and rental fee displayed. On the payment form, Mr. Mackenzie wants to see the payment date, payment amount, and comments. Provide diagrams such as ERDs, DFDs, etc from the database, gave: 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 marina's 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 marina's 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 customer's 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 customer's 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 property's description and rental fee displayed. On the payment form, Mr. Mackenzie wants to see the payment date, payment amount, and comments.

Answer rating: 100% (QA)

EntityRelationship Diagram ERD Identify Entities In this case you have entities like Customer Rental ... View the full answer