Consumer First Name Last Name Age Gender online/instore Online Retailer Website Name Online Promotions Customer Reviews In-Store Retailer Store Name Store Layout Discounts In-Store Retailer Product Name Brand price Consumer In-store Retailer Online Retailer Product
IN detail explain each digram
(a) Description of each table
(b) Display of each table itself immediately after it is described
(5) Use the SQL already built to demonstrate use of the following SQL
statements:
(a) Updating one record from each table.
(b) Performing a calculation in at least one table and store the results
of the calculation as an alias.
(c) Linking a set of tables together to demonstrate the use of a JOIN.
(d) Creating at least one two level SELECT structure.
(e) Creating one multiple table query useful to your specific project.
PROJECT ANALYSIS
Keys
Consumer:
- Primary key: ConsumerID
In-Store Retailer:
- Primary key: InStoreID
- No foreign keys
Online Retailer:
- Primary key: OnlineRetailerID
Product:
- Primary key: ProductID
Entities:
Consumer
In-Store Retailer
Online Retailer
Product
Attributes:
Consumer:
FirstName
LastName
Age
Gender
Online/In-store
In-Store Retailer:
Store Name
Store Layout
Discounts
Online Retailer:
Website name
Online Promotions
Customer Reviews
Product:
Product Name
Brand
Price
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution