ER Model Assignment (2.5 point each) Create an ER model that includes entities (tables), Primary Keys...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ER Model Assignment (2.5 point each) Create an ER model that includes entities (tables), Primary Keys (PK) and Foreign Key (FK) where appropriate. Include at least three fields that describe each entity. Put the ER Model under each question or submit it in a separate Word Document. Q1: A new startup company in Maine called Maine Trips is offering customers trips along Maine's coast and mountain trails. Customers have to make reservations for trips and often make more than one trip per summer. I Q2: These same trips can include a registered Maine Guide for a more educational experience. Please add tables and relationship that would allow adding a Maine guide to customer trips. (Hint: Many to Many relationship needed here!) ER Model Assignment (2.5 point each) Create an ER model that includes entities (tables), Primary Keys (PK) and Foreign Key (FK) where appropriate. Include at least three fields that describe each entity. Put the ER Model under each question or submit it in a separate Word Document. Q1: A new startup company in Maine called Maine Trips is offering customers trips along Maine's coast and mountain trails. Customers have to make reservations for trips and often make more than one trip per summer. I Q2: These same trips can include a registered Maine Guide for a more educational experience. Please add tables and relationship that would allow adding a Maine guide to customer trips. (Hint: Many to Many relationship needed here!)
Expert Answer:
Answer rating: 100% (QA)
Q1 ER Model for Maine Trips Startup Entities 1 Customer Fields CustomerID PK Name Email 2 Trip Field... View the full answer
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Posted Date:
Students also viewed these general management questions
-
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...
-
Salmon River Outfitters is a small business located in upstate N.Y. that organizes day long fishing trips. Currently, they use an excel workbook in Excel to keep tract of reservations. Their business...
-
Cooper Movie Studio Corp. makes movies and is interested in lowering its operating costs for the following year, while maintaining the high quality and appeal of its movies. Cooper's management is...
-
Identify the best answer to each question: 1. Each of the following criteria is a factor when determining Special Revenue Fund property tax revenue recognition except a. Whether the taxes collected...
-
You are making a $120,000 investment and feel that a 22% rate of return is reasonable, given the nature of the risks involved. You expect to receive $48,000 in the first year, $54,000 in the second...
-
The chilled-water plant at the University of Pennsylvania sends chilled water to the buildings at \(42^{\circ} \mathrm{F}\) and receives warmed water at \(55^{\circ} \mathrm{F}\). A refrigerant is...
-
Jupiter Company sells goods to Danone Inc. by accepting a note receivable on January 2, 2017. The goods have a sales price of $610,000 (cost of $500,000). The terms are net 30. If Danone pays within...
-
How the best in details would theses table and graphs be described on Staff members' awareness of the Strategic Goals? Maximum level awareness (7) - Employee able to identify and articulate the...
-
The trial balance of Jeremina plc as at 31 March 20X2 is as follows: Notes: (i) Stock of finished goods on 31 March 20X2 163,000. (ii) Motor expenses and depreciation on motors to be apportioned:...
-
Think of a product that you would like to introduce in the market and answer the following questions: What are the FAB (Features, advantages, and benefits of the product) of the product? (4%) Make up...
-
Under a Modified Endowment Contract, what are the likely tax consequences?
-
Identify characteristics of notes payable that are not common to accounts payable. Multiple select question. Does not arise from past transaction Based on promissory note Usually classified as...
-
What is an insurance policy's grace period? Explain.
-
It should be standard practice to have culture sensitivity training, what does that look like to you? Should this start in grade school or once people hit the workforce?
-
Can you please help with explaining the: Criteria for Evaluating Theory It is not necessary to have all five criteria for evaluating a theory in order for a theory to be labeled "good." In your...
-
The balance sheet and the income statement of "Omega" Company containing data in is as follows: Assets Fixed assets: Property, plant and equipment Less accumulated depreciation Net property, plant...
-
As long as we can't lose any money, we have a risk-free investment." Discuss this comment. Q2: Both investing and gambling can be defined as "undertaking risk in order to earn a profit." Explain how...
-
Using the Customers table in the BSN database that accompanies this book and following the directions in this chapter, create the report in Figure. Note that you will have to reformat and perhaps...
-
The Espy Company recently had an outside consulting firm perform an audit of its information systems department. One of the consultants identified some business risks and their probability of...
-
What are CASE tools? How are they used? How do CASE tools create documentation for AISs? If you were a systems analyst, would you use a CASE tool?
-
(a) Consider the flash separation process shown in Figure 7.1. If using ASPEN PLUS, solve all three cases using the MIXER, FLASH2, FSPLIT, and PUMP modules and the RK-SOAVE option set for...
-
As discussed in Example 6.7, toluene \(\left(\mathrm{C}_{7} \mathrm{H}_{8} ight)\) is to be converted thermally to benzene \(\left(\mathrm{C}_{6} \mathrm{H}_{6} ight)\) in a hydrodealkylation...
-
As discussed in Example 6.7, the following stream at \(100^{\circ} \mathrm{F}\) and 484 psia is to be separated by two distillation columns into the Products \(1-3\) in the following table. Two...
Study smarter with the SolutionInn App