Class Diagram
Jim Smith’s dealership sells Fords, Hondas, and Toyotas. The dealership keeps information about each car manufacturer with whom employees deal so that they can get in touch with manufacturers easily. Information kept about manufacturer include Name, Contact name, and Phone. The dealership also keeps basic information about the models of cars that it carries from each manufacturer. The dealership keeps such information as list price, the price the dealership paid to obtain the model, and the model name, dealer cost, and series (e.g., Honda Civic LX). The dealer also keeps information about he sold vehicle such as VIN #, Model, Series, Buyer name, and Purchase price. It also keeps information about the buyer’s name, address, and phone number. Several operations can be added to the system such as Add new manufacturer contact, Add new series, Find all models within certain price range, Add sold vehicle, Find allsold vehiclesfor certain models, and List buyers of models
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Jim Smith's dealership sells Fords, Hondas, and Toyotas. The dealership keeps information about each car manufacturer with whom they deal so that they can get in touchwith them easily. The dealership also keeps information about the models of cars that they carry from each manufacturer. They keep information such as list price, theprice the dealership paid to obtain the model, and the model name and series (e.g., Honda Civic LX). They also keep information about all sales that they have...
Kevis Family RV Kevis Family RV is a dealership that sells new recreational vehicles and travel trailers. A customer works with a salesperson to negotiate a vehicle purchase. A sales invoice is completed by the salesperson when a purchase has been agreed upon. The invoice includes full customer information, information on the trade-in vehicle (if any), the trade-in allowance, information on the purchased vehicle, the final negotiated price, plus any applicable taxes and license fees. If the customer requests dealer-installed...
ERD and Schema for the model is:CUSTOMER ( ID, Lname, Fname, Street, City, ZipCode, State, Phone, CreditScore, Credit_Org, CS_Date)PLAN ( Plan_ID, Start_Date, End_Date, BasePrice, Plan_Type)VOICE ( vPlan_ID@, NumMin, HasVoiceMail, HasThreeWay, OverageFee)TEXT ( tPlan_ID@, TextLimit, HasMMS, MmsOverage, TextOverage)DATA ( dPlan_ID@, DataLimit, NetworkTechnology, OverageFee)CONTRACT ( Contract_ID, Customer_ID@, vPlan_ID@, tPlan_ID@, dPlan_ID@, Start_Date, End_Date, DiscountPerc)MANUFACTURER ( Manuf_ID, Manuf_Name, Contact_Lname, Contact_Fname, Contact_Phone, Contact_Email)PRODUCT ( Product_ID, Name, Manuf_ID@, CostPaid, BasePrice, Type)CELLPHONE ( Phone_ID@, Model, NetworkTechnology, OS)ACCESSORY ( Access_ID@, Category)PHONE_ACCESS ( Phone_ID@, Access_ID@)CONTRACT_CELLPHONE ( Contract_ID@, Phone_ID@, Seq#, PaidPrice, ESN)1. CellTell would like to add website information about the manufacturers of products they sell. Add a new column named “Website” to the manufacturer table. Then,...
I need help constructing a special inventory system. I need certain components that will check the age of the customer and then assign them to a car model. It will be business logic classes. To test your classes, you will use them in a relatively small test application. The requirements for testing and the classes within PYTHON 3 are as follows: • Need to build and design TWO components of the reservation sys. One class to represent customers, and another...
Can someone who knows how to draw data model on mySQL help me out? Budget car rental company has offices located across the continental USA. They would like to track the local address ( all pieces address, state, city, zip),and the contact phone number for that office location. They would also like information about employees working at that office including their names, date of birth, start of employment, contract phone number, and roles. Offices typically have more than one employee...
can someone please make a relational model and an ER diagram for the following scenario. P.s last person who made it, i couldnt read the words. I NEED IT AS SOON AS POSSIBLE PLEASE. Lets first start with the scenario, users register into the system and shares his some information as mentioned in the que. Some more information about themselves in their profile: what sort of job they do, something about their family, and what they like to watch on...
I need an OUTLINE ONLY (pseudocode/comments). DO NOT DO THE PROGRAMMING ASSIGNMENT. Part I: PA3 Outline (10 points). Create an outline in comments/psuedocode for the programming assignment below. Place your comments in the appropriate files: main.cpp, functions.h, dealer.cpp, dealer.h, dealer.cpp (as noted below). Place into a file folder named LastnamePA3, the zip the content and hand in a zip file to Canvas. Part II: PA3: Car Dealership (40 points) For Programming Assignment 3 you will be creating a program to...
Q1.a) Based on the business rules, you are expected to construct
an Entity-Relationship (ER) diagram. The ER diagram should include
entities, attributes (if there are less than three specified in the
business statements, please add some extra attributes), identifiers
and corresponding data types, the relationships among entities with
cardinality and associative entities.
.b) Extend Q1.a) to apply generalization/specialization
technique to construct an Enhanced-ER (EER) diagram. The EER
diagram should specify the complete (total) and disjoint
(mutuallyexclusive) constraints on the
generalization/specialization....
draw a conceptual model for the following information. The system needs to record details of all registered vehicles driven in the local government area. A vehicle is identified by a Vehicle Identification Number (VIN). Background reading on a VIN is available from several sites such as AutoCheck. The government wishes to record the type of vehicle, such as motorbike, car, truck etc, the year the vehicle was manufactured and the model such as CX3, as vehicle attributes. Vehicles are produced...
Requirements Create an Address Book class in Java for general use with the following behaviors: 1. Constructor: public Address Book Construct a new address book object. • A contact has four fields: first name, last name, email and phone. (There could be more information for a real contact. But these are sufficient for the assignment.) . The constructor reads from the disk to retrieve previously entered contacts. If previous contacts exist, the address book will be populated with those contacts...