Draw er and table schema diagrams for given statement

Assignment Help Database Management System

Reference no: EM132472512

Assignment: Part 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 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 available

Reference no: EM132472512

Questions Cloud

What is the variable costing net operating income : What is the variable costing net operating income in Year 1 and in Year 2? Using variable costing, what is the unit product cost for both years?

What the variable factory overhead controllable variance : Determine the variable factory overhead controllable variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance

What is the value for other comprehensive net income : If the company has treasury stock, is it increasing or decreasing in value? Remember that the normal balance for treasury stock is a negative value

MITS6011 Advanced Research Topics in Information Technology : MITS6011 Advanced Research Topics in Information Technology Assignment Help and Solution, Victorian Institute of Technology - Assessment Writing Service

Draw er and table schema diagrams for given statement : Please read the business statement below and draw ER, NER, and Table Schema diagrams for it. The project is about developing an auction Web site.

How much money should be for total contribution margin : Susie Ques Inc, a company that produces, If the company sells 5,800 units, its total contribution margin should be how much money?

Discuss a well known public incident response : Research and discuss a well known public incident response or data breach to include how the system was compromised and how the problem was remediated.

Compute the order point : Determine the most economical order quantity by use of the EOQ formula (round to the nearest whole unit).Determine the most economical order quantity

Find the probability of spinning a green number : A roulette wheel has 38 numbers: 18 odd black numbers from 1 to 35, 18 even red numbers from 2 to 36, and the two green numbers 0 and 00. Using theoretical.

User Account

All Pages