Answer:
We will ned (4) four tables.
Explanation:
For the given scenario we will have to build a relational database. The database will have four tables i.e. Competation, Collage, Team and student.
For each table the database fields are mention below. Note that foreign keys are mentioned in itallic.
Competition:
Competition_ID, Competition_Name, Competition_Data, Competition_Name _of_Branch, <em>College_ID</em>
<em />
Collage:
Collage_ID, Collage_Name, Collage_Contact, Collage_address
Team:
Name, Color, <em>Team_ID, College_ID, Competition_ID</em>
<em />
College:
Student_ID, First_Name, Last_Name, Date_of_Birth, Major, Expected_Gradiuation_Date, <em>Collage_ID, Team_ID, Competation_ID</em>