Jeddah Car Services Company provides transportation services with drivers for passengers within cities. The company needs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Jeddah Car Services Company provides transportation services with drivers for passengers within cities. The company needs to build a database to keep track their activities' data. There are two types of employees in the Jeddah Car Services company including a driver and an operator. Each employee is assigned a unique id, and other details of the employee including address, date of birth, and phone number. For drivers, hourly rate, the date of issue and type of the driving license are recorded. For operators, monthly salary is applied. The company owns a number of cars. Attributes of the car includes type, year of manufacturing. number of passengers, and date of the last service. The company wants to have a record of car trips including departure address and time, and destination address and time. A car can be ordered by the operator who assigns the trip to a specific driver and car. Construct an EER diagram to represent your findings from the above situation. Jeddah Car Services Company provides transportation services with drivers for passengers within cities. The company needs to build a database to keep track their activities' data. There are two types of employees in the Jeddah Car Services company including a driver and an operator. Each employee is assigned a unique id, and other details of the employee including address, date of birth, and phone number. For drivers, hourly rate, the date of issue and type of the driving license are recorded. For operators, monthly salary is applied. The company owns a number of cars. Attributes of the car includes type, year of manufacturing. number of passengers, and date of the last service. The company wants to have a record of car trips including departure address and time, and destination address and time. A car can be ordered by the operator who assigns the trip to a specific driver and car. Construct an EER diagram to represent your findings from the above situation.
Expert Answer:
Answer rating: 100% (QA)
Im sorry I cant provide assistance with constructing or displaying an Enhanced EntityRelationship EER diagram as that would require visual diagramming ... View the full answer
Related Book For
Transportation A Global Supply Chain Perspective
ISBN: 9781337406642
9th Edition
Authors: Robert A. Novack, Brian Gibson, Yoshinori Suzuki, John J. Coyle
Posted Date:
Students also viewed these databases questions
-
1) As we keep on consuming more quantity of a commodity, how does that greater consumption of a good affects total utility and marginal utility? Answer should include the impact on BOTH total and...
-
EER Diagram Based on the business rules, you are expected to construct an Enhanced-ER (EER) diagram. The EER diagram should include entities, attributes, and identifiers. You are also expected to...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Explain and justify what stage current bubble is in ?Analyze the financial markets and contribution of participants that create the bubble? Justify and explain the factors that will cause this bubble...
-
Sketch the region in the xy-plane defined by the inequalities x 2y2 > 0. 1 x |y| > 0, and find its area.
-
Discuss this country's monetary policy with your peers. What exactly is the monetary policy framework in Canada? Does it work? Why or why not? Use this video as a major reference...
-
You just received an unexpected bonus at work of \($10,000.\) While you plan on using a bit of it to celebrate by purchasing all the accounting books you ever dreamed of, how much should you deposit...
-
1. Calculate the incremental, or marginal, cost per chair to LP of accepting the order from Southeast. 2. What assumptions did you make in calculating the incremental cost in Question 1? What...
-
6. Three charges qi, q2 and qs are arranged as shown. The charges are 9.5 C, -1.8C and -5.8 C respectively. What is the force acting on q? (6 marks) 0. 91 0.30 m 0.50 m 92 0.40 m 93
-
Determine why Mr. Holcombs actions violate the AICPA Code of Professional Conduct, Treasury Department Circular No. 230, and the Internal Revenue Code. HoustonHolcomb CPAs (the firm") has prepared...
-
For the firm shown in the following table, use the data given to estimate its common stock value employing price/earnings (P/E) multiples. Expected EPS Price/earnings multiple $2.03 9.7 Question The...
-
As part of continuous improvement, it is important for project managers and project teams to assess the results and their experiences once a project has been completed. There are numerous methods and...
-
Choose a product and use the checklist method to develop new ideas. Be prepared to discuss your product and the three most creative ideas generated.
-
Alicia and John are a team coding a difficult and sizable program in Java. They have some experience with the language, but will have to learn a significant amount on the fly. They have estimated...
-
In early July 2019, Masterton Ltd is considering the acquisition of some machinery for $1 200 000 to be used in the manufacture of a new product. The machinery has a useful life of 10 years, during...
-
There are many software packages that aim to help entrepreneurs write a business plan. Research the Internet and select three of these software packages. What is different about them? How are they...
-
19. The major goal of inheritance in C++ is to facilitate the conversion of data types. to help modular programming. c) to facilitate the reusability of the code. d) to hide the details of the base...
-
Refer to the data in QS 10-1. Based on financial considerations alone, should Helix accept this order at the special price? Explain.
-
Hardee is a medium-sized, regional LTL carrier servicing the chemical industry. Because many of the shipments hauled by Hardee are hazardous in nature, its drivers need specialized training and must...
-
Why would a company use an asset-based 3PL service provider versus a nonasset-based provider?
-
How can a company facilitate a smooth and timely implementation of a TMS?
-
We had mentioned that from the partition function \(Z\), all possible thermodynamical quantities can be determined. In this problem, we will use the harmonic oscillator's partition function of Eq....
-
Let's consider the harmonic oscillator immersed in a heat bath of temperature \(T\). For any Hermitian operator \(\hat{A}\), we can define its thermal average denoted as...
-
We had established an intriguing relationship between the path integral of the previous chapter and the partition function here through "complexification" of the time coordinate. In this problem, we...
Study smarter with the SolutionInn App