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

What are anti-patterns, QUESTION Developers spend much more time extend... QUESTION Developers spend much more time extending and changing code than they did originally while developing it. (a) As a team leader, illustrate how you will introduce to

Respiratory system, 100 animals and their respiratory organs 100 animals and their respiratory organs

Optical mark recognition, Optical Mark Recognition (OMR): OMR is the s... Optical Mark Recognition (OMR): OMR is the scanning of paper to detect the presence or absence of a mark in a predetermined position. Now days, it is used as an input device f

Java, function of void function of void

Pitfals, what is CAI what is CAI

Magnetic media, what are the five precautions to be observed when handling ... what are the five precautions to be observed when handling magnetic media?

Data structure, #question.a tree has 0 off springs at each node. if it had ... #question.a tree has 0 off springs at each node. if it had a label L, what will be the maximum number of nodes that the tree can have. only an expression involving the number of no

Definition of procedure, A procedure is a compilation of instructions to wh... A procedure is a compilation of instructions to which we can express the flow of our program, and once the execution of these instructions is over power is given back to the next l

Cipher program in java, Cryptography, the study of secret writing, has been... Cryptography, the study of secret writing, has been around for a very long time, from simplistic techniques to sophisticated mathematical techniques. No matter what the form howeve

Project help required!, im student of BSCS 1st semester and I have to make ... im student of BSCS 1st semester and I have to make project for IT fair and I dont know computer that very much so please I required your help, help me if you can. thanks