Question 18 2 points Saved A case competitions database: You work for a firm that has decided to sponsor case competitions between teams of college business students, and you were put in charge of creating a database to keep the corresponding data. The firm plans to hold about dozens of different regional competitions at various dates that will take place at different branches around the country. . For each competition, you need to store a name, date, and the name of the branch where it is going to take place. . For each college that has agreed to participate in the competition, you need to store the college name, a contact phone number, and a contact address. Each college can participate in only one competition, and the database should know which competition each college is participating in. On the other hand, each college is allowed to send more than one tearn to its competition. Each team gives itself a name and a color, and consists of several students of the same college, for each student, you want to store a first name, last name, date of birth, major, and expected graduation date. Question: Consider you have tables COLLEGE, TEAM, and STUDENT, and you have the following design... COLLEGE STUDENT TEAM TEAM (TeamID. Name, Color) COLLEGE (Collegeld, CollegeName, Contact Phone, Address, City, State, Zip) STUDENT (StudentID. FirstName, LastName, DateOfBirth, Major, Graduation Date, TeamID, CollegeID) Collegeld foreign key to COLLEGE TeamID foreign key to TEAM Is this design correct? No, because the primary keys of the tables are wrong No, because with this design a college can only be associated with one team No, because the database allows a team to have students from different colleges