CASE STUDY 1 Draw an appropriate Context Diagram for the following case study. State any assumption for the diagram. When a patient arrives at Malaysia-Mesra Surgery with a repeat prescription request, the receptionist checks the prescription file and writes out a prescription. This has to be authorized by the doctor before being passed to the resident chemist for dispensing. The chemist then gives the prescription to the patient. If the patient is entitled to free prescriptions, the chemist verifies this and fills in the appropriate details on a form, which is filed in the free prescriptions file. Otherwise, the chemist takes the appropriate amount of money from the patient and gives them a receipt.

CASE STUDY 1 Draw an appropriate Context Diagram for the following case study. State any assumption for the diagram. When a patient arrives at Malaysia-Mesra Surgery with a repeat prescription request, the receptionist checks the prescription file and writes out a prescription. This has to be authorized by the doctor before being passed to the resident chemist for dispensing. The chemist then gives the prescription to the patient. If the patient is entitled to free prescriptions, the chemist verifies this and fills in the appropriate details on a form, which is filed in the free prescriptions file. Otherwise, the chemist takes the appropriate amount of money from the patient and gives them a receipt.

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…
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…
G: Race conditions can be occurred in any computer program. Consider a group of two students develop a FYP project and maintain a database in it. One student calls an update( ) function on some data and at the same time second student calls update( ) on the same data to update the database. Describe what problem can be arise in the scenario and what might be done to prevent such problem?
b. Develop a sequence diagram showing the interactions involved when a student registers for a course in a university. Courses may have limited enrolment, so the registration process must include checks that places are available. Assume that the student accesses an electronic course catalog to find out about available courses.
In a UML sequence diagram, a dotted line (lifeline) represents Question options: that the object is destroyed or ceases tor exist. that an object exists in the system but it is not active. an actor sending a message to an object. that an object exists in the system which is active.
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…
Computer science. Correct answer will be upvoted else downvoted. Development of the exhibit in William's cell machine happens iteratively in the accompanying manner: In the event that the component is dead and it has precisely 1 alive neighbor in the present status of the exhibit, then, at that point, on the following emphasis it will become alive. For a component at list I the neighbors would be components with files i−1 and i+1. In case there is no component at that list, it is viewed as a dead neighbor. William is a sympathetic individual so all alive components stay alive. Check the note area for instances of the advancement. You are given some underlying condition, everything being equal, and you really wanted to help William discover the condition of the cluster after m emphasess of advancement. Input Each test contains various experiments. The principal line contains the number of experiments t (1≤t≤103). Depiction of the experiments follows. The primary…
Provide a detailed class digram with attributes, methods , cardinality and relationships for the following system and use case digram : 1.0 The user shall be able to upload a set of requirements in a file. 2.0 System shall read the requirements. 3.0 The system verifies the validity of the input requirements by making sure if the user entered correct data. 2. 1 The system should ask the user to enter again in case the requirements are not correct 4.0 The system shall extract the factors (Assets, impacts, Performance property) from the requirements. 5.0 The system shall calculate a total score for each performance requirement based on the sum of the number of assets point, impacts, and performance properties present in each requirement, where each match is represented by one point. 6.0 The system shall calculate the similarity of the requirements with the ALTRSERC table. 5. 1 The system shall assign a weight of 1 to each ALTRSER property that appears in the performance…