Question: Hey im trying to create a an sql . There will be 7 tables. The first table will be called user and the collumns or

Hey im trying to create a an sql. There will be 7 tables. The first table will be called user and the collumns or attributes will be user_id(PK), username, address, phone, and email. The next table is called login and the collumns will be user_id(PK), password. The next table is called product and the collumns will be product_id, name, description, category, owner, price, image. The next table is called cart and the collumns will be user_id(PK), product_id, quantity. The next table is called shipping and the collumns will be user_id(PK), address. The next table is called payment and collumns will be user_id(PK), card_num, cardholder_name, security_key, billing address, date of birth. The last table is called purchase_history and the collumns will be user_id(PK), product_id, quantity, order_date, transaction_cost. Owner is the fk of product and username is the fk of login.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!