C1. Nomadic Desert Camp, Oman requires an Information System to maintain the details of the amenities...
Fantastic news! We've Found the answer you've been seeking!
Question:
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: 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] 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]
Expert Answer:
Answer rating: 100% (QA)
An entity is a thing or an object in the world that us different from all other objects In and ERD e... View the full answer
Related Book For
Posted Date:
Students also viewed these computer network questions
-
An automobile driver uses a control system to maintain the speed of the car at a prescribed level. Sketch a block diagram to illustrate this feedback system.
-
1. For what value of t (tax) will the profit for the company and the government be in equilibrium? # of products Company makes Price per Product Profit for Company Govt. tax Govt. Profit 15,000 $185...
-
Question 4: (25 marks) A. There are different types of auditor opinions, one of which they must express in their audit report once they will complete their audit process. List and briefly discuss the...
-
DTG agreed to merge with the SPQ. The total equity purchase price of $45,000 is going to be 50% financed issuing DTGs common shares and 50% financed with cash raised by DTG issuing long-term debt....
-
In April 2009, Gallup published results from data collected from a large sample of adults in the 27 European Union member states. One of the questions asked was, "Which is the most practicable and...
-
Marino Company predicts that it will use 25,000 units of material during the year. The expected daily usage is 200 units, and there is an expected lead time of five days and a desired safety stock of...
-
What would happen to the SML graph in Figure 8.8 if expected inflation increased or decreased? Figure 8.8 268 269 270 271 272 273 274 275 A Required Rate of Return TH-13.0% SML: r, RF+RPM * b D E F H...
-
(Three Differences, No Beginning Deferred Taxes, Multiple Rates) The following information is available for Rammers Corporation for 2010. 1. Depreciation reported on the tax return exceeded...
-
Gradient of the Rayleigh Quotient For a symmetric matrix A and a nonzero vector , the Rayleigh Quotient is defined by xT Ax xTx In the case where is an eigenvector, then the Rayleigh Quotient will...
-
According to a Bureau of Labor Statistics release of March 25, 2015, statisticians earn an average of $84,010 a year. Suppose that the current annual earnings of all statisticians have the mean and...
-
Locate and identify the critical points of at (/3, /6). f(x, y) = (x - 1) - (xy-x-1) - Find the equation of the tangent plane to the surface 1 + cos (x - y) 1 + cos (x + y) f(x, y) = 2 =
-
What is the cash conversion cycle? Explain.
-
How does intergroup conflict influence internal group dynamics, and what role does social identity play in fostering intragroup cohesion and exacerbating intergroup conflict?
-
Why is it important for gerontologists to broaden their understanding of race and ethnicity?
-
1. A risk-free bond will pay you $1000 in 2 years and nothing in between. The annual discount rate is i=67.5% compounded annually. What is the bonds present value?
-
Why can't you make a living shooting real estate for $30 a property? Write up a sample cost of doing business, and figure out what your costs are for cell phone, vehicle expenses, marketing, photo...
-
Strategy formulation on space x company 1. the functional level 2. the business level 3. The corporate level please give me answer these three topic in one thousand word about space x company.
-
Consider a closed, rigid tank with a volume of 0.8L, filled with cold water initially at 27C. The tank is filled such that there are no voids (air pockets) within. The initial pressure within the...
-
A system has a loop transfer function (a) For K = 4, show that the gain margin is 3.5 dB. (b) If we wish to achieve a gain margin equal to 16 dB, determine the value of the gain K. L(s)-G(s)G(s)-s(s...
-
A multi loop block diagram. (a) Compute the transfer function T(s) = Y(s)/R(s). (b) Determine K such that the steady-state tracking error to a unit step input R(s) = 1/s is zero. Plot the unit step...
-
A unity feedback system has a loop transfer function (a) Determine the angle of departure of the root locus at the complex poles. (b) Sketch the root locus. (c) Determine the gain K when the roots...
-
Identify and correct the errors in the following passages. a. Company's are finding it to their advantage to cultivate their suppliers. Partnerships among a company and it's suppliers can yield hefty...
-
How can you create an effective strategy for your interview?
-
How can you plan for a successful career?
Study smarter with the SolutionInn App