Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5 Cl. Nomadic Desert Camp, Oman requires an Information System to main- tain the details of the amenities provided by them to their tourists and
5 Cl. "Nomadic Desert Camp, Oman requires an Information System to main- tain the details of the amenities provided by them to their tourists and the custom- ers. The customer bill given below (Figure Cl] is an example of a record used by them for booking the amenities. Draw an Entity Relationship Diagram Your Entity Relationship Diagram (ERD) should show Entities, attributes, Key attributes, option- ality, and cardinality. Also consider the following points for developing relationships: 1. A customer can book one or more amusements. ii. There are different types of amusements available in the camp. 11. The booking done by each customer will be assigned with a unique Booking D iv. Each item is assigned with a unique ID for identification v. Each item's current available quantity is also maintained in the table Item Details Nomadic Desert Camp, CUSTOMER BILL Oustomer D. 1702 12 Booking D. 17022112 Customer Name Booking Date: 17 February, 2021 Title: Ms. First Name: Mumtar Last Name: Al Jabri ERLER ERRETE Post Box No. 484 Postal Code 411 Place Sur Phone No. 99123456 Nationality: Oman SANOItem D Description of Amusements 1 22 Quantity Price pe Total Booked Quantity Amount ORG OR 30 3 OR 5 ORIS 4 OR 10 OR 40 15 person OR SP OR 75 10 person OR 4p OR 40 QB0021 Quad Bike Ride DBIOOT | seater Dune Buggy Ride DB2004 2 seter DuneBuggy Ride DSC010 Desert Safari CR0012 Camel Ride 3 3
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