Question: Need help with number 2-3 II. Database Objects These are the main objects in your database. 1. Departments: Each department has a unique id, a
II. Database Objects These are the main "objects" in your database. 1. Departments: Each department has a unique id, a name, a location, a telephone number, 2. Professors: Each professor has a unique id, a name, a rank, and a salary. All professors and a secretary. Departments employ professors and offer courses. with the same rank have the same salary. Professors teach courses, apply for grants, lead research projects, participate courses and can be employed by research projects. Courses: Each course has a course number and a section number that together are unique in research projects, and advise students. Each student has a unique id, a name, a class level, and a gpa. Students enroll in 4. within a given semester and year. Courses also have a meeting day, time, and room 5. Projects: Each research project has a unique project id, a principal investigator, and a budget. Projects can employ students and can be worked on by other professors. Al projects are funded by some grant. 6. Grants: Each gra nt has a unique id, a principal investigator, a status (applied, funded, denied), and a budget. Grants are used to fund research projects. 7. Loans: Students can take out a loan to help with their expenses. Each loan has a uniqu loan id, a loan amount, and the anticipated starting date for the payments
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
