Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. 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:
    1. A customer can book one or more amusements.
    2. There are different types of amusements available in the camp.
    3. The booking done by each customer will be assigned with a unique Booking ID.
    4. Each item is assigned with a unique ID for identification.
    5. Each items current available quantity is also maintained in the table Item Details.

Customer ID: 170212 Booking ID: 17022112

Customer Name: Booking Date: 17th February, 2021

Title: Ms. First Name: Mumtaz Last Name: Al Jabri Nationality: Omani

Address:

Post Box No. : 484 Postal Code : 411 Place : Sur

Phone No: 99123456

S.No

Item ID

Description of Amusements

Quantity Booked

Price per Quantity

Total Amount

1

QB0021

Quad Bike Ride

5

OR 6

OR 30

2

DB1007

1 seater Dune Buggy Ride

3

OR 5

OR 15

3

DB2004

2 seater Dune Buggy Ride

4

OR 10

OR 40

4

DS0010

Desert Safari

15 person

OR 5/p

OR 75

5

CR0012

Camel Ride

10 person

OR 4/p

OR 40

Total Amount

OR 200

[Figure C1]

Nomadic Desert Camp, Oman

Customer Bill

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Learning MySQL Get A Handle On Your Data

Authors: Seyed M M Tahaghoghi

1st Edition

0596529465, 9780596529468

More Books

Students also viewed these Databases questions

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago