Answered step by step
Verified Expert Solution
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)
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started