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...
-
Determine the value of x2 for 13 degrees of freedom and a. .025 area in the left tail of the chi-square distribution curve b. .995 area in the right tail of the chi-square distribution curve
-
A piston/cylinder arrangement contains air at 250 kPa, 300C. The 50-kg piston has a diameter of 0.1 m and initially pushes against the stops. The atmosphere is at 100 kPa and 20C. The...
-
How to obtain a temporary restraining order?
-
Record the following transactions. 1. Pay employee salaries of $600 by issuing checks. 2. Purchase computer equipment of $1,000 using a credit card. 3. Pay for maintenance of $400 for a company...
-
1) (2 pts) Identify by name the following surfaces. (a) x + z -y+2=0 (b) (x-1) 2 y z = 0 (c) y + z - 8z+15=0 2 2 (d) x + y - z - 1 = 0 2) (2 pts) Identify by name and sketch the following surfaces....
-
Nadine Heru, the CEO of Heru Resources, hardly noticed the time as she was reviewing the engineering report just handed to her. The report described a proposed new mine on the North Ridge of Mt....
-
TEK wishes to hedge a EUR4,000,000 account receivable arising from a sale to Olivetti (Italy). Payment from Olivetti is due in three months. TEKs Italian unit does not have ready access to local...
-
The food we eat is broken down, or metabolized, in stages by a group of complex biological molecules called enzymes. Most of the energy released at each stage is captured for function and growth. One...
-
ces Domino Company uses the aging of accounts receivable method to estimate uncollectible accounts expense. Domino began Year 2 with balances in Accounts Receivable and Allowance for Doubtful...
-
Electric eels, found in South America, can provide a potential difference of 440 V that draws a current of 0.80 A through the eel's prey. Calculate the resistance of the circuit (the eel and prey)
-
Differentiate between a scalar value and a vector value.
-
Having a bit of trouble completing part of the code for my guessing game in java. Basically, I need to add the part of the code that will allow the user to choose how many games they wish to play....
-
My opinion has shifted to realize how much more detailed audit is. I realize it is not as simple as comparing items for accuracy and looking for discrepancies or fraud; it so much more. I've barely...
-
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.
-
A uniform circular disc is pivoted at point \(O\), as shown in Fig. 2.105. Find the natural frequency of the system. Also find the maximum frequency of the system by varying the value of \(b\). b...
-
Find the natural frequency of the traffic sign system described in Problem 2.79 in torsional vibration about the \(z\)-axis by considering the masses of both the post and the sign. The spring...
-
Solve Problem 2.99 by changing the material from steel to bronze for both the post and the sign. Material properties of bronze: \(ho\) (specific weight) \(=80.1 \mathrm{kN} / \mathrm{m}^{3}, E=111.0...
Study smarter with the SolutionInn App