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 e-commerce 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 Database*/CREATE DATABASE OldNewGenGamingCenter;/*Use the Database*/USE OldNewGenGamingCenter;/*Create Table for users*/CREATE TABLE Users (UserID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(255) NOT NULL UNIQUE,Gender ENUM('m','f','o')EmailAddress VARCHAR(255),UserPassword VARCHAR(255) NOT NULL, Address VARCHAR(255), PhoneNumber VARCHAR(255),ShippingAddress VARCHAR (255),CreditCardNumber VARCHAR(255),CreditCardExpirationDate DATE);CREATE TABLE Games (VideoGameID INT PRIMARY KEY,VideoGameName VARCHAR(255),PictureLink VARCHAR(255);Genre VARCHAR(255), EsrbRating VARCHAR(255),GameAge VARCHAR(255),Price DECIMAL(10,2));CREATE TABLE consoles (ConsoleID INT PRIMARY KEY, ConsoleName VARCHAR(255),ConsoleAge VARCHAR(255),ConsolePrice DECIMAL(10,2));CREATE TABLE QuantityonHand( VideoGameID INT,Quantity INT, PRIMARY KEY (VideoGameID),FOREIGN KEY (VideoGameID) REFERENCES Games(VideoGameID));CREATE TABLE Orders (OrderID INT AUTO_INCREMENT PRIMARY KEY,CustomerID INT,TotalWeight DECIMAL (10,2),TotalPrice DECIMAL (10,2),ShippingCharge DECIMAL (10,2),Date DATE,Status VARCHAR (50),FOREIGN KEY (CustomerID) REFERENCES Users (UserID));CREATE TABLE OrderDetails (OrderID INT, VideoGameID INT, Quantity INT,Price DECIMAL (10,2),PRIMARY KEY (OrderID, VideoGameID),FOREIGN KEY (OrderID) REFERENCES Orders(OrderID),FOREIGN KEY (VideoGameID) REFERENCES Games(VideoGameID));CREATE TABLE Inventory ( VideoGameID INT PRIMARY KEY, Name VARCHAR(255), Description VARCHAR(255), PartNumber INT, QuantityOnHand INT, FOREIGN KEY (VideoGameID) REFERENCES Games (VideoGameID));CREATE TABLE ShippingHandlingCharges ( WeightBracket INT PRIMARY KEY, Charge DECIMAL (10,2));INSERT INTO `games`(`VideoGameID`,`VideoGameName`,`PictureLink`,`Genre`,`EsrbRating`,`GameAge`,`Price`) VALUES(1001, 'Devil May Cry 5', 'DevilMayCry5.jpg', 'hack & slash and action-adventure', 'M Rating', '5y','39.99'),(1002, 'fate samurai remnant', 'FateSamuraiRemnant.jpeg', 'action RPG', 'Teen Rating', '1y','59.99'),(1003, 'wii sports resort', 'WiiSportsResort.jpg', 'sports simulation', 'E','15y','30.99'); INSERT INTO `consoles`(`ConsoleID`,`ConsoleName`,`ConsoleAge`,`ConsolePrice`) VALUES(2001, 'Play Station 5','3y','409.00'),(2002, 'xbox series x','3y','499.99'),(2003, 'wii console', '18y','149.99'); INSERT INTO `inventory`(`VideoGameID`,`Name`,`Description`,`PartNumber`,`QuantityOnHand`) VALUES(1001, 'Devil May Cry 5', 'hack & slash and action-adventure', 1001,150),(1002, 'fate samurai remnant', 'action RPG',1002,60),(1003, 'wii sports resort', 'sports simulation', 1003,25); INSERT INTO `quantityonhand`(`VideoGameID`,`Quantity`) VALUES(1001,150),(1002,60),(1003,25); INSERT INTO `shippinghandlingcharges`(`WeightBracket`,`Charge`) VALUES(1,'5.00'),(2,'5.25'),(3,'5.45');

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 Accounting Questions!