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

Pitfals, what is CAI what is CAI

Understanding human intelligence in social, Understanding human intelligenc... Understanding human intelligence in social AI can be taken as just the current tool in the philosopher's toolbox for answering of questions for the behaviour of human intellig

Threading Module of python, The latest threading module comprised with Pyth... The latest threading module comprised with Python 2.4 provides much more powerful, high-level hold for threads than the old thread module. The threading module depictions all the m

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

Network, Give a topology (network diagram) in which there is a link whose f... Give a topology (network diagram) in which there is a link whose failure will change many routes. Give one in which there is a link whose failure will not change any routes

Management information system, suggest 5 ways by which new products and ser... suggest 5 ways by which new products and services can be developed using management information system

Explain popular way commonly used to evaluate interfaces, Question: Usi... Question: Using a questionnaire is a popular way commonly used to evaluate interfaces. (a) Describe advantages of using questionnaires as a means to evaluate interfaces.

Flowcharts, what is a dry running of flow chart? what is a dry running of flow chart?

Help with this question, In a certain word game a player can buy vowels and... In a certain word game a player can buy vowels and consonants. The first vowel is free; each additional vowel cost $1. The first two consonants are free; each additional constant c

Types of pc, TYPES OF PC:  In general,  basic function of all the comp... TYPES OF PC:  In general,  basic function of all the computers is same i.e. Computers accept data as input, perform operations on these data and generates the desired output t