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 tables. The first table will be called user and the collumns or attributes will be useridPK username, address, phone, and email. The next table is called login and the collumns will be useridPK password. The next table is called product and the collumns will be productid name, description, category, owner, price, image. The next table is called cart and the collumns will be useridPK productid quantity. The next table is called shipping and the collumns will be useridPK address. The next table is called payment and collumns will be useridPK cardnum, cardholdername, securitykey, billing address, date of birth. The last table is called purchasehistory and the collumns will be useridPK productid quantity, orderdate, transactioncost 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
