A college football association has a database to record various data about their teams, players and affiliated university. The following relational model presents the relationship between the tables:...

SQL Help

Write a SQL statement that add the following entry in the College table

- CollegeID: 1234


- CollegeName: Example College


- City: San Francisco


- State: CA

Extracted text: A college football association has a database to record various data about their teams, players and affiliated university. The following relational model presents the relationship between the tables: Team TeamID TeamName City State Win Los Player PlayerlD PlayerName Age Position TeamID CollegelD College CollegelD CollegeName City State We have the following information about the attributes: Team: - TeamID is an integer and is the Primary Key of the Team table - TeamName is a chain of no more than 30 characters - City is a chain of no more than 25 characters - State is a chain of 2 characters - Win is an integer - Loss is an integer Player: - PlayerlD is an integer and is the Primary Key of the Player table - PlayerName is a chain of no more than 50 characters - Age is an integer - Position is a chain of no more than 15 characters - TeamID is an integer and is a foreign key of the Player table - CollegelD is an integer and is a foreign key of the Player table College: - CollegelD is an integer and is the Primary Key of the College table - CollegeName is a chain of no more than 30 characters - City is a chain of no more than 25 characters - State is a chain of 2 characters