(Solved): PLEASE ONLY SOLVE IF YOU HAVE KNOWLEDGE ABOUT DATA MANAGEMENT AND FILE STRUCTRUES DO NOT COPY FROM O ...

PLEASE ONLY SOLVE IF YOU HAVE KNOWLEDGE ABOUT DATA MANAGEMENT AND FILE STRUCTRUES DO NOT COPY FROM OTHER ANSWERS Draw an E//R diagram that suits best to the below described database problem: A University database contains information about Professors, Students, Courses, Projects, and Sponsors. Professors are identified by SSN, and have a name, an age, a rank, and a research specialty. Projects are identified a project number, and have a title, a starting date, an ending date, and a budget. Students are identified by student ID Number, and have a name, an age, a gpa, and an address. Students can be graduate or undergraduate students. Undergraduate students have a year, and a department attributes. Graduate students have a degree program (e.g., M.S. or Ph.D.), and a major. Courses have a course id (key), a course name, and a credit. Some courses are undergraduate courses, others are graduate courses. Undergraduate students can enroll only undergraduate courses. Graduate students can enroll graduate courses and at most 1 undergraduate course. Students can enroll the same course in several semesters and grade for only the last semester must be recorded. Professors must teach one graduate and one undergraduate course for a given semester, and taught courses for all semesters must be recorded. Sponsors have a name (key). Each project is supported by at least one sponsor. Each project is managed by only one professor (known as the project's principal investigator). Each project is worked on by one or more professors (known as the project's co-investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project's research assistants). When graduate students work on a project, the project's principal investigator must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one.