The following ER diagram describes a database about bands and their tours within
ID: 3674594 • Letter: T
Question
The following ER diagram describes a database about bands and their tours within the United States. A tour consists of a sequence of cities visited by a band. We assume that no city is visited twice on a single tour, and on one date, a band can visit only one city. Some of the entity sets are weak, and some of the relationships are supporting many-one relationships, but all double rectangles and double diamonds are not shown. Give the SQL CREATE TABLE statements needed to implement this database as a normalized set of relations. Clearly state any additional assumptions you make. date bandName city Name At Stops Stops Bands Cities On By In States Tours tourNumber stateNameExplanation / Answer
SQL CREATE TABLE statements needed to implement database about bands and their tours within the United States as a normalized set of relations----------------->
CREATE TABLE Cities (cityName varchar(255), stateName varchar(255));
CREATE TABLE Stops (tourNumber number(3), bandName varchar(255), cityName varchar(255), date date);
CREATE TABLE Bands (bandName varchar(255));
CREATE TABLE States (stateName varchar(255));
CREATE TABLE Tours (tourNumber number(3) NOT NULL, cityName varchar(255), bandName varchar(255), stateName varchar(255), date date, PRIMARY KEY (tourNumber));