Database Systems

NEED TO DO PART 2 ( PART 1 DONE) The project is about developing an auction Web site. The details are as follows:
BA is an online auction Web site. People can buy and sell items in this Web site. Buyers are people who like to buy items, and sellers are people who like to sell items.Each seller can sell items.
Each item has a bidding start time, an end time, and an owner. Sellers are owners of
their item. The start time and end time include the date as well.
Each seller has a name, contact information, and credit card information. They also have a user name and a password.
Contact information consists of an address, an email, and a telephone.
An address consists of a street number and name, city, state, and zip code.
Credit card information consists of owner name, card number, and expiration date.
Each item has a name, condition, an initial price, a description, quantity, one or more pictures, and an owner.
The condition could be New, Refurbished, or Explained. If the condition of an item is set to Explained, the seller should explain about the item condition in the item description.
Each buyer has a name, contact information, and credit card information. They also have a user name and a password.
When buyers login to Web site, they can go to the list of all available items and then go to the item detail page. Buyers can also search for an item. The application will search through item names for the search phrase.
Buyers can bid on items. Once a bid is made, buyers are accountable for their bid. In other words, buyers cannot simply remove their bid. If they change their mind, all they can do is to update their bid with the price of zero. Of course, they can do that before the auction expires.
After an auction expires, the buyer with the highest bid is the winner.Part 2: Please write SQL Query for each statement below.
• BA likes to have a set of statistics about the system as follows:The most active seller (the one who has offered the most number of items)
The most active buyer (the one who has bought the most number of items)
The most expensive item sold ever
The most expensive item available
The cheapest item sold ever
The cheapest item availableYou need to create tables, insert at least 3 records for each one, and then run the queries.
Approximate price: $22
We value our customers and so we ensure that what we do is 100% original..

With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.