Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For each item that userNum pxtfj044 has bid on, report the itemID, the number of different bids (total number of bids made by all users)

image text in transcribed

For each item that userNum pxtfj044 has bid on, report the itemID, the number of different bids (total number of bids made by all users) made on it, and the highest value bid. Name the columns itemID, number of bids, and highest bid.

Auction database. In the database schema described below, the primary key for each relation is the set of underlined attributes shown. Users (userNum, email, name, address, phone) Items (itemID, seller Num, category, title, description, startPrice, startDate, endDate) Bids (itemID, buyerNum, bid Time, amount) Feedback (itemID, sellerNum, buyerNum, date, rating, comment) Many relations and attributes in the schema above are self-explanatory, but we provide the following clarifications. The seller Num attribute in the Items and Feedback relations and the buyerNum attribute in the Bids and Feedback relations reference the user Num attribute in the Users relation. In the Bids and Feedback relations, the attribute itemID references the itemID attribute in Items. The startDate and endDate attributes in the Items relation, and the bid Time attribute in the Bids relation are defined as values of the type DATETIME in mySQL. In the Feedback relation, the rating attribute is an integer ranging from 1 to 5, inclusive, where higher values are more positive. The comment attribute is an open-ended text field

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

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Eric Redmond ,Jim Wilson

1st Edition

1934356921, 978-1934356920

More Books

Students also viewed these Databases questions