Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This all together please solve CI. Nomadic Desert Camp, Oman requires an Information System to maintain the details of the amenities provided by them to

image text in transcribed

image text in transcribed

This all together please solve

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 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 is also maintained in the table Item Details. Nomadic Desert Camp, Oman CUSTOMER BILL Customer ID: 170212 Customer Name: Title: Ms. First Name: Mumtaz Booking ID: 17022112 Booking Date: 17th February, 2021 Nationality: Omani Last Name: Aljabri Nomadic Desert Camp, Oman CUSTOMER BILL. Customer ID:170212 Customer Name: Title: Ms. First Name: Mumtaz Last Name: AlJabri Address: Post Box No.: 484 Postal Code : 411 Place : Sur Phone No:99123456 Booking ID: 17022112 Booking Date: 17th February, 2021 Nationality: Omani S No Item ID Description of Amusements Price per Quantity Booked 1 2 3 4 5 QB0021 DB 1007 DB 2004 DS0010 CR0012 Quad Bike Ride 1 seater Dune Buggy Ride 2 seater Dune Buggy Ride Desert Safari I Camel Ride Total Amount [Figure Cl] 3 4 15 person Total Quantity Amount OR 6 OR 30 OR 5 OR 15 OR 10 OR 40 OR 5 p OR 75 OR +p OR 40 OR 200 10 person

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

Students also viewed these Databases questions