Requirement Analysis (15%)

Identify and examine three different websites which offer an on-line purchasing facility. Look particularly at the interactive pages used for the purchasing function and from these list all the fields that have to be completed by the purchaser for each site. (Note that you do not have to limit yourself to data-entry fields, for higher marks analyse the websites for other possible entities and attributes.) From your three sets of attributes, produce one generic list.

-       Identifying 3 proper websites (1)

-       Identifying attributes from chosen website (2x3 = 6)

-       Common/Generalised list (with additional attributes if any) (4)

-       Evidence of Requirement analysis and extra excellence (4)

[Higher marks will be awarded for an extensive list of attributes including self-suggested entities and attributes i.e. hidden entities and attributes that can benefit an e-commerce system]

Modelling / Design (25%)

From this generic list, construct an Extended Entity Relationship (EER) diagram for a database that would support an on-line purchasing facility. Construct a supporting Table Schema. Explain your thinking, and any assumptions made in this process.

EERD (15)

Where

-       For a basic EERD with proper entities and attributes and multiplicity (up to 6)

-       For extended features (up to 4)

-       For normalised EERD (up to 5)

Explanation of Normalisation (05)

Schema (keys and data types) (05)

Implementation (10%) 

Using the software provided, build tables to represent the entities from the Table Schema. Invent data to represent stock for the tables created. Insert six records into each table. Provide screen dumps of all the CREATE TABLE statements and the completed tables with data.