database management system
Design a “good” entity-relationship diagramthat describes the following objects in an university application:students, instructors, professors, and courses.Students aresubdivided into graduate and undergraduate students. Students takea course in a particular semester and receive a grade for theirperformance. Sometimesstudents take the same course again in adifferent semester. There are no limits on how many courses astudent can take, and on how many students completed aparticularcourse. Each graduate student has exactly one advisor, who must bea professor, whereas each professor is allowed to be the advisor ofat most 20 students.Courses have a unique course number and acourse title. Students and professors have a name and a unique ssn;students additionally have a gpa; moreover, graduatestudents havea GRE-score, and undergraduate students have a single or multiplemajors. Professors can be students and take courses, but graduatestudents cannot beundergraduate students.
a)Draw an entity-relationship model to represent thelibrary.
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Create sql queries to find the following miscrosoft access compatible commands please 9. Courses for which...
Create sql queries to find the following
miscrosoft access compatible commands please
9. Courses for which at least three students earned a grade of A, showing the grade and the course code 10. Semesters when the highest number of courses have been scheduled, showing the semester name and the number of sections 11. (Extra) Professors that are not students, and students that are not professors, showing their ID and SSN 12. (Extra) Semesters for which all courses are taught by...
Please answer questions 4 to 7 please type the answers SQL Given the tollowing whema COURSE ode. Thle, Credits) EXAMCAurse. Stadent. Grade, Score GRADUATIONPALHOure, Suedent) SCHEDULE(Professor, Cour...
Please answer questions 4 to 7
please type the answers
SQL Given the tollowing whema COURSE ode. Thle, Credits) EXAMCAurse. Stadent. Grade, Score GRADUATIONPALHOure, Suedent) SCHEDULE(Professor, Course, Semester Section PROFESSORİD, Name, SSN) STUDENTOİD, Name, SSN) Formulate SQL queries to find he bove 4. People that are students but are not professors, showing the people name and SSN 5. The courses for which classes have been scheduled but the professor is yet to be defined showing the course title, the semester,...
Create a database ER model using the following information please: A small university is in the...
Create a database ER model using the following information please: A small university is in the process of creating its first database system, and you are the chief architect of this system. This university does not have majors, faculties, and departments, but it does have programs. A program usually has 5 courses (in real situation, a program usually has much more courses, but to make the test data preparation easier, we set this number as 5), For simplicity, all the...
1) A university database contains information about professors (identified by emp_id) and courses (identified by course_id)....
1) A university database contains information about professors (identified by emp_id) and courses (identified by course_id). Professors teach courses. Each of the following situations concerns the Teaches relationship set. For each situation, draw an ER diagram that describes it (assuming no further constraints hold). a) Professors can teach the same course in several semesters, and each offering must be recorded. b) Professors can teach the same course in several semesters, and only the most recent such offering needs to be...
system analysis and design Class Diagram Scenario An instructor consists of name, address, email, number, and...
system analysis and design
Class Diagram
Scenario An instructor consists of name, address, email, number, and salary. There can be either a full-time or part-time instructor. A student consists of name, student number, and email. Students can enroll for at least one seminar in a semester. Each seminar consists of seminar name, seminar number, and fees. Full-time instructors are responsible for taking the seminars. Each seminar can be taken by at least one and at most two instructors. Only two...
In this phase of the project you will create an ERD based upon the following requirements and bus...
In this phase of the project you will create an ERD based upon the following requirements and business rules. Limit your ERD to entities and relationships based on the business rules showed here. In other words, do not add realism to your design by expanding or refining the business rules. However, make sure you include all attributes needed that would permit the model to be successfully implemented, including all primary and foreign keys. 1. Trinity College (TC) is divided into...
This is database system concept. 1.Find the ids of instructors who are also students using a...
This is database system concept. 1.Find the ids of instructors who are also students using a set operation. Assume that a person is identified by her or his id. So, if the same id appears in both instructor and student, then that person is both an instructor and a student. Remember: set operation means union, intersect or set difference. 2.Find the ids of instructors who are also students using the set membership operator. 3.Find the ids of instructors who are...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is...
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
Create sql queries to find the following
miscrosoft access compatible commands please
9. Courses for which at least three students earned a grade of A, showing the grade and the course code 10. Semesters when the highest number of courses have been scheduled, showing the semester name and the number of sections 11. (Extra) Professors that are not students, and students that are not professors, showing their ID and SSN 12. (Extra) Semesters for which all courses are taught by...
Please answer questions 4 to 7
please type the answers
SQL Given the tollowing whema COURSE ode. Thle, Credits) EXAMCAurse. Stadent. Grade, Score GRADUATIONPALHOure, Suedent) SCHEDULE(Professor, Course, Semester Section PROFESSORİD, Name, SSN) STUDENTOİD, Name, SSN) Formulate SQL queries to find he bove 4. People that are students but are not professors, showing the people name and SSN 5. The courses for which classes have been scheduled but the professor is yet to be defined showing the course title, the semester,...
system analysis and design
Class Diagram
Scenario An instructor consists of name, address, email, number, and salary. There can be either a full-time or part-time instructor. A student consists of name, student number, and email. Students can enroll for at least one seminar in a semester. Each seminar consists of seminar name, seminar number, and fees. Full-time instructors are responsible for taking the seminars. Each seminar can be taken by at least one and at most two instructors. Only two...
In this phase of the project you will create an ERD based upon the following requirements and business rules. Limit your ERD to entities and relationships based on the business rules showed here. In other words, do not add realism to your design by expanding or refining the business rules. However, make sure you include all attributes needed that would permit the model to be successfully implemented, including all primary and foreign keys. 1. Trinity College (TC) is divided into...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
Most questions answered within 3 hours.
-
Suppose a brewery has a filling machine that fills 12-ounce
bottles of beer. It is known...
asked 33 minutes ago -
For this problem, carry at least four digits after the decimal
in your calculations. Answers may...
asked 3 hours ago -
Ask a user for three positive integer numbers. Use an input
validation loop to make sure...
asked 3 hours ago -
The most primitive form of data from data analysis perspective
is a. nominal scale b. ordinal...
asked 3 hours ago -
The number of vacancies in some hypothetical metal increases by
a factor of 5 when the...
asked 4 hours ago -
The fiduciary duty that is predicated on the concept that a
board of directors and officers...
asked 4 hours ago -
Sustainable Growth Rate Last year Umbrellas Unlimited
Corporation had an ROE of 17.3% and a dividend...
asked 4 hours ago -
Write a MATLAB program to do the following:
Receive 5 input values and store them into...
asked 4 hours ago -
Which one of the following aqueous solutions would you expect to
have the largest conductance: (a)...
asked 4 hours ago -
(Intermediate Macroeconomics)
2.The aggregate supply function be ys=2000+P, and the aggregate
demand function be yD=2400-P。Find the...
asked 4 hours ago -
I am having a really difficult time developing a strong thesis
for this question....... To what...
asked 4 hours ago -
There are n street lights in a line. In order to conserve
energy, the city decides...
asked 4 hours ago