Make an ER diagram using my SQL code below, User table CREATE TABLE User ( user_id INT

Make an ER diagram using my SQL code below,

   

Transcribed Image Text:

User table CREATE TABLE User ( user_id INT PRIMARY KEY, username VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL -- ); -- Teams table CREATE TABLE Teams ( team_id INT PRIMARY KEY, team_name VARCHAR(50) NOT NULL, user_id INT NOT NULL, FOREIGN KEY (user_id) REFERENCES User(user_id) ); -- Players table CREATE TABLE Players ( player_id INT PRIMARY KEY, player_name VARCHAR(50) NOT NULL, position VARCHAR(50) NOT NULL, team VARCHAR(50) NOT NULL ); -- Fantasy League Teams table CREATE TABLE Fantasy_League_Teams ( team_id INT NOT NULL, ); player_id INT NOT NULL, FOREIGN KEY (team_id) REFERENCES Teams (team_id), FOREIGN KEY (player_id) REFERENCES Players(player_id), PRIMARY KEY (team_id, player_id) -- League Commissioner table CREATE TABLE League_Commissioner ( id INT PRIMARY KEY, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL User table CREATE TABLE User ( user_id INT PRIMARY KEY, username VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL -- ); -- Teams table CREATE TABLE Teams ( team_id INT PRIMARY KEY, team_name VARCHAR(50) NOT NULL, user_id INT NOT NULL, FOREIGN KEY (user_id) REFERENCES User(user_id) ); -- Players table CREATE TABLE Players ( player_id INT PRIMARY KEY, player_name VARCHAR(50) NOT NULL, position VARCHAR(50) NOT NULL, team VARCHAR(50) NOT NULL ); -- Fantasy League Teams table CREATE TABLE Fantasy_League_Teams ( team_id INT NOT NULL, ); player_id INT NOT NULL, FOREIGN KEY (team_id) REFERENCES Teams (team_id), FOREIGN KEY (player_id) REFERENCES Players(player_id), PRIMARY KEY (team_id, player_id) -- League Commissioner table CREATE TABLE League_Commissioner ( id INT PRIMARY KEY, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL

Answer rating: 100% (QA)

Here is the entity relationship diagram BARCODE SELLING PRICE R7 SALE ID oho AMOUNT PRICE COST SERI... View the full answer