Please i need help with this assigment Turning the ERD into tables. You may choo
ID: 3589038 • Letter: P
Question
Please i need help with this assigment
Turning the ERD into tables. You may choose your implementation details.
Be sure to use foreign key constraints and unique where necessary.
Be sure to explain your choices.
Order users User userid Order Date and Time First Name Last Name Street Address City State zip PhoneNumber Accepts Text Order History Location City Location Zip Location Phone Number Menu Item Menu Description Menu Price Quantity Subtotal Tax is created by Creates Total Promo Payment Info Type Card Number Name on Card Expiration date Security Code Consists of is order on Menu Menu Item Name Menu Item Description selects Menu Item Size Is selected by Allergen InfoExplanation / Answer
Users(userid (PK) ,email,password,firstname, lastname,streetaddress,city, state,zip,phonenumber, accepttext,orderhistory)
Order(userid,locationid,menuitemid,cardnumber,(PK,FK) , orderdate,billingzipmquantity,subtotal,tax,tip,total)
Location(locationid (PK),city,zip,phonenumber)
MenuItem(menuitemid (PK) , itemname,description,price,size,allergeninfo)
Card(cardnumber,name,expirationdate,securitycode)
underlined are primary keys(unique and not null ) and italicised are foreign keys. Some attributes are both.