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

Programs, creating programs in scheme creating programs in scheme

Database management, Suppose you are designing a database for an art museum... Suppose you are designing a database for an art museum that owns a large volume of works of art. Each work of art is described by a unique item code, a title, a type, and a size. T

Outdoor patient department features - a patient registry, A Patient Regist... A Patient Registry Name, Surname and Address  Sex  Caste  Contact Numbers  Area (Rural/Urban/Suburban)  City/District  State  General Examination deta

Describe circuit switching and message switching, Question 1 List the Basi... Question 1 List the Basic essential components of a computer network Question 2 What are the functions of (i) Routers (ii) Bridges Question 3 What are the advantag

#title., what is input and output device? explain meaning of input and outp... what is input and output device? explain meaning of input and output devices

Write a detailed note on colour balance, Question 1 Write a long note on s... Question 1 Write a long note on setting up a typical on-location News Interview Question  2 Write a long note on how to work with presenters Question 3 Write long notes

Search strategy-artificial intelligence, Search strategy-artificial intelli... Search strategy-artificial intelligence: Soundness: You  can hear  in  some  application domains  -  i.e.  automated  theorem proving - that a search is "sound and complet

Central processing unit, Central Processing Unit Microprocessor Th... Central Processing Unit Microprocessor The microprocessor is an important component in the CPU. It is the unit which processes the instructions depending on its capability

String problem, c program to convert S to palindromes with minimum number o... c program to convert S to palindromes with minimum number of character replacements

Sma* search - artificial intelligence, SMA* Search-Artificial intelligence ... SMA* Search-Artificial intelligence IDA* search is good from a memory point of view. actually it may  be criticised for not using enough memory - utilizing  more memory may inc