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: 17th February, 2021 Nationality: Omani 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 S.No Item ID Description of Amusements Quantity Price per Total Quantity Amount OR 30 OR 15 Вooked Quad Bike Ride OR 6 OR 5 1 QB0021 2 DB1007 1 seater Dune Buggy Ride DB2004 2 seater Dune Buggy Ride DS0010 Desert Safari CRO012 | Camel Ride 3 3 4 OR 10 OR 40 15 person 10 person 4 OR 5/p OR 75 5 OR 4/p OR 40 Total Amount OR 200 [Figure C1]
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: 17th February, 2021 Nationality: Omani 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 S.No Item ID Description of Amusements Quantity Price per Total Quantity Amount OR 30 OR 15 Вooked Quad Bike Ride OR 6 OR 5 1 QB0021 2 DB1007 1 seater Dune Buggy Ride DB2004 2 seater Dune Buggy Ride DS0010 Desert Safari CRO012 | Camel Ride 3 3 4 OR 10 OR 40 15 person 10 person 4 OR 5/p OR 75 5 OR 4/p OR 40 Total Amount OR 200 [Figure C1]
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Draw an Entity Relationship Diagram for ther following information.
![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: 17th February, 2021
Nationality: Omani
Customer ID:170212
Customer Name:
Title: Ms.
First Name: Mumtaz
Last Name: Al Jabri
Address:
Post Box No. : 484
|
Place : Sur
Postal Code : 411
Phone No: 99123456
S.No Item ID Description of Amusements Quantity Price per
Total
Вooked
Quantity | Amount
1
QB0021 | Quad Bike Ride
5
OR 6
OR 30
DB1007 | 1 seater Dune Buggy Ride
DB2004 2 seater Dune Buggy Ride
DS0010 Desert Safari
CRO012 | Camel Ride
2
3
OR 5
OR 15
3
4
OR 10
OR 40
OR 75
OR 40
4
15 person | OR 5/p
5
10 person
OR 4/p
Total Amount
OR 200
[Figure C1]](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbb3bbbe5-8e7c-4ab0-8699-6edb31e03c73%2Fb8466007-1e57-4e8f-92a9-9b4a814e77c1%2Fau3dok4_processed.png&w=3840&q=75)
Transcribed Image Text: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: 17th February, 2021
Nationality: Omani
Customer ID:170212
Customer Name:
Title: Ms.
First Name: Mumtaz
Last Name: Al Jabri
Address:
Post Box No. : 484
|
Place : Sur
Postal Code : 411
Phone No: 99123456
S.No Item ID Description of Amusements Quantity Price per
Total
Вooked
Quantity | Amount
1
QB0021 | Quad Bike Ride
5
OR 6
OR 30
DB1007 | 1 seater Dune Buggy Ride
DB2004 2 seater Dune Buggy Ride
DS0010 Desert Safari
CRO012 | Camel Ride
2
3
OR 5
OR 15
3
4
OR 10
OR 40
OR 75
OR 40
4
15 person | OR 5/p
5
10 person
OR 4/p
Total Amount
OR 200
[Figure C1]
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY