Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please hurry!!! Create a NER diagram from the directions below and the provided ER diagram. Thank you! City Pictures Addess) ial Price Expiraton Date Condson

please hurry!!! Create a NER diagram from the directions below and the provided ER diagram. Thank you!
image text in transcribed
image text in transcribed
City Pictures Addess) ial Price Expiraton Date Condson ) Owne Sreet Nunber Owners Name Aderess Expraton Dale Credit Car Places Part I: 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 includoe 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 - Credit card information consists of owner . Each item has a name, condition, an initial name, city, state, and zip code. name, card number, and expiration date. 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, buvers 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 . After an auction expires, the buyer with the highest bid is the winner

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MySQL/PHP Database Applications

Authors: Brad Bulger, Jay Greenspan, David Wall

2nd Edition

0764549634, 9780764549632

More Books

Students also viewed these Databases questions

Question

What are three ways that chemical mixtures interact?

Answered: 1 week ago

Question

11. Identify the stage of beyond duality in Gone With the Wind.

Answered: 1 week ago