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 AUTOINCREMENT,
Name VARCHAR NOT NULL,
BirthYear INT,
Nationality VARCHAR
;
CREATE TABLE Exhibitions
ExhibitionID INT PRIMARY KEY AUTOINCREMENT,
Title VARCHAR NOT NULL,
StartDate DATE NOT NULL,
EndDate DATE NOT NULL,
Location VARCHAR
;
CREATE TABLE Artworks
ArtworkID INT PRIMARY KEY AUTOINCREMENT,
Title VARCHAR NOT NULL,
ArtistID INT,
ExhibitionID INT,
CreationYear INT,
FOREIGN KEY ArtistID REFERENCES ArtistsArtistID
FOREIGN KEY ExhibitionID REFERENCES ExhibitionsExhibitionID
;
CREATE TABLE Visitors
VisitorID INT PRIMARY KEY AUTOINCREMENT,
Name VARCHAR NOT NULL,
Email VARCHAR
Phone VARCHAR
;
CREATE TABLE Tickets
TicketID INT PRIMARY KEY AUTOINCREMENT,
VisitorID INT,
ExhibitionID INT,
PurchaseDate DATE,
FOREIGN KEY VisitorID REFERENCES VisitorsVisitorID
FOREIGN KEY ExhibitionID REFERENCES ExhibitionsExhibitionID
;
DROP DATABASE ArtExhibitionTourDB;
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
