Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The database, for your company in Project 1, needs to keep track of the details of the customers: last name, rst name, customer id, street

image text in transcribed
The database, for your company in Project 1, needs to keep track of the details of the customers: last name, rst name, customer id, street address, customer star rating (a rating on a 1.0 5.0 scale, with 5.0 being best, representing the type of customer) and phone number. It also needs to keep track of similar information for suppliers as well (although instead of supplier rst and last name, there will just be a supplier company name). It should maintain the products that are offered. Information about which product is offered by which supplier should also be maintained. Finally, which customers have purchased which products should also be tracked (note that we are only interested in which customers bought which product, but not worried about the date or how many were bought). Note that you will need to determine which data should reside in which tables. Make sure you are marking the relationships correctly

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_2

Step: 3

blur-text-image_3

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

Small Business Management Entrepreneurship and Beyond

Authors: Timothy s. Hatten

5th edition

538453141, 978-0538453141

More Books

Students also viewed these General Management questions

Question

Repeat Problem 6.22 for 2-methyl-2-butene.

Answered: 1 week ago