Question: CI. Nomadic Desert Camp, Oman requires an Information System to maintain the details of the amenities provided by them to their tourists and the customers.
CI. "Nomadic Desert Camp, Oman requires an Information System to maintain the details of the amenities provided by them to their tourists and the customers. 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, optionality, and cardinality. Also consider the following points for developing relationships: i. A customer can book one or more amusements. ii. There are different types of amusements available in the camp 111. The booking done by each customer will be assigned with a unique Booking ID. 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, Oman CUSTOMER BILL Customer ID: 170212 Booking ID: 17022112 Customer Name: Booking Date: 17 February, 2021 Title: Ms. First Name: Mumtaz Last Name: Al Jabri Nationality: Omani Address: Post Box No.: 484 Postal Code: 411 Place : Sur Phone No:99123456 S.No Item ID Description of Amusements Quantity Total Booked Quantity Amount 1 QB0021 Quad Bike Ride OR 6 OR 30 2 DB1007 1 seater Dune Buggy Ride 3 OR 5 OR 15 3 DB2004 2 seater Dune Buggy Ride 4 OR 10 OR 40 4 DS0010 Desert Safari 15 person OR 5 p OR 75 5 CR0012 Camel Ride OR 4p OR 40 Total Amount OR 200 Price per 10 person
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
