Consider the following information about a university database: Each project is managed by one professor. And each project is worked on by one or more professors. but professors can manage and/or work...

Consider the following information about a university database:

• 
  

  Each project is managed by one professor. And each project is worked on by one or more professors. but professors can manage and/or work on multiple projects.

  
  

• 
  

  Each project is worked on by one or more graduate students. When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a supervisor for each one.

  
  

• 
  

  Departments have a professor who runs the department. professors work in one or more departments, and for each department that they work in, a time percentage is associated with their job.

  
  


• 
  

  Graduate students have one major department. Each graduate student has another, more senior graduate student who advises him or her on what courses to take(advisor).

  
  

Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age, and average degrees

Departments have a department number, a department name, and a main office.