Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started