Concept explainers
You are asked to do some modelling development of a Bank accounts management system using the methods in lectures. The description of the system is as follows: This system provides the basic services to manage bank accounts at a bank called LUBank. LUBank has many branches, each of which has an address and branch number. A client opens accounts at a branch. Each account is uniquely identified by an account number; it has a balance and a credit or overdraft limit. There are many types of accounts, including: a mortgage account (which has a property as collateral), a checking account, and a credit card account (which has an expiry date and can have secondary cards attached to it). It is possible to have a joint account (e.g., for a husband and wife). Each type of account has a particular interest rate, a monthly fee, and a specific set of privileges (e.g. ability to write checks, insurance for purchases, etc.). LUBank is divided into divisions and subdivisions (such as Planning, Investments, and Consumer); the branches are considered subdivisions of the Consumer Division. Each division has a manager and a set of other employees. Each customer is assigned a particular employee as his or her ‘personal banker’.
Determine the nouns and noun phrases that might become classes. While making your list, choose good names for each of the potential classes. Determine the responsibilities of each class you have identified, find operations of the classes and update your classes diagram as necessary.
Step by stepSolved in 3 steps with 2 images
- draw an ER diagram of the database to manage daily medical examination and treatment in the hospital (not interested in inpatient treatment):- The hospital has many doctors and nurses from different departments. Each doctor and nurse belongs to only one department- The patient when he comes to the doctor will be created a patient record if it is the first visit- Each visit will be made a medical record and assigned an initial clinic. Each visit is attended by a doctor and an assistant nurse.- The doctor may ask the patient to perform tests, x-rays, endoscopy, ....- After the results are available, the patient returns to the original clinic for the doctor to read the results and prescribe medicine if any- Patients can buy medicine in the hospital pharmacy or buy it outsidearrow_forwardDraw the Level 0 and Level 1 Data Flow Diagram for a Car Purchasing System. Scenario: An owner has to register first to buy a car by providing his personal details, which are later saved in the registration database, then the system will give the registration number back to the owner. The owner will then need to provide the model, name, type of car he wants to buy, and the system automatically reads the status of the car from the car database, which later informs the owner regarding its availability. The owner pays the cost of the car. The system will update the payment database and issue a receipt back to the owner.arrow_forwardIn Chapter 3 of Sharma et al. (2010), you will be introduced with a case study: "This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms: The system will manage the author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The author's information includes name, address, and e-mail. New books, authors and clients are entered into the system. When a client checks out a book, the system will register the date the book was loaned and calculate the days the book can be loaned. It will also calculate the date the book is due to be returned. If the borrower returns the book late, he must pay a fine based on the number of days overdue." (Sharma, et al., 77). Assume that the traditional file system is currently used in this library and a DBMS is to be developed. Discuss the advantages and challenges for the use of…arrow_forward
- In a food delivery system platform, a registered customer can place many orders from all the available registered restaurants. An order can only come from 1 restaurant, and a restaurant can prepare many orders to any numbers of customers. Each of these orders will be handled by a registered rider that accepts the job to deliver. A rider cannot take more than 1 delivery order at any one time until he/she completes the delivery. Draw the class diagram to represent the above scenario. Each entity should have at least 1 attribute as its identity. Provide the relevant associations between these entities and include the multiplicities.arrow_forwardDraw an ER diagram using Cardinality Notation for the following description: A veterinary hospital only treats dogs and cats (use ISA). Clients have an address, phone number and client ID. Each pet has a name, a pet ID and belongs to exactly one client. Each client can have at most 5 cats and 2 dogs.arrow_forwardDomain modelling Draw a UML domain model class diagram for the system as described here. Be as specific and accurate as possible, given the information provided. If any information you need is not given explicitly, make realistic assumptions and document them. Everything for Dogs is a new business that brings together people who are prepared to offer a service for dogs with dog owners looking for that service. Dog lovers offer boarding (in their own home or the dog’s home), dog grooming, dog walking and dog training. Owners register on the website and search the Everything for Dogs database to find a suitable service provider in their local area, and contact them to discuss making a booking. If the service provider and the owner are happy then a booking is made. The service providers charge a rate for their service, but the system does not handle the payments. Everything for Dogs needs a new system to keep track of the owners, dog lovers and services provided. The systems…arrow_forward
- You should focus your efforts on avoiding a debate about how well deep access performs in comparison to shallow access, and you should make the case for using deep access rather than shallow access from the perspective of a developer.arrow_forwardMany of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…arrow_forwardDraw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.arrow_forward
- Assume you have been contracted by a university to develop a database system to keep track of student registration and accommodation records. The university courses are offered by faculties. Depending on the student’s IQ, there are no limitations to how many courses a student can enroll in. The faculties are not responsible for student accommodation. The university owns a number of hostels and each student is given a shared room key after enrollment. Students share a room with 3 other students. Each room has furniture attached to it. a) Identify the main entities for the project. b) Add your own attributes to each entity – minimum of 3 and a maximum of 5. c) Create a primary key for every entity. d) Using your answers for (a) - (c), draw a single ER diagram to represent the data by making use of any means (drawing by hand, drawing in word or any other graphic program or by making use of Oracle SQL Data Developer Modeler.)arrow_forwardHr, Min, Sec Constructors to handle: default, (4, 15, 6), (1,30), (14), (clock1) Overload <> ++,, >=, ==, != Get and Set methods. Write a tester program that creates 2 clocks(Input from the user). The first clock will represent the real time and one will represent your alarm clock. Do a loop that will continue to add 1 second to the current time and stop when it reaches the alarm clock time. Display the time each second on the screen. You can use system("CLS"); to clear the screen each time so it looks like it is overwriting the current time. #include void main() { system("cls"); }arrow_forwardA program called lsu [104] gives access to role accounts. The user's access rights are checked, and the user is required to enter her password. If access rules allow the change and the user's password is correct, lsu allows the change. Given that Mary uses lsu from her account, why does lsu require her to enter her password? Name the principles involved, and why they require thisarrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education