Q1: ER modelling & logical design.
An information system is required for an online auction site, based on the following speci?cation:
Only registered users can use the site. Private users can either sell or bid, but commercial users are only allowed to sell via the site. Apart from user information, the database should also store information about items that are put up for sale. Customers can place a bid for an item or can cancel their bidding. They can also increase their previous offer. The database is meant to track all transactions and it is not intended to delete or modify previously entered data.
Develop an entity-relationship diagram annotated with multiplicities, and translate your design into SQL “CREATE TABLE” statements.

Posted Date: 2/23/2012 3:27:32 AM | Location : United States

Ask an Expert

Related Discussions:- Database, computer science, Assignment Help, Ask Question on Database, computer science, Get Answer, Expert's Help, Database, computer science Discussions

Write discussion on Database, computer science
Your posts are moderated

Write your message here..

Related Questions

Twisted pairs, Twisted Pairs: Twisted pairs are familiar to all of us ... Twisted Pairs: Twisted pairs are familiar to all of us as the copper wire telephone lines. These are of low frequency, and support a limited bandwidth (one voice channel) but

Discuss the anatomy of xml document, Question 1 What is web browser? List ... Question 1 What is web browser? List and explain the most common used web server Question 2 Discuss the anatomy of XML document Question 3 Discuss the various attr

What is the basic model of cpu structure?, As there are many variations i... As there are many variations in architecture between the different kinds of CPU, we shall begin my looking at an easy model of the structure. The basic model consists of five part

Q1, Write a half-page summary explaining IP spoofing. Write a half-page summary explaining IP spoofing.

C programming, a cloth merchant A cloth showroom has announced the followin... a cloth merchant A cloth showroom has announced the following seasonal discounts on purchase of items: Purchase amount Discount Mill items Handloom items 0-100 - 5% 101-200 5% 7.5%

Internet, how to get tamil information in internet how to get tamil information in internet

Distinguish between s-http and ssl, QUESTION (a) Distinguish between S... QUESTION (a) Distinguish between S-HTTP and SSL (b) What are the three basic security provided by SSL? (c) Discuss the limitations of SSL (d) State the port number us

Explain the role of it in bpr, Question 1. Explain the levels of managemen... Question 1. Explain the levels of management? Question 2. What are the advantages and disadvantages of DBMS Question 3. What are the advantages and disadvantages o

Define z-transform of sequence x[n], QUESTION (a) Define z-transform o... QUESTION (a) Define z-transform of sequence x[n]. (b) A causal LTI system has impulse response h[n], for which the z-transform is                     H(z) = (1+z -1

Data transmission, Data transmission: Most digital communication data i... Data transmission: Most digital communication data is transmitted in a serial form, that is, only one bit at a time. Transmission of data in serial form means each bit is tran