Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

More Books

Students also viewed these Databases questions

Question

Simplify the given algebraic expressions. 2F 2T 2 + 3F T

Answered: 1 week ago

Question

* What is the importance of soil testing in civil engineering?

Answered: 1 week ago

Question

Explain the concept of shear force and bending moment in beams.

Answered: 1 week ago