Database Creation

Database Normalization.vsdx

inventory order cart_detail payment shopping_cart user_account address user_session credit card item_number int FK PK title int FK PK int FK PK timestamp int FK PK order_id int FK PK quantity int FK PK item_number int FK PK cart_id int FK PK timestamp int FK PK quantity int FK PK item_number int FK PK payment_number int FK PK amounht int FK PK state int FK PK price int FK PK M1 M2 M3 M4 timestamp int FK PK account_number int FK PK cart_number int FK PK active_status int FK PK expiring_date int FK PK item_number int FK PK account_number int FK PK user_number int FK PK account_number int FK PK user_id int FK PK tunestamp int FK PK visits int FK PK transaction_number int FK PK address_number int FK PK credit_card_number int FK PK M1 M2 M3 M4 address_number int FK PK name int FK PK address_1 int FK PK address_2 int FK PK city int FK PK state int FK PK zip_code int FK PK M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 session_number int FK PK ip_address int FK PK number_of_clicks int FK PK timestamp int FK PK user_account_number int FK PK M1 M2 M3 M4 card_id int FK PK card_number int FK PK holder_name int FK PK expiring_date int FK PK M1 M2 M3 M4