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


Cl. “Nomadic Desert Camp, Oman

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. iii. 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 io lso maintained in the table Item Details. Nemadic Desert Gamp, Oman CUSTOMER BILL Booking ID: 17022112 Booking Date: 17h February, 2021 Nationality: Omani Customer ID: 170212 Customer Name: Title: Ms. First Name: Mumtaz Last Name: Al Jabri Address: Post Box No. : 484 Postal Code 411 Place : Sur Phone No: 99123456 Price pe Quantity| Amount OR 6 SNo Item ID Description of Amusements Quantity Total Booked QB0021 Quad Bike Ride DB1007 |1 seater Dune Buggy Ride DB2004 OR 30 w/ OR 5 OR 15 4 OR 10 OR 40 OR 75 3 seater Dune Buggy Ride DS0010 |Desert Safari Camel Ride Total Amount 4 15 person OR 5/p OR 4p T0 person CROO12 OR 40 OR 200 [Figure C1]

Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here