Answered step by step
Verified Expert Solution
Link Copied!

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) Games table CREATE TABLE Games ( game_id INT PRIMARY KEY, home_team_id INT NOT NULL, away_team_id INT NOT -- Free Agents table CREATE TABLE Free_Agents ( player_id INT PRIMARY KEY, player_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

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Java Programming, Comprehensive Version

Authors: Y. Daniel Liang

10th Edition

133761312, 978-0133761313

More Books

Students also viewed these Databases questions

Question

25.0 m C B A 52.0 m 65.0 m

Answered: 1 week ago