Business
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

answer
Answers: 2

Other questions on the subject: Business

image
Business, 22.06.2019 05:00, swelch2010
You are chairman of the board of a successful technology firm. there is a nominal federal corporate tax rate of 35 percent, yet the effective tax rate of the typical corporation is about 12.6%. your firm has been clever with use of transfer pricing and keeping money abroad and has barely paid any taxes over the last 5 years; during this same time period, profits were $28 billion. one member of the board feels that it is un-american to use various accounting strategies in order to avoid paying taxes. others feel that these are legal loopholes and corporations have a fiduciary responsibility to minimize taxes. one board member quoted what the ceo of exxon once said: “i’m not a u. s. company and i don’t make decisions based on what’s good for the u. s.” what are the alternatives? what are your recommendations? why do you recommend this course of action?
Answers: 2
image
Business, 22.06.2019 05:00, grangian06
Personal financial planning is the process of creating and achieving financial goals? true or false
Answers: 1
image
Business, 22.06.2019 11:20, johnlecona210
Security a has a higher standard deviation of returns than security b. we would expect that: (i) security a would have a risk premium equal to security b. (ii) the likely range of returns for security a in any given year would be higher than the likely range of returns for security b. (iii) the sharpe ratio of a will be higher than the sharpe ratio of b. (a) i only (b) i and ii only (c) ii and iii only (d) i, ii and iii
Answers: 1
image
Business, 22.06.2019 15:50, fireemblam101ovu1gt
Evaluate a real situation between two economic actors; it could be any scenario: two competing businesses, two countries in negotiations, two kids trading baseball cards, you and another person involved in an exchange or anything else. use game theory to analyze the situation and the outcome (or potential outcome). be sure to explain the incentives, benefits and risks each face.
Answers: 1
Do you know the correct answer?
You are working as a consultant for a rental car agency, and have been asked to design a database to...

Questions in other subjects:

Konu
Mathematics, 27.06.2019 13:40
Konu
History, 27.06.2019 13:40
Konu
English, 27.06.2019 13:40