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

Database, how does one create a database in mysql how does one create a database in mysql

Which port does FTP uses, Why is it called out of band protocol? A1) FTP us... Why is it called out of band protocol? A1) FTP uses port 20 and port 21; port 20 is used for data connection, whereas port 21 is used for control connection. FTP is known as out-of

What are the most common forms of mixing, Question 1 What is the differenc... Question 1 What is the difference between Variable Bit Rate and Constant Bit Rate? Question 2 Write a note on: Normalization, Reverberation, Noise Reduction, Filters, and

ICT IN BUSINESS, Explain how ICT can be used for achievement of each of the... Explain how ICT can be used for achievement of each of the following business objectives, illustrating your answer with examples: 1. Customer intimacy 2. Low-cost leadership

Discuss the challenges in it infrastructure management, Question 1 What is... Question 1 What is difference between cathode ray tube monitors and LCD monitors? List three popular types of operating systems and give brief introduction of each type Que

Define jumps and loops , The unconditional jumps in a written program in a... The unconditional jumps in a written program in assembler language are specified by the jmp instruction; a jump is to moves the flow of the execution of a program by sending the co

Write separate programs for each of the above points, Question 1 Describe ... Question 1 Describe the following with respect to creating Web Forms in .Net environment- Web Form Life Cycle Creating a Web Form Write programs with corresponding

Logic gates:truth table, truth table:x^yvz truth table:x^yvz

Operating system, Does Process Manager in Operating System know the depende... Does Process Manager in Operating System know the dependency order that Process A depends on Process B?

Determine whether the system is stable or causal, QUESTION (a) For each... QUESTION (a) For each of the following systems, determine whether the system is (1) stable, (2) causal, (3) linear, (4) time invariant, (5) passive (i) Y[n] = x[-n] (ii)