(Solved) : 1 Please Read Business Statement Draw Er Ner Table Schema Diagrams Business Statement Pro Q44066662 . . .
1. Please read the business statement below and draw ER, NER,and Table Schema diagrams for it.
Business Statement:
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 itemsin this Web site. Buyers are people who like to buy items, andsellers are people who like to sell items. Each seller can sellitems
. Each item has a bidding start time, an end time, and anowner. Sellers are owners of their item. The start time and endtime include the date as well.
Each seller has a name, contact information, and credit cardinformation. They also have a user name and a password.
Contact information consists of an address, an email, and atelephone.
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, adescription, quantity, one or more pictures, and an owner.
The condition could be New, Refurbished, or Explained. If thecondition of an item is set to Explained, the seller should explainabout the item condition in the item description.
Each buyer has a name, contact information, and credit cardinformation. They also have a user name and a password.
When buyers’ login to Web site, they can go to the list of allavailable items and then go to the item detail page. Buyers canalso search for an item. The application will search through itemnames for the search phrase.
Buyers can bid on items. Once a bid is made, buyers areaccountable for their bid. In other words, buyers cannot simplyremove their bid. If they change their mind, all they can do is toupdate their bid with the price of zero. Of course, they can dothat before the auction expires.
After an auction expires, the buyer with the highest bid isthe winner.
2. Please write SQL Query for each statement below.
BA likes to have a set of statistics about the system asfollows:
The most active seller (the one who has offered the mostnumber of items)
The most active buyer (the one who has bought the most numberof items)
The most expensive item sold ever
The most expensive item available
The cheapest item sold ever
The cheapest item available
Expert Answer
Answer to 1. Please read the business statement below and draw ER, NER, and Table Schema diagrams for it. Business Statement: The …
OR