Question: Give me the schema to make the databse on this ER DIagaram Table | Primary key | Foreign keys. | Alternate key Playoffround | id

Give me the schema to make the databse on this ER DIagaram

Table | Primary key | Foreign keys. | Alternate key

Playoffround | id |

Roundstats | id. | id(Playoffround(id)). |

Hockeygame. |. id . | . teamid1 team2id(Hockeyteam(id) , roundid(Playoffround (id)). |

Gamescore. |. id. |. id(hockeygame(id)) . |

Hockeyteamplayer. |. id. | hockeyteamid(HockeyTeam(id)). |

Hockeyteam| id . | . |

User | id . |. | .email

User info. | id. | . id(User(id)). |

UserScorepicks. | id . |. userid(User(id)). |

Userstatspicks. | id. | userid(User(id)). |

Pleae ignore dots.

PlayoffRound HockeyGame GameScores team1ld team2ld startTime endTime roundNum roundld team1Score startTime team2Score team2ld RoundStats HockeyTeam hockeyTeamld goalLeaderld lastName penaltyLeaderld plusMinusLeaderld faceoffsWonLeaderld sogLeaderld User Userinfo password astName UserStatsPicks round1Points round2Points round3Points roundld goalLeaderld UserScorePicks penaltyLeaderld plusMinusLeaderld faceoffsWonLeaderld hockeyGameld team1score team2score userld numShutouts

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

1. Relational Schema 2. SQL CREATE TABLE Statements (netid History occupied Note: lid is lot id Person (timestamp date) special lot name) Space N Tid) Tocation N Vacant Decal (lat) Tong Assigned...

NFS2201 Database Management Systems Assignment 2-15% 1. Case Study: - 50% Q-Limo provides taxi service to the VIP customers throughout Qatar. Consider the following entities and relational model for...

Please come up with the database report based on Aged care facility management scenario with atleast 1 2 enties, Design your ER Diagram with all entity names, attribute names, primary and foreign...

LSP 121 Activity 3 Relational Database and Queries This activity will give you practice at creating Access tables, performing: Normalization, Creating primary and Foreign keys. Given below are the...

The database you are building is based on this diagram. Each of these tables represents an entity. Each entity contains attributes ( fields ) . Attributes have data types, and some are identified as...

A shipping company serves a limited group of customers. A shipment invoice contains the following information: Invoice Number Date Picked Up Date of Delivery Ship From Customer Ship To Customer Ship...

Lab 7: Inserting and Updating Data OVERVIEW This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current...

can you please help me to do mapping using draw.io this is the ER diagram . like this the information in ER diagram put it in map you make like the last photo my dr give it to us she wants us to make...

The FTC instituted proceedings against the Soft Drink Bottling Company, alleging violations of laws prohibiting unfair methods of competition. The complaint against Soft Drink Bottling challenged the...

What weight of water is displacedby a floating ship whose mass is 105 kg? Express your answer as aninteger and include the appropriate units. Than answer: What is the buoyant force that acts on...

1 . Which options should be taken into consideration when retirement planning analysis is done? Select all that apply Consider delaying retirement age Consider other income sources Consider all...

the isothermal chemical reactor in figure q 4 . 1 1 includes a liquid inventory in which the turbulent flow out depends on the liquid level. the chemical reaction is first - order with negligible...

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...