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 04:30
Annuity payments are assumed to come at the end of each payment period (termed an ordinary annuity). however, an exception occurs when the annuity payments come at the beginning of each period (termed an annuity due). what is the future value of a 13-year annuity of $2,800 per period where payments come at the beginning of each period? the interest rate is 9 percent. use appendix c for an approximate answer, but calculate your final answer using the formula and financial calculator methods. to find the future value of an annuity due when using the appendix tables, add 1 to n and subtract 1 from the tabular value. for example, to find the future value of a $100 payment at the beginning of each period for five periods at 10 percent, go to appendix c for n = 6 and i = 10 percent. look up the value of 7.716 and subtract 1 from it for an answer of 6.716 or $671.60 ($100 × 6.716)
Answers: 2
question
Business, 22.06.2019 05:30
Eliza works for a consumer agency educating young people about advertisements. instead of teaching students to carefully read advertisement claims, she encourages them to develop a strong sense of self and to keep their life goals and dreams separate from commercial products. why might eliza's advice make sense?
Answers: 2
question
Business, 22.06.2019 11:30
(select all that apply) examples of email use that could be considered unethical include denying receiving an e-mail requesting that you work late forwarding a chain letter asking for donations to a good cause sending a quick message to your friend about last weekend sending your boss the monthly sales figures in an attachment setting up a meeting with your co-worker sharing a funny joke with other employees
Answers: 2
question
Business, 22.06.2019 12:30
True or false entrepreneurs try to meet the needs of the marketplace by supplying a service or product
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, 20.11.2020 18:20
question
English, 20.11.2020 18:20
question
Mathematics, 20.11.2020 18:20
question
Mathematics, 20.11.2020 18:20
Questions on the website: 13722367