Holiday Travel Vehicle (HTV) sells new recreational vehicles and travel trailers. When new vehicles arrive at HTV, a new vehicle record is created. Included in the new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost.
When a customer arrives at HTV, he or she works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed upon, a sales invoice is completed by the salesperson. The invoice summarizes the purchase, including full customer information, information on the trade-in vehicle (if any), the trade-in allowance, and information on the purchased vehicle. The invoice also summarizes the final negotiated price, plus any applicable taxes and license fees.
If the customer requests dealer-installed options (simply options), they are listed on the invoice as well. A customer may decide to have no options added to the vehicle or may choose to add many options. Dealer-installed options are described by an option code, description, and price. Each invoice lists just one customer. An option may be listed on no invoices, or it may be listed on many invoices.
The trade-in vehicle is described by a serial number, make, model, and year. A customer may trade in no more than three vehicles on a purchase of a new vehicle. The trade-in vehicle may be sold to another customer who later trades it in on another HTV.
The transaction concludes with a customer's signature on the sales invoice. Customers are assigned a customer ID when they make their first purchase from HTV. Name, address, date of birth, age, and phone number are recorded by the customer. A person does not become a customer until he or she purchases a vehicle.
Over time, a customer may purchase at most five vehicles from HTV. Every invoice must be filled out by one salesperson. A new salesperson might not have sold any vehicle, but experienced salespeople have probably sold many vehicles. Each invoice only lists one new vehicle. If a new vehicle in inventory has not been sold, there will be no invoice for it. Once the vehicle sells, there will be just one invoice for it.
(USE CASE DIAGRAM ATTACHED)
- Draw a class diagram for the case.
- In the use-case diagram attached, we may find a use case "Create New Vehicle Record". Draw a sequence diagram for the use case.
- In the use-case diagram attached, we may find a use case "Create Sales Transaction Record". Draw a sequence diagram for the use case.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- The State of New York certifies firefighters through- out the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique fire- fighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieu- tenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervi- sors are always higher-ranking certified firefighters. Construct a relational database for New York’s fire departments and firefighters.arrow_forwardThe Motor Vehicle Department Database The Motor Vehicle Branch administers driving tests and issues driver's licenses. Any person who wants a driver's license must take a learner's exam at any Motor Vehicle Branch in the province. If he/she fails the exam, he can take the exam again any time after a week of the failed exam date, at any branch. If he passes the exam, he is issued a license (type = learner's) with a unique license number. A learner's license may contain a single restriction on it. The person may take his driver's exam at any branch any time before the learner's license expiry date (which is usually set at six months after the license issue date). If he passes the exam, the branch issues him a driver's license. A driver's license must also record if the driver has completed driver's education, for insurance purposes.arrow_forwardDon't want copy paste answerarrow_forward
- A real Estate Company has in its poššession a long list of landlords and the rent cost of their two bedroom apartments, as shown on table 1. There is the need for an Application program that will allow a user at the company to load the said list into a computer program, i.e. the list of landlords and the cost of rent. The app must also allow users to search for apartments they can afford. Apart from the list in the table, the App should be able to take as input the maximum amount a tenant is willing to spend on a two-bedroom apartment and then display a list of landlords whose apartments can be rented with that amount. Table 1: Landlords and Cost of rent Landlord Ama Dua Ali Dulon John Togbe Abena Nyame Kofi Duku Cost of rent (GHC) 800.00 950.00 2,500.00 600.00 2,300.00arrow_forward# Create College Database: # input choice using integer # create if-else conditions: # if you entered number 1 # enter student id, # enter student name # enter student major # enter students grade1 # enter students grade2 # calculate total grades # calculate average of grades # create if else condition where based on average will display their grade too # display all variables # if you entered number 2 # enter faculty id, # enter faculty name # enter faculty department # enter faculty monthly salary # show yearly salary by calculating monthly salary with 12 # display all variablesarrow_forwardAccess Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…arrow_forward
- A social recreation club has a system to keep track of club members, committees and activities. Each club has a registration number and a title. Several members form committee. Members are male and females. Each committee has a name, a unique number and a date, which the committee has formed. The system stores the members' unique identification number, name, address, gender, birth date and club joining date. The club forms committees for different activities. A committee controls and organizes a number of activities, each of which has a unique name, a unique number and description of the event. An event has event ID and description of the event. An activity may consist of several events. Committee publishes many online advertisements about the activities. Advertisement details are ID and a title. Draw the ER diagram to represent the above scenarioarrow_forwardin a shop ,there are 10 employee and 20 kinds of goods,goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?arrow_forwardUntil a file signature analysis is run, EnCase relies on the ______ to determine its file type. header extension database acquisition hash libraryarrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education