Question: Section C: Long Answer Questions (2 questions x 5 marks = 10 marks) Answer ALL questions C1. Nomadic Desert Camp, Oman requires an Information System

 Section C: Long Answer Questions (2 questions x 5 marks =

Section C: Long Answer Questions (2 questions x 5 marks = 10 marks) Answer ALL questions C1. 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 C1] 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 is also maintained in the table Item Details. Nomadic Desert CUSTOMER BILL 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 Booking ID: 17022112 Booking Date: 17th February, 2021 Nationality: Omani S.N. Item ID Price Description of Amusements Quantity Booked Total Amoun t per Quantit y OR 6 OR 5 1 5 OR 30 OR 15 2 3 QB0021 Quad Bike Ride DB 1007 1 seater Dune Buggy Ride DB2004 2 seater Dune Buggy Ride 3 4 OR 10 OR 40

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!