Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You must submit an ER diagram of the following problem. You may use any software to create the diagram. You may even use pencil and

image text in transcribed

You must submit an ER diagram of the following problem. You may use any software to create the diagram. You may even use pencil and paper (I suggest this method) and scan your work. You must submit an image (.jpg, png, etc.) of your diagram. Meaning, if you choose to use a piece of software, save your work as an image and submit the image. Specifications We wish to create and app for a University with the following specifications: For each person in the University, the database maintains information on the person's name,social security number, address, sex, and birthdate. Two particular types of persons are identified: Faculty and Student. Specific attributes of Faculty are rank, office, phone, and salary. All faculty members are related to the academic department(s) with which they are affiliated. A specific attribute of Student is class. Each student is related to his or her major and minor departments, to the course sections for which he or she is currently registered, and to the courses he or she has already completed. For all courses a student has completed, a grade is recorded. Grad student is a special type of Student with a class value of 5. For each graduate student,we keep a list of previous degrees earned, including the college, degree name, and year. For those graduate students who have them, we keep track of their faculty advisor and the faculty members on their thesis committee. An academic department has a name, phone, and office number, and must have a particular faculty member who chairs the department. Each department belongs to exactly one college, and each college has a name, office, and name of its dean. A course has a course number, name, and description. Several sections of each course can be offered, with each section having a particular section number, year, and semester in which the section was offered. A given section is related to the instructor who taught it, but only if that person is still in the database. Instructors for course sections can be either faculty members or graduate students. Course sections that are offered during the current semester and year must be treated specially because they are the only ones that students can be registered for. The database must keep track of all grants awarded. Each grant has a title, grant number, awarding agency, and starting date. A grant is related to one faculty member who is the principle investigator (PI) and to all researchers that it supports. Each instance of this support has a start date, end date, and percentage of time being spent on the grant by the researcher being supported. Researchers can be either faculty members or graduate students

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions