Cl. "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]...

Information system course Please very necessary


Extracted text: Cl. "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. Nemadic Desert Camp, Oman CUSTOMER BILL Customer ID: 170212 Booking ID: 17022112 Booking Date: 17* February, 2021 Nationality: Omani Customer Name: Title: Ms. First Name: Mumtaz Last Name: Al Jabri Address: Post Box No.: 484 Postal Code : 411 Place : Sur Phone No: 99123456 S.No Item ID Quantity Price per Total Quantity Amount OR 30 Description of Amusements Booked 1 Quad Bike Ride OR 6 QB0021 DB1007 OR 15 OR 40 1 seater Dune Buggy Ride 3 OR 5 DB2004 2 seater Dune Buggy Ride OR 10 15 person 10 person Desert Safari OR 5 p OR 40 OR 4 p OR 200 4 DS0010 OR 75 CRO012 CamelRide TotalAmount [Figure C1] 近