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

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

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

EntityRelationship Diagram ERD Identify Entities In this case you have entities like Customer Rental ... 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

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

More Books

Students also viewed these Databases questions