Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

C1. Nomadic Desert Camp, Oman requires an Information System to maintain the details of the amenities provided by them to their tourists and the

C1. Nomadic Desert Camp, Oman requires an Information System to maintain the details of the amenities provided by them to t

Nomadic Desert Camp, Oman CUSTOMER BILI. Booking ID: 17022112 Booking Date: 17th February, 2021 Nationality: Omani Customer I  

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

Step by Step Solution

3.50 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

An entity is a thing or an object in the world that us different from all other objects In and ERD e... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Control Systems

Authors: Richard C. Dorf, Robert H. Bishop

12th edition

136024580, 978-0136024583

Students also viewed these Computer Network questions

Question

Explain the process of MBO

Answered: 1 week ago