Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started