Week 5 – Data Management Research Paper

A data base for e-Commerce games web site

The entities for supertype

· Products

The entities that are subtype

· Games

· Consoles

· Accessories

The attributes which are inherited from supertypes

In this data base all the subtypes will inherit the following attributes from the supertype

· Product _id

· Product_Description

· Product_name

· Product_price

The attributes that are unique in every subtype

In subtype Games

· Games_name

· Memory_required

· Number_of_players

· Other_game_details

Consoles subtype

· Drive_type

· Size

· Other_console_details

Accessories subtype

· Accessory_name

· Accessory_description

· Other_accessory_details