A charter company owns boats that are used for charter trips to islands. The company has...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A charter company owns boats that are used for charter trips to islands. The company has created a computer system to track the boats it owns, including each boat's ID number, name, and seating capacity. The company also tracks information about the various islands, such as their names and populations. Every time a boat is chartered, it is important to know the date that the trip is to take place and the number of people on the trip. The company also keeps information about each captain, such as Social Security number, name, birthdate, and contact information for next of kin. Boats travel to only one island per visit. QUESTIONS: 1. Create a data módel. Include entities, attributes, identifiers, and relationships. 2. Which entities are dependent? Which are independent? 3. Draw an entity-relationship model A charter company owns boats that are used for charter trips to islands. The company has created a computer system to track the boats it owns, including each boat's ID number, name, and seating capacity. The company also tracks information about the various islands, such as their names and populations. Every time a boat is chartered, it is important to know the date that the trip is to take place and the number of people on the trip. The company also keeps information about each captain, such as Social Security number, name, birthdate, and contact information for next of kin. Boats travel to only one island per visit. QUESTIONS: 1. Create a data módel. Include entities, attributes, identifiers, and relationships. 2. Which entities are dependent? Which are independent? 3. Draw an entity-relationship model
Expert Answer:
Related Book For
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
Posted Date:
Students also viewed these databases questions
-
A charter company owns boats that are used for charter trips to islands. The company has created a computer system to track the boats it owns, including each boat's ID number, name, and seating...
-
Name the valuation base(s) that are used for each of the asset and liability accounts shown here. Some assets and liabilities can use more than one valuation base. Original Lower of Cost or Fair...
-
A stock brokerage has four computers that are used for making trades on the New York Stock Exchange. The probability that a computer fails on any single day is 0.005. Failures occur independently....
-
A production supervisor at a major chemical company wishes to determine whether a new catalyst, catalyst XA-100, increases the mean hourly yield of a chemical process beyond the current mean hourly...
-
Sparwood Ltd. began operations in 2015. Its summarized financial statements are presented below. Fill in the shaded areas to complete the financial statements. Begin your work with 2015 and move...
-
Question: Builder wants to develop 1,000 acres in rural Montana, land that is home to the Kite Owl. The Environmental Protection Agency (EPA) rules that the Kite Owl is an endangered species, and...
-
The following data pertain to the Blending Department at Fasten Chemicals for April: The plastic compound is introduced at the start of the process, while the softening compound is added when the...
-
Explain why each of the following situations is an agency problem and what costs to the firm might result from it. Suggest how the problem might be dealt with short of firing the individual(s)...
-
work. . (4 points) Distances from Ron's house to the grocery store and library are shown. Ron in-line skates from his house to the grocery store. Then he goes to the library and returns home. How far...
-
Let's say that professor Sanford dies (this is not going to happen for another 20 years), and the estate of decedent- Sanford comes into existence. Also, assume that you are the adopted child of...
-
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 7% return from its investments. (PV of $1, FV of $1. PVA of $1, and EVA of...
-
Lethabo suffers from insomnia and, when he does sleep, he often sleepwalks. His doctor has prescribed him medication to control this condition. Lethabo goes on a camping trip with his friends and as...
-
1) Briefly describe how the following alternative dispute mechanisms (ADR)work: (a) mediation; (b) arbitration; and (c) negotiation. IN ADDITION, please offer 3 advantages and 3 disadvantages to...
-
TranscribedText We want to determine the distance between two points A and B that are directly across from one another on opposite sides of a river. We mark the locations of those points and walk 50...
-
Lito Company had cash inflows from operating activities of $39,000; cash outflows from investing activities of $34,000, and cash outflows from financing activities of $24,000. Calculate the net...
-
= Obara notices a kitten sitting on the ledge of a building, a height h 22 m off the ground. When the kitten loses its footing and begins to fall straight downward from rest, Obara sprints toward the...
-
Explain the time period assumption. E3.1 (LO 1), C Chloe Davis has prepared the following list of statements about the time period assumption. 1. Adjusting entries would not be necessary if a...
-
Why do bars offer free peanuts?
-
Explain what is meant by a nonfunctional requirement. What are the primary types of nonfunctional requirements? Give two examples of each. What role do nonfunctional requirements play in the project...
-
When would you use electronic reports rather than paper reports, and vice versa?
-
Describe the major elements and issues with iterative development.
-
Todays spot rate of the Mexican peso is $.10. Assume that purchasing power parity holds. The U.S. inflation rate over this year is expected to be 7 percent, while the Mexican inflation over this year...
-
You believe that interest rate parity and the international Fisher effect hold. Assume that the U.S. interest rate is presently much higher than the New Zealand interest rate. You have receivables of...
-
The Argentine 1-year CD (deposit) rate is 13 percent, while the Mexican 1-year CD rate is 11 percent and the U.S. 1-year CD rate is 6 percent. All CDs have zero default risk. Interest rate parity...
Study smarter with the SolutionInn App