Question: Styles Section C: Long Answer Oestions (2 questions x 5 marks - 10 marks) Answer ALL questions 5 CI. Nomadic Desert Camp, Oman requires an
Styles Section C: Long Answer Oestions (2 questions x 5 marks - 10 marks) Answer ALL questions 5 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 Ci is an example of a record used by them for booking the amenities. Druw s Entity Relationship Diagram Your Entity Relationship Diagram (ERD) should show Entities, attributes, Key uttributes, optionality, and cardinality. Also consider the following points for developing relationships: A customer can book one or more musements H. There are different types of sements 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 is also maintained in the table lem Details Nomadic Dout Cong, Oman Customer 10:170212 Customer Name Title: Ms. First Name: Mama Last Name: Al label Address: Post Box 484 Postal Code: 411 Placesur Phone No:99123456 CUSTOMER BIL Booking 10:17022112 Booking Date: 17 February, 2021 Nationality Oman S.No Item ID Description of Amusements 1 1 2 3 4 5 QH0021 Quad Bike Ride DB1007 sefer Dune Bagay Ride DB 2004 2 seter Dune Buty Ride DS0010 Safari CR0012 Camel Ride Total Amount Figore CI Quantity Price per Total Booked Quantity Amouni 5 CRG OR 30 3 OR 3 OR 15 4 OR 10 OR 40 19.pero OR OR 75 10 person OR 4 OR 40 OR 200 lish (United States Focus 6 W P MacBook Pro 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
