Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 Recreational Vehicle Sales Gofat Travel Vehicles sells new and used recreational vehicles. When new vehicles arive at Gofar Travel Vehicles from the manufacturer, a

image text in transcribed
image text in transcribed
1 Recreational Vehicle Sales Gofat Travel Vehicles sells new and used recreational vehicles. When new vehicles arive at Gofar Travel Vehicles from the manufacturer, a new vehicle record is created Included in the new vehicle record is the following information: vehicle identification number (VIN) name . model year name of manufacturer . cost or amount paid to the manufacturer When a customer arrives at Gofer Travel Vehicles, heishe works with a salesperson to discuss a vehicle purchase The customer can purchase a new or used vehicle new vehicle the customer can add options like a microwave, special lighting, fridge, stove, better seats etc. A It is mandatory that a new recreation vehicle have options added B. The relationship between salesperson and customer is one to many C. A vehicle purchase is made by one customer D. The Sales invoice does not need to be an entity because it is a summary of the purchase information, as well as 2. Retail Sales model stipulates A Customer can hate zero, one or many Customer Sales Every Customer Sale must be associated with a valid Customer. A Custonner Sale is always associated with one Payment Method. A Customer Sale can have one or many Products An In-Store Purchase is always associated with a member of Staff A The relstionship betiween Customer and Customer Sale is one to many, optional B. A sale can have many Payment Methods C. It is mandatory that a Customer Sale have at least one Product D. Customer has a status attribute 3|Given this model of an Itera in a category, parchased from a gendox a answer the questions about the eatities and their A An item can be purchased from many vendors B. A category can bave zero to many items it classifies C. The Item UPC is a foreign key to the vendor UPC D. An iten has more than one category code 747 words English (United States)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions

Question

What is an industry?

Answered: 1 week ago

Question

What is Change Control and how does it operate?

Answered: 1 week ago

Question

How do Data Requirements relate to Functional Requirements?

Answered: 1 week ago