Question: This project may be done as a two student group project, though students may work individually if tl includes both two-student groups and individual student

This project may be done as a two student group project, though students may work individually if tl includes both two-student groups and individual student groups. This is an group, confidential project. Each group will submit its project documents which will reflect Groups may not communicate with anyone regarding this project except for the course instructor. In ask anyone other than the instructor questions about the assignments send email, texts, or any type of request asking for another group's project documents send the group's project documents to any other group. Any of the above actions constitute a violation of the academic honesty policy for this assignment as project. If the instructor finds that submissions from two or more groups are the same in part or whole, all gre Please inform me of your group composition (both two-student and individual student groups) by Fet 3. Consider a scenario where a university wants to track student membership in school clubs. The database needs to contain information on the students: student id, student name, major, phone number. It also needs to contain information about the clubs: club number, club name, web site, contact phone number. Also, for students, the university wants to maintain a list of that student's club memberships, and for the clubs, a list of the club members. The university also want to know the president of each club. The ER diagram below describes the scenario. Create the user defined types for the student and club entity types. User object references as appropriate. Create tables from the user define types as typed tables. Club has president leclub D int name varchar(20) Prane berlist array of student lophone varchar(30) varchar(20) varchar(10) This project may be done as a two student group project, though students may work individually if tl includes both two-student groups and individual student groups. This is an group, confidential project. Each group will submit its project documents which will reflect Groups may not communicate with anyone regarding this project except for the course instructor. In ask anyone other than the instructor questions about the assignments send email, texts, or any type of request asking for another group's project documents send the group's project documents to any other group. Any of the above actions constitute a violation of the academic honesty policy for this assignment as project. If the instructor finds that submissions from two or more groups are the same in part or whole, all gre Please inform me of your group composition (both two-student and individual student groups) by Fet 3. Consider a scenario where a university wants to track student membership in school clubs. The database needs to contain information on the students: student id, student name, major, phone number. It also needs to contain information about the clubs: club number, club name, web site, contact phone number. Also, for students, the university wants to maintain a list of that student's club memberships, and for the clubs, a list of the club members. The university also want to know the president of each club. The ER diagram below describes the scenario. Create the user defined types for the student and club entity types. User object references as appropriate. Create tables from the user define types as typed tables. Club has president leclub D int name varchar(20) Prane berlist array of student lophone varchar(30) varchar(20) varchar
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
