Question: Can you randomly draw an ER diagram with this SQL Script. CREATE DATABASE ArtExhibitionTourDB; USE ArtExhibitionTourDB; CREATE TABLE Artists ( ArtistID INT PRIMARY KEY AUTO

Can you randomly draw an ER diagram with this SQL Script.
CREATE DATABASE ArtExhibitionTourDB;
USE ArtExhibitionTourDB;
CREATE TABLE Artists (
ArtistID INT PRIMARY KEY AUTO_INCREMENT,
Name VARCHAR(100) NOT NULL,
BirthYear INT,
Nationality VARCHAR(50)
);
CREATE TABLE Exhibitions (
ExhibitionID INT PRIMARY KEY AUTO_INCREMENT,
Title VARCHAR(100) NOT NULL,
StartDate DATE NOT NULL,
EndDate DATE NOT NULL,
Location VARCHAR(100)
);
CREATE TABLE Artworks (
ArtworkID INT PRIMARY KEY AUTO_INCREMENT,
Title VARCHAR(100) NOT NULL,
ArtistID INT,
ExhibitionID INT,
CreationYear INT,
FOREIGN KEY (ArtistID) REFERENCES Artists(ArtistID),
FOREIGN KEY (ExhibitionID) REFERENCES Exhibitions(ExhibitionID)
);
CREATE TABLE Visitors (
VisitorID INT PRIMARY KEY AUTO_INCREMENT,
Name VARCHAR(100) NOT NULL,
Email VARCHAR(100),
Phone VARCHAR(15)
);
CREATE TABLE Tickets (
TicketID INT PRIMARY KEY AUTO_INCREMENT,
VisitorID INT,
ExhibitionID INT,
PurchaseDate DATE,
FOREIGN KEY (VisitorID) REFERENCES Visitors(VisitorID),
FOREIGN KEY (ExhibitionID) REFERENCES Exhibitions(ExhibitionID)
);
DROP DATABASE ArtExhibitionTourDB;

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