Database Systems

NEED TO DO PART 2 ( PART 1 DONE)  The activity is about developing an bargain Web site. The capacity are as follows: BA is an online bargain Web site. Bodies can buy and advertise items in this Web site. Buyers are bodies who like to buy items, and sellers are bodies who like to advertise items. Each agent can advertise items. Each account has a behest alpha time, an end time, and an owner. Sellers are owners of their item. The alpha time and end time accommodate the date as well. Each agent has a name, acquaintance information, and acclaim agenda information. They additionally accept a user name and a password. Contact advice consists of an address, an email, and a telephone. An abode consists of a artery cardinal and name, city, state, and zip code. Credit agenda advice consists of client name, agenda number, and cessation date. Each account has a name, condition, an antecedent price, a description, quantity, one or added pictures, and an owner. The action could be New, Refurbished, or Explained. If the action of an account is set to Explained, the agent should explain about the account action in the account description. Each client has a name, acquaintance information, and acclaim agenda information. They additionally accept a user name and a password. When buyers login to Web site, they can go to the account of all accessible items and again go to the account detail page. Buyers can additionally chase for an item. The appliance will chase through account names for the chase phrase. Buyers can bid on items. Once a bid is made, buyers are answerable for their bid. In alternative words, buyers cannot artlessly abolish their bid. If they change their mind, all they can do is to amend their bid with the amount of zero. Of course, they can do that afore the bargain expires. After an bargain expires, the client with the accomplished bid is the winner. Part 2: Please address SQL Query for anniversary account below. • BA brand to accept a set of statistics about the arrangement as follows: The best alive agent (the one who has offered the best cardinal of items) The best alive client (the one who has bought the best cardinal of items) The best big-ticket account awash ever The best big-ticket account available The cheapest account awash ever The cheapest account available You charge to actualize tables, admit at atomic 3 annal for anniversary one, and again run the queries.

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
Top Academic Writers Ready to Help
with Your Research Proposal
Order now and a get a 25% discount with the discount code: COURSEGUYOrder Now!
+ +