Question: design an e - commerce website that sells old and new video games and allows users to download games to their PC . Use HTML
design an ecommerce website that sells old and new video games and allows users to download games to their PC Use HTML CSS and PHP to construct the website. user the following database SQL to program the website:Create the DatabaseCREATE DATABASE OldNewGenGamingCenter;Use the DatabaseUSE OldNewGenGamingCenter;Create Table for usersCREATE TABLE Users UserID INT AUTOINCREMENT PRIMARY KEY, Name VARCHAR NOT NULL UNIQUE,Gender ENUMmfoEmailAddress VARCHARUserPassword VARCHAR NOT NULL, Address VARCHAR PhoneNumber VARCHARShippingAddress VARCHAR CreditCardNumber VARCHARCreditCardExpirationDate DATE;CREATE TABLE Games VideoGameID INT PRIMARY KEY,VideoGameName VARCHARPictureLink VARCHAR;Genre VARCHAR EsrbRating VARCHARGameAge VARCHARPrice DECIMAL;CREATE TABLE consoles ConsoleID INT PRIMARY KEY, ConsoleName VARCHARConsoleAge VARCHARConsolePrice DECIMAL;CREATE TABLE QuantityonHand VideoGameID INT,Quantity INT, PRIMARY KEY VideoGameIDFOREIGN KEY VideoGameID REFERENCES GamesVideoGameID;CREATE TABLE Orders OrderID INT AUTOINCREMENT PRIMARY KEY,CustomerID INT,TotalWeight DECIMAL TotalPrice DECIMAL ShippingCharge DECIMAL Date DATE,Status VARCHAR FOREIGN KEY CustomerID REFERENCES Users UserID;CREATE TABLE OrderDetails OrderID INT, VideoGameID INT, Quantity INT,Price DECIMAL PRIMARY KEY OrderID VideoGameIDFOREIGN KEY OrderID REFERENCES OrdersOrderIDFOREIGN KEY VideoGameID REFERENCES GamesVideoGameID;CREATE TABLE Inventory VideoGameID INT PRIMARY KEY, Name VARCHAR Description VARCHAR PartNumber INT, QuantityOnHand INT, FOREIGN KEY VideoGameID REFERENCES Games VideoGameID;CREATE TABLE ShippingHandlingCharges WeightBracket INT PRIMARY KEY, Charge DECIMAL ;INSERT INTO gamesVideoGameIDVideoGameNamePictureLinkGenreEsrbRatingGameAgePrice VALUES 'Devil May Cry 'DevilMayCryjpg 'hack & slash and actionadventure', M Rating', y 'fate samurai remnant', 'FateSamuraiRemnant.jpeg', 'action RPG 'Teen Rating', y 'wii sports resort', 'WiiSportsResort.jpg 'sports simulation', Ey; INSERT INTO consolesConsoleIDConsoleNameConsoleAgeConsolePrice VALUES 'Play Station y 'xbox series xy 'wii console', y; INSERT INTO inventoryVideoGameIDNameDescriptionPartNumberQuantityOnHand VALUES 'Devil May Cry 'hack & slash and actionadventure', 'fate samurai remnant', 'action RPG 'wii sports resort', 'sports simulation', ; INSERT INTO quantityonhandVideoGameIDQuantity VALUES; INSERT INTO shippinghandlingchargesWeightBracketCharge VALUES;
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
