Identify all M:N relationships (listed out) — as we discussed in class, if you don’t yet have any, be sure to get at least one of them in.
player M:N playersGroup
Describe how to convert them to an “implementable” solution
I will create a new composite table called playerPlayersGroup, and move the relationships into that. It will have a PK of the composite of the PKs from the original tables, and each will be a FK back to the original. I will add in “interesting” attributes created by this join.
Redo the ER Diagram but make sure everything is to BCNF standards.
Be sure to use Crow’s Feet notation, as described in class.
Identify all PK’s and FK’s in each entity
Identify any other particular interesting attributes.
r your newly BCNF-compliant system, for each entity (table), list out ALL Functional Dependencies (FDs).
gameType:
gameTypeID -> gameTypeDescription
session:
sessionID -> playerID, eventDate, playersGroupID, locationID, gameTypeID, notes, dollarArrive, dollarLeave
player:
playerID -> firstName, lastName
playersGroup:
playersGroupID -> groupName
location:
locationID -> name
playerPlayersGroup:
playerID + playersGroupID -> dateJoined, isHost
Part 4:
Write five (5) English questions (of moderate complexity) that you would like to answer from your project. Questions that will give you knowledge you didn’t have before. Be sure to use specific entities and attributes in your questions, not general questions. For example:
“What is my average profit/loss for all games played?”
“How many of each type of games has each player played?”
“Where and against what groups do I make the most and least amount of money?”
“How does my profit/loss look through the lens of the blinds during cash games?” (example of a poor choice – no blinds in the tables above)
“Do I make more profit at cash or tournament games?”
Sample Solution
