Create a Crow’s Foot ERD for each of the following independent descriptions (Note that the words many and multiple refer to ‘more than one’ in a database modeling environment.)
1.SocialXYZ is a research group comprised of faculty and students from multiple majors. It needs a database to track students, faculty and projects. Many students may work on many projects, but only one faculty can be a project lead. Reconstruct the ERD for this database.
2.MusicShare allows students to share their MP3s. A single MP3 can be downloaded by many students but only one student may own a single MP3. Reconstruct the ERD for this database.
3.UniversityPods is a database to keep track of x university new shuttle busses available for faculty to chaperone students to off-campus events. Each pod (i.e. van) can be assigned to many trips, but each trip is driven by only one faculty member. Reconstruct the ERD for this database.
4.Universityclubs is a database to track student clubs, their advisers and club participants (e.g. students). Each club may consist of many students, but a single club will be advised by only one faculty member and a single faculty may advise multiple clubs. Reconstruct the ERD for this database.
5. online bulletin board allows students with a valid university email address to post things online, such as free stuff, stuff for sale, parties, help wanted, etc. A single student may post multiple bulletin board items. Reconstruct the ERD that can facilitate this system.