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, 21.06.2019 20:20
Jing-sheng facilitated a hiring committee for his advertising company. six employees (including two managers) met together to discuss applicants and select the finalists for a copywriter position in the public relations department. although the head of public relations would have the final nod on the candidate that would ultimately be hired, the evaluative work of the committee was very important because this group would send forward those persons they believed would be good work colleagues. in setting up this type of hiring process, the head of public relations was utilizing a(n) style of leadership.a. autocraticb. free-reinc. contingentd. participative
Answers: 3
question
Business, 22.06.2019 05:00
Which of the following differentiates cost accounting and financial accounting? a. the primary users of cost accounting are the investors, whereas the primary users of financial accounting are the managers. b. cost accounting measures only the financial information related to the costs of acquiring fixed assets in an organization, whereas financial accounting measures financial and nonfinancial information of a company's business transactions. c. cost accounting measures information related to the costs of acquiring or using resources in an organization, whereas financial accounting measures a financial position of a company to investors, banks, and external parties. d. cost accounting deals with product design, production, and marketing strategies, whereas financial accounting deals mainly with pricing of the products.
Answers: 3
question
Business, 22.06.2019 06:30
Select all that apply. select the ways that labor unions can increase wages. collective bargaining reducing the labor supply increasing the demand for labor creating monopolies
Answers: 1
question
Business, 22.06.2019 13:00
Dakota products has a production budget as follows: may, 16,000 units; june, 19,000 units; and july, 24,000 units. each unit requires 3 pounds of raw material and 2 direct labor hours. dakota desires to keep an inventory of 10% of the next month’s requirements on hand. on may, 1 there were 4,800 pounds of raw material in inventory. direct labor hours required in may would be:
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
French, 11.02.2020 00:28
question
Advanced Placement (AP), 11.02.2020 00:28
Questions on the website: 13722359