AIMS AND OBJECTIVES:
to represent a problem description given in natural language as an (Enhanced) Entity-Relationship model;
to convert the ER/EER model into a relational data model;
to implement a relational database system (using ORACLE11g).
You are required to develop an EER model for the above problem description. The EER should contain all necessary information such as entities, attributes, primary keys, relationships (including specialization/generalization if any), cardinalities, and participation (including (min, max)). Any assumptions should also be stated clearly. If assumptions are made, it is important to make sure that the assumptions reflect the real practice in the online auction industry and do not contradict with the problem description above. Note that in this task you are required to do a Top-Down approach of database design, you can use the figures/tables in the attachment to extract attribute names.
Transform the ER/EER model to the Relational tables, making sure you show all the steps. The final set of tables should contain necessary information such as table names, attribute names, primary keys and foreign keys.
1. E-R diagram for the given project
2. Converting the E-R diagram into data modeling diagram along with database & table creation.
3. Inserting real data into tables.
4. Creating forms for Bidder, Seller and other user of the site.
Hey, I am a new graduate and I used to study database. I think this project is just like an assignment in university. I can do it in 2 days but I think 3 days for the sake of quality.
I had some experience in handling of 2 projects relating to Oracle and database. Hope to work with you.