Consider the following description of a university system where professors teach courses in which students can enrol: Each professor has a name, address, phone number, email address, and salary. A student has also a name, address, phone number and email address. A student also has an average mark (of the final marks of his or her course). Each person in the university has a unique id. A Course has a name, a number, and fees. When a student is enrolled in a course, the marks for this enrolment are recorded and the current average as well as the final mark (if there is one) can be obtained from the enrolment. Each student can obtain a list of courses he or she is enrolled in. Professors teach courses. Each course has at least one and at most three teachers. a) Draw a class diagram for this university? Draw by computer not handwriting b) Add attributes and methods (operations) when necessary.

Consider the following description of a university system where professors teach courses in which students can enrol: Each professor has a name, address, phone number, email address, and salary. A student has also a name, address, phone number and email address. A student also has an average mark (of the final marks of his or her course). Each person in the university has a unique id. A Course has a name, a number, and fees. When a student is enrolled in a course, the marks for this enrolment are recorded and the current average as well as the final mark (if there is one) can be obtained from the enrolment. Each student can obtain a list of courses he or she is enrolled in. Professors teach courses. Each course has at least one and at most three teachers. a) Draw a class diagram for this university? Draw by computer not handwriting b) Add attributes and methods (operations) when necessary.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Consider that a system has two entities, Student and Course. The student has the following properties:student name, number, SSN and GPA. Similarly, the course has the following properties: course name,course number, credit hours and a set of students who are currently registering on the course.Implement the above system taking into account the following requirements:1. In course, the number of students that are registering this course is decided at the time wheninstantiating the course object.2. Assume that student1 and student2 are two objects of type student, write a code that enablesyou to write: if (student1.isequal (student2)). Where student1, student12 arestudent objects. The statement is true if the objects have the same GPA and credit hours.3. Write a getStudentpByName method in class course that takes a student name and returnsa list of all students who share the same name.4. Write a getStudentByGPA method in class course that takes a GPA and returns a list ofStudents in that…
Consider that a system has two entities, Student and Course. The student has the following properties:student name, number, SSN and GPA. Similarly, the course has the following properties: course name,course number, credit hours and a set of students who are currently registering on the course.Implement the above system taking into account the following requirements:1. In course, the number of students that are registering this course is decided at the time wheninstantiating the course object.2. Assume that student1 and student2 are two objects of type student, write a code that enablesyou to write: if (student1.isequal (student2)). Where student1, student12 arestudent objects. The statement is true if the objects have the same GPA and credit hours.3. Write a getStudentpByName method in class course that takes a student name and returnsa list of all students who share the same name.4. Write a getStudentByGPA method in class course that takes a GPA and returns a list ofStudents in that…
Consider that a system has two entities, Student and Course. The student has the following properties:student name, number, SSN and GPA. Similarly, the course has the following properties: course name,course number, credit hours and a set of students who are currently registering on the course.Implement the above system taking into account the following requirements:1. In course, the number of students that are registering this course is decided at the time wheninstantiating the course object.2. Assume that student1 and student2 are two objects of type student, write a code that enablesyou to write: if (student1.isequal (student2)). Where student1, student12 arestudent objects. The statement is true if the objects have the same GPA and credit hours.3. Write a getStudentpByName method in class course that takes a student name and returnsa list of all students who share the same name.4. Write a getStudentByGPA method in class course that takes a GPA and returns a list ofStudents in that…
Consider that a system has two entities, Student and Course. The student has the following properties:student name, number, SSN and GPA. Similarly, the course has the following properties: course name,course number, credit hours and a set of students who are currently registering on the course.Implement the above system taking into account the following requirements:1. In course, the number of students that are registering this course is decided at the time wheninstantiating the course object.2. Assume that student1 and student2 are two objects of type student, write a code that enablesyou to write: if (student1.isequal (student2)). Where student1, student12 arestudent objects. The statement is true if the objects have the same GPA and credit hours.3. Write a getStudentpByName method in class course that takes a student name and returnsa list of all students who share the same name.4. Write a getStudentByGPA method in class course that takes a GPA and returns a list ofStudents in that…
Consider that a system has two entities, Student and Course. The student has the following properties:student name, number, SSN and GPA. Similarly, the course has the following properties: course name,course number, credit hours and a set of students who are currently registering on the course.Implement the above system taking into account the following requirements:1. In course, the number of students that are registering this course is decided at the time wheninstantiating the course object.2. Assume that student1 and student2 are two objects of type student, write a code that enablesyou to write: if (student1.isequal (student2)). Where student1, student12 arestudent objects. The statement is true if the objects have the same GPA and credit hours.3. Write a getStudentpByName method in class course that takes a student name and returnsa list of all students who share the same name.4. Write a getStudentByGPA method in class course that takes a GPA and returns a list ofStudents in that…
Draw the relationships and entities model for each of the following: * in the traditional way* for example: see the pic??. In the database of the library, the author can author more than one book, and the book can be subscribed toWritten by more than one author
Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules:- A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. A patient may pay the bill directly, or…
The next best alternate after BCNF is 3NF. We can say that this schema is 3NF but not BCNF. Match the following statements that make this 3NF and not BCNF dept_advisor(s_ID, i_ID, dept_name) § With function dependencies: i_ID → dept_name s_ID, dept_name → i_ID § Two candidate keys = { s_ID , dept_name }, { s_ID , i_ID } - A. B. C. D. i_ID is not a superkey - A. B. C. D. { dept_name} – {i_ID } - A. B. C. D. dept_name is contained in a candidate key - A. B. C. D. s_ID, dept_name A. {dept_name } B. Since each attribute A in β – α is contained in a candidate key for R, dept_advisors is 3NF C. superkey D. dept_advisor is not BCNF
Using the Crow's foot notation,create an ERD that can be implemented for a medical clinic using the following business rules:A patient can make many appointments with one or more doctors in the clinic,and a doctor can accept appointments with many patients.however each oppointment is made with only one doctor and one patient.Emergency patients do not ned an appointment .However,for appointment management purposes,an emergency is entered in the appointment book as"unscheduled."If kept,an appointment yields a visit with the doctor specified in the appointment.The visit yields a diagnosis and ,when appropriate, treatment.With each visit,the patient's records are updated to provide a medical history.Each patient visit creates a bill.Each patient visit is billed by one doctor,and each doctor can bill many patients.Each bill must be paid.However a bill may be paid in many instalments,and a payment may cover more than one bill.A patient may pay the bill directly,or the bill may be the basis…
Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. Show all connectivities, relationship…
1. What technique is used to model the situation that Student may have multiple addresses? A) Associative Entity (gerund)B) Weak entitiesC) Super/sub typesD) Recursive relationships 2.There is m:m relationship between students and classes. Which technique is used forrepresenting the student grade? A) Associative Entity (gerund)B) Weak entitiesC) Super/sub typesD) Recursive relationships 3. An associative Entity (gerund) may be used whenever there are data that depends on twoentities even when their relationship is 1:m. True or FalseA) TrueB) False 4. (check all that apply) When do you use recursive relationships?A) the relationship between employees and their supervisorsB) the relationship between employees and their dependentsC) the relationship between employees and their departmentsD) the relationship between employees and their team membersE) the relationship between employees and their job assignments 5. How is a gerund converted into a relational model?A) ignore the gerund in the…
Consider the following scenario A student has a name, which consists of a given name and a family name, and a student IID. Each student is uniquely identified by his/her student ID.A course has a subject and a course ID. For each course, we want to record the number of students taking that course and the type of equipment being used for the course. A course is uniquely identified by its course ID.A student can be enrolled in an arbitrary number of courses, and an arbitrary number of students can be enrolled in a course. For each course in which they are enrolled students receive a lab mark and an exam mark.A course cannot exist if there is no student enrolled in it.A school is distinguished by the honour's degree that it awards. We also want to record to which faculty a school belongs. A student is registered with at most one school, while a school can have an arbitrary number of students. Questions a) Draw an Entity Relationship Diagram b) translate the ERD into a relational data…