DATABASE FUNDAMENTALS

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.