MYWEDB
MyWebDB Database XXXXXXXXXX
XXXXXXX XXXX
University
Introduction
XXXX XXXX XXXXXXXXX XXX XXX statement of designing XXX tables XXX XXXXXXXXX the relationships XX XXXXX XXXXXXX XXXX and XXXXXXX XXXX. XXX XXXX is XXXX using XXXXX XXXXXX.
XXXXXXXX
DROP XXXXXXXX MyWebDB;
CREATE DATABASE XXXXXXX;
USE XXXXXXX;
CREATE XXXXX Users
(
UserID INT XXX XXXX,
EmailAddress VARCHAR(100),
XXXXXXXXX VARCHAR(50),
LastName XXXXXXX(XX),
XXXXXXX KEY(UserID)
);
CREATE TABLE Products
XXXXXXXXX INT NOT XXXX,
XXXXXXXXXXX VARCHAR(255),
PRIMARY XXX (XXXXXXXXX)
CREATE TABLE Downloads
DownloadID INT XXX NULL,
UserID XXX,
XXXXXXXXXXXX XXXX,
FileName XXXXXXX(255),
ProductID XXX,
PRIMARY KEY (DownloadID),
XXXXXXX KEY (XXXXXX) XXXXXXXXXX Users (UserID),
FOREIGN KEY (ProductID) XXXXXXXXXX XXXXXXXX (XXXXXXXXX)
Images Not Shown
Index can be build on XXXXXX and ProductID XXX faster XXXXXXXXX XX XXXX if XXXXX XX slowness while XXXXXXXX data
CREATE XXXXX User_Product ON XXXXXXXXX (XXXXXX, XXXXXXXXX ) ;