Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make an ER diagram using my SQL code below, User table CREATE TABLE User ( user_id INT PRIMARY KEY, username VARCHAR(50) NOT NULL, password VARCHAR(50)
Make an ER diagram using my SQL code below,
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
Step by Step Solution
★★★★★
3.47 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
Here is the entity relationship diagram BARCODE SELLING PRICE R7 SALE ID oho AMOUNT PRICE COST SERI...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started