Please create a 3NF Database with the following information. Question may be drawn as well.

Entities:

• Draw rectangles for each entity: League, Division, Team, Person, Ownership, and Player.
• Inside each rectangle, list the attributes with the primary key (PK) underlined.
• Foreign keys (FK) can be denoted with an asterisk (*) or (FK) beside the attribute name.

Relationships:

• Connect League to Division with a straight line. Label it "1:N" near the line.
• Connect Division to Team with a straight line. Label it "1:N" near the line.
• Connect Team to Person with a straight line for the manager relationship. Label it "0..1:N" indicating a team may have zero or one manager, but a manager can only manage one team.
• Connect Team to Player with a straight line. Label it "1:N" near the line.
• Connect Ownership to both Team and Person using straight lines, forming a diamond shape to represent the many-to-many relationship. Label it "M:N" near the lines.

Attributes:

• Inside the "League" rectangle: LeagueID (PK), CommissionerID (FK), AssistantCommissionerID (FK).
• Inside the "Division" rectangle: DivisionID (PK), DivisionName, DivisionCommissionerID (FK), LeagueID (FK).
• Inside the "Team" rectangle: TeamID (PK), TeamName, City, Stadium, DivisionID (FK), ManagerID (FK).
• Inside the "Person" rectangle: PersonID (PK), Name, Role.
• Inside the "Ownership" rectangle: OwnerID (FK), TeamID (FK).
• Inside the "Player" rectangle: PlayerID (FK), Position, TeamID (FK).

Optionality:

• Indicate optionality by placing a small circle (o) at the end of the relationship line for optional participation, and a straight line (|) for mandatory participation.