- Joined
- Sep 7, 2012
- Messages
- 171 (0.04/day)
- Location
- New Delhi, India
System Name | Devil's Hell |
---|---|
Processor | AMD Ryzen™ 5 2600X Processor 2nd Gen 3.6GHz |
Motherboard | MSI X470 GAMING PRO MAX |
Cooling | Corsair H60 (2018) 57.2 CFM Liquid CPU Cooler |
Memory | Corsair Vengeance RGB Pro 16 GB (2 x 8 GB) DDR4-3200 CL16 |
Video Card(s) | MSI GTX 1060 Gaming X 6GB |
Storage | Segate 2 TB, WMD 250 GB M2 |
Display(s) | Samsung T23B350AR |
Case | Cooler Master MasterBox Lite 5 RGB ATX Mid Tower |
Audio Device(s) | Motherboard |
Power Supply | Corsair TXM Gold 650 W 80+ Gold Certified Semi-modular ATX Power Supply |
Mouse | Logitech |
Keyboard | Logitech |
Software | Windows 10 64 Bit |
So basically, I really dont have a very good understanding of DB and following question have been asked in some exam (previous year), can any one with DB knowledge help?
Create a complete Entity-Relationship (ER) diagram for a database that stores the following information
about a baseball league. You should model the Entities and their attributes, as well as the
Relationships and their constraints. Write both the minimum and maximum participation of entities in
a relationship as explained in class: for example, if a constraint states that a minimum of 2 and a
maximum of N entities can participate in the relationship, write 2:N (not just N).
The database stores information about players, teams, and games. A player has a unique player
name. A team has a unique team name. A game has a unique game number. These are the only
entities in the database.
A player plays for one team at any given time. The start date and end date for the player’s
assignment on the team is recorded. A team will consists of 9 or more players.
The database keeps track of every time a player participates in a game. It also stores the player’s
performance rating (A,B,C,D,F).
For each game, there will be one home team and one away team. The date, time, and field name
will be recorded for each game.
For each game, the Inning Score for the home team and the away team will be stored. The Inning
Score consists of: the number of runs, hits, and errors. The Final Score of the game will be also be
stored for both the home team and the away team (runs, hits, and errors).
Create a complete Entity-Relationship (ER) diagram for a database that stores the following information
about a baseball league. You should model the Entities and their attributes, as well as the
Relationships and their constraints. Write both the minimum and maximum participation of entities in
a relationship as explained in class: for example, if a constraint states that a minimum of 2 and a
maximum of N entities can participate in the relationship, write 2:N (not just N).
The database stores information about players, teams, and games. A player has a unique player
name. A team has a unique team name. A game has a unique game number. These are the only
entities in the database.
A player plays for one team at any given time. The start date and end date for the player’s
assignment on the team is recorded. A team will consists of 9 or more players.
The database keeps track of every time a player participates in a game. It also stores the player’s
performance rating (A,B,C,D,F).
For each game, there will be one home team and one away team. The date, time, and field name
will be recorded for each game.
For each game, the Inning Score for the home team and the away team will be stored. The Inning
Score consists of: the number of runs, hits, and errors. The Final Score of the game will be also be
stored for both the home team and the away team (runs, hits, and errors).