Melissa’s Boating Emporium, DATABASE SYS:THEORY & PROGM

Melissa’s Boating Emporium, DATABASE SYS:THEORY & PROGM

At Melissa’s Boating Emporium, Melissa rents different kinds of boats to their customers: jet skis, skiffs, and pontoons for a day. All boats will have a specific daily rental rate.
Melissa needs to manage the following pontoon information:

Registration Number
Name (each pontoon is named uniquely)
Capacity (i.e., how many people they will hold)
Skiffs are fairly standard, so Melissa needs to only manage the following skiff information:

Registration Number
Jet Ski information Melissa needs is as follows:

Registration Number
Date Manufactured
Jet Ski type (Recreational, Rec-Lite, or Luxury)
Age of Jet Ski
Pontoons and skiffs can be used for fishing, and Melissa will see to it that you have the right equipment for your rental. As an option, your rental can include the following types of equipment: bucket, net, bait knife, cutting board, map of surrounding areas, anchor, rod rentals and bait. Every piece of equipment has its own rental cost.  Each of these fishing items can be added to your boat rental, but equipment is not associated with any one boat. Any boat rental can also include an optional flare gun from the inventory of equipment for an extra price. All equipment will have a description and a rental price. All boats are available for rentals.
Melissa wants to keep track of the date of all her rentals and the overall charge. As for her customers, she will want to log their name (first name and last name will do), their cell phone number, and their New Jersey Boat Safety Certificate identification number.
Finally, Melissa will sell any of her used Jet Skis to customers. She will make a determination at the time of sale as to what she will charge. But she wants to keep track of the amount of the sale, the date of the sale, and to whom it was made.
Please submit your ER or EER diagram.

Oder Solution Now

Why Use Our Services

1. Professional & Expert Writers: AResearchers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by AResearchers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. AResearchers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses. First time customer will receive three free pages on their first order. 

6. 24/7 Customer Support: At AResearchers, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.