subject
Business, 12.08.2019 17:20 connermichaela

You are working as a consultant for a rental car agency, and have been asked to design a database to manage rentals. you have been given the following requirements statement: “we capture information on our customers. customers are identified by a unique customer number. for each customer, we record first name, last name, birthdate, and address. we need to know a customer’s age to determine rental rates and eligibility, but we can figure that out once we know the birthdate. for the purpose of formatting mailings, we like to break the address out by street, city, state, and zip. a customer may sign a rental agreement, but we will record a prospective customer in our database before they ever sign an agreement. we never record a rental agreement without an associated customer. there will be at most one customer per agreement. there could be many agreements for a single customer. a rental agreement is identified by a unique agreement id, and for each agreement, we record a start date and an end date. a single agreement can cover multiple cars, and we’ll never have an agreement unless it covers at least one car. we will record cars in our database before anybody has agreed to rent them. over time, there could be many agreements per car. a car is uniquely identified by its vin. for each car, we record the number of miles that are on it. every rental agreement is always prepared by a single employee. the employee is uniquely identified by an employeenumber, and we also record the employee’s last name. an employee could prepare many rental agreements, but some employees will never prepare any agreements. every car represents exactly one model. each model has a unique model id, and we will also capture its name and make. we can’t have a car without an associated model, and we won’t record a model in our database until we have at least one associated car. however, a model can have many associated cars. a customer may sponsor one or more alternate drivers, but doesn’t have to sponsor any other drivers. for each alternative driver, we record a full name and a driver id. the driver id counts upward for each customer – the first alternate driver for a given customer will be assigned a driver id of 1, the second will be assigned a driver id of 2, and so on. every alternate driver will be associated with exactly one customer.”which of the following does not show up in this erd? a. weak entityb. multi-valued attributec. composite attributed. none of the other choices

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 05:30
Laurelton heating & cooling installs and services commercial heating and cooling systems. laurelton uses job costing to calculate the cost of its jobs. overhead is allocated to each job based on the number of direct labor hours spent on that job. at the beginning of the current year, laurelton estimated that its overhead for the coming year would be $ 61 comma 500. it also anticipated using 4 comma 100 direct labor hours for the year. in april comma laurelton started and completed the following two jobs: (click the icon to view the jobs.) laurelton paid a $ 20-per-hour wage rate to the employees who worked on these two jobs. read the requirements requirement 1. what is laurelton's predetermined overhead rate based on direct labor hours? determine the formula to calculate laurelton's predetermined overhead rate based on direct labor hours, then calculate the rate. / = predetermined overhead rate
Answers: 2
question
Business, 22.06.2019 06:10
Information on gerken power co., is shown below. assume the company’s tax rate is 40 percent. debt: 9,400 8.4 percent coupon bonds outstanding, $1,000 par value, 21 years to maturity, selling for 100.5 percent of par; the bonds make semiannual payments. common stock: 219,000 shares outstanding, selling for $83.90 per share; beta is 1.24. preferred stock: 12,900 shares of 5.95 percent preferred stock outstanding, currently selling for $97.10 per share. market: 7.2 percent market risk premium and 5 percent risk-free rate. required: calculate the company's wacc. (do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) wacc %
Answers: 2
question
Business, 22.06.2019 19:50
Managers in a firm hired to improve the firm's profitability and ultimately the shareholders' value will add to the overall costs if they pursue their own self-interests. what does this best illustrate? a. diseconomies of scale b. principal-agent problem c. experience-curveeffects d. information asymmetries
Answers: 1
question
Business, 22.06.2019 23:50
Jaguar has full manufacturing costs of their s-type sedan of ÂŁ22,803. they sell the s-type in the uk with a 20% margin for a price of ÂŁ27,363. today these cars are available in the us for $55,000 which is the uk price multiplied by the current exchange rate of $2.01/ÂŁ. jaguar has committed to keeping the us price at $55,000 for the next six months. if the uk pound appreciates against the usd to an exchange rate of $2.15/ÂŁ, and jaguar has not hedged against currency changes, what is the amount the company will receive in pounds at the new exchange rate?
Answers: 1
You know the right answer?
You are working as a consultant for a rental car agency, and have been asked to design a database to...
Questions
question
Mathematics, 29.09.2019 18:20
Questions on the website: 13722363