1. Pak-Wheel requested for a software and asked for the following functionalities. o Client name, contact, email and transection (only one) are important to keep. o Client can buy or sell car through pinwheels. The transection details which are important to keep are date (day), transection type (Buy or Sell) and amount. Implement the above demand in such a way what if the client is deleted, none of its transection record will remain. (Use Composition)

1. Pak-Wheel requested for a software and asked for the following functionalities. o Client name, contact, email and transection (only one) are important to keep. o Client can buy or sell car through pinwheels. The transection details which are important to keep are date (day), transection type (Buy or Sell) and amount. Implement the above demand in such a way what if the client is deleted, none of its transection record will remain. (Use Composition)

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 the following scenario:You are required to design and implement a system that will be used to take online exams. There are two main groups of users, teachers, and students. Teachers can schedule exams and add students by their email addresses. The teacher should also be able to create student groups. Student groups can be comprised of other student groups. Teachers, if they so wish, can add students to an exam by adding individual students, and/or groups. Half an hour before the scheduled time of the exam, the students should get a notification via email.Exam assessment is done on a per-question level. For each question, the teacher can set one out of many assessment methods (e.g. content-matching, MCQ, mathematical correctness, manual marking, etc.), with each method having its own parameters as specified by the teacher. Certain questions can have nested questions. When an assessment method is set for these, the teacher should be given the choice to apply the same assessment…
1. Explain why the operation handleMessagefromServer() appears in both ObservableClient and AdaptableClient classes. Are they concrete or abstract? 2. If we want the system give a signal to the client when a message from the server is received, what should the program do? Indicate what methods will be used to implement your idea. 3. Indicate the advantages of using the Observable pattern and Adapterpattern in this design.
For the given design, Which of the following is NOT true about the design? Select one: a. It supports modular design. b. The AuthenticateUser sequence diagram can be reused only after a doB message call. c. The AuthenticateUser sequence diagram can be reused only when the authenticate() message is invoked on a B object. d. The DoFoo sequence diagram can be reused in any context where a B object and a C object are involved. e. The doB message must be called after the doA message.
Every company having customers maintains customer accounts and supports a complete life cycle of the account from its creation until it is closed. There are differences in what are the stages (states) in the account's life cycle, and what are conditions or events causing account to change its state.For the user account to be created, it has to meet some initial requirements. For example, user id (used as a login name) must be unique, at least for the existing accounts. After account was created, it might need to be verified. Verification depends on the company and could include e-mail, phone, and/or address verification. If account was not verified during some predefined period of time, that account could be moved to the suspended accounts. New, active, or suspended accounts could be cancelled at any time by client's request. Note, the precondition for this usually includes payment of any outstanding balances, and might require some separate account state or substate to handle this…
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 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…
Create an Activity model (Application layer) for the following “Borrow Books” Use Case from the Use-Case Description: Normal Flow of Events: 1. The Borrower brings books to the Librarian at the checkout desk. 2. The Borrower provides Librarian their ID card. 3. The Librarian checks the validity of the ID Card. If the Borrower is a Student Borrower, Validate ID Card against Registrar’s DB. If the Borrower is a Faculty/Staff Borrower, Validate ID Card against Personnel DB. If the Borrower is a Guest Borrower, Validate ID Card against Library’s Guest DB. If the ID Card is invalid, the book request is rejected. 4. The Librarian checks whether the Borrower has any overdue books and/or fines. If the Borrower either has overdue books, fines, or both, the book request is rejected. 5. The Borrower checks out the books.
Suppose you are required to design a rental car system for a shop in which different cars are given to different customers on specified rent in daily basis. You have to keep the records of customers and cars. Now the shop has multiple cars and customers. The customers have two types one is member and the other is new customer. The customers have some operations as add customer which add the details of the customer in the system, view customer which prints the details of the customer and is valid which checks whether the NIC is given or not. The internal details of is valid operation only is kept hidden with the help of abstraction. The details of customers are name, contact, NIC, address and balance. The car has four types Honda, Toyota, Suzuki and Daihatsu. The common operations of car are add car which add the details of car in the system, view car which prints the details of the car, issue car which updates the car detail (available = false) that car is given on rent and is…