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 06:30
Ummit record company is negotiating with two banks for a $157,000 loan. fidelity bank requires a compensating balance of 24 percent, discounts the loan, and wants to be paid back in four quarterly payments. southwest bank requires a compensating balance of 12 percent, does not discount the loan, but wants to be paid back in 12 monthly installments. the stated rate for both banks is 9 percent. compensating balances will be subtracted from the $157,000 in determining the available funds in part a. a-1. calculate the effective interest rate for fidelity bank and southwest bank. (do not round intermediate calculations. input your answers as a percent rounded to 2 decimal places.) a-2. which loan should summit accept? southwest bank fidelity bank b. recompute the effective cost of interest, assuming that summit ordinarily maintains $37,680 at each bank in deposits that will serve as compensating balances
Answers: 1
question
Business, 22.06.2019 08:20
How much does a neurosurgeon can make most in canada? give me answer in candian dollar
Answers: 1
question
Business, 22.06.2019 08:40
Which of the following is not a characteristic of enterprise applications that cause challenges in implementation? a. they introduce "switching costs," making the firm dependent on the vendor. b. they cause integration difficulties as every vendor uses different data and processes. c. they are complex and time consuming to implement. d. they support "best practices" for each business process and function. e. they require sweeping changes to business processes to work with the software.
Answers: 1
question
Business, 22.06.2019 12:00
In mexico, many garment or sewing shops found they could entice many young people to work for them if they offered clean, air conditioned work areas with high-quality locker rooms to clean up in after the work day. typically, traditional garment shops had to offer to get workers to apply for the hard, repetitive, and somewhat dangerous work. a. benchmark competitive wages b.compensating differentials c. monopoly wages d. wages based on human capital development of each employee
Answers: 3
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, 12.03.2021 14:00
Questions on the website: 13722361