Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Related questions
Concept explainers
Question
Create a Actvity Diagram of this Bank Management Sytem, using this scenario (see attached photo)
Take note: Do not take a shortcut on making the diagram, you must understand the flow of the scenario
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Create a Actvity Diagram of this Bank Management Sytem, using this scenario (see attached photo)
Take note: Do not take a shortcut on making the diagram, you must understand the flow of the scenario (this is not graded)
Transcribed Image Text:The bank is organized into branches. Each branch is located in a particular city and is
identified by a unique name. The bank monitors the assets of each branch.
Bank customers are identified by their customer id values. The bank stores each
customer's name, and the street and city where the customer lives. Customers may
have accounts and can take out loans. A customer may be associated with a particular
banker, who may act as a loan officer or personal banker for that customer.
The bank offers two types of accounts-savings and checking accounts. Accounts
can be held by more than one customer, and a customer can have more than one
account. Each account is assigned a unique account number. The bank maintains a
record of each account's balance and the most recent date on which the account was
accessed by each customer holding the account. In addition, each savings account has
an interest rate, and overdrafts are recorded for each checking account.
. The bank provides its customers with loans. A loan originates at a particular branch
and can be held by one or more customers. A loan is identified by a unique loan
number. For each loan, the bank keeps track of the loan amount and the loan
payments. Although a loan-payment number does not uniquely identify a particular
payment among those for all the bank's loans, a payment number does identify a
particular payment for a specific load. The date and amount are recorded for each
payment.
Bank employees are identified by their employee id values. The bank administration
stores the name and telephone number of each employee, the names of the employee's
dependents, and the employee id number of the employee's manager. The bank also
keeps track of the employees start date and, thus, length of employment.
Solution
by Bartleby Expert
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Create a Actvity Diagram of this Bank Management Sytem, using this scenario (see attached photo)
Take note: Do not take a shortcut on making the diagram, you must understand the flow of the scenario (this is not graded)
Transcribed Image Text:The bank is organized into branches. Each branch is located in a particular city and is
identified by a unique name. The bank monitors the assets of each branch.
Bank customers are identified by their customer id values. The bank stores each
customer's name, and the street and city where the customer lives. Customers may
have accounts and can take out loans. A customer may be associated with a particular
banker, who may act as a loan officer or personal banker for that customer.
The bank offers two types of accounts-savings and checking accounts. Accounts
can be held by more than one customer, and a customer can have more than one
account. Each account is assigned a unique account number. The bank maintains a
record of each account's balance and the most recent date on which the account was
accessed by each customer holding the account. In addition, each savings account has
an interest rate, and overdrafts are recorded for each checking account.
. The bank provides its customers with loans. A loan originates at a particular branch
and can be held by one or more customers. A loan is identified by a unique loan
number. For each loan, the bank keeps track of the loan amount and the loan
payments. Although a loan-payment number does not uniquely identify a particular
payment among those for all the bank's loans, a payment number does identify a
particular payment for a specific load. The date and amount are recorded for each
payment.
Bank employees are identified by their employee id values. The bank administration
stores the name and telephone number of each employee, the names of the employee's
dependents, and the employee id number of the employee's manager. The bank also
keeps track of the employees start date and, thus, length of employment.
Solution
by Bartleby Expert
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- A thorough breakdown of the wait-and-see strategy is provided. What are the main disadvantages of this kind of interaction? Create a formula to determine the amount of time spent connected using this case study.arrow_forward(1) Draw an ER Diagram for the scenario below Temporary Employment Corporation (TEC) places temporary workers in companies during peak periods. TEC's manager gives you the following description of the business: TEC has a file of candidates who are willing to work. • If the candidate has worked before that candidate has a specific job history. • Each candidate has several qualifications. TEC also has a list of companies that request temporaries. Each time a company requests a temporary employee, TEC makes an entry in the openings folder. The folder contains an opening number, company name, required qualifications, starting date, anticipated ending date, and hourly pay. • • Each opening requires only one specific or main qualification. When a candidate matches the qualification, he/she is given the job, and an entry is made in the Placement Record folder. This folder contains an opening number, candidate number, total hours worked, and so on. In addition, an entry is made in the job…arrow_forwardAssume that you have the situation in which: • Suppliers can supply products for projects. • A supplier can supply a particular product for multiple projects. • A product for a particular project can be supplied by multiple suppliers. • A project can have a particular supplier supply multiple products. • A supplier has a key attribute supplier_ID, a project has a key attribute project_ID, and a product has a key attribute product_ID Draw an ER-diagram that captures the above description. You must also include the quantity and due date for supplying a particular product to a particular project by a particular supplier.arrow_forward
- Draw an EER diagram to accurately represent this set of requirements. State any assumption you had to make in developing the diagram.arrow_forwardBecome A Change Agent Purpose To assess your ability to: Evaluate yourself as a change agent. Create a plan for developing yourself as a change agent. Overview This module builds on the work you are doing in Assignment 4-2 in which you evaluated yourself as a change agent. In this discussion post, you will summarize your findings and your plans and will share then with the rest of your class. You will then review your peers’ plans and identify two from which you would also benefit.arrow_forwardExplain the objectives hierarchy. Illustrate your answer by providing and drawing the objectives hierarchy for any system. Kindly I need a unique answer. :)arrow_forward
- For each of the scenarios below please describe what would be the best design pattern to be used, explain the appropriateness and advantages of using that pattern, and draw a corresponding design diagram for that scenario including that pattern. Describe the participants and collaborations. Please respond to all of the above 4. There is a system configured to work with three pretzel stores: Pretzel Maker, Wetzel, and Auntie Anne's. They create similar yet custom-made pretzels, and the system needs to be independent from the way the pretzels are created. Each pretzel store uses its own ingredients (products), yet similar to the other stores. They each use their own kind of dough, cheese, and sauce.arrow_forwardYour Assignment You are given four examples of Business Processes below. For each example, you are to generate a complete Business Process Flow diagram and a detailed Swimlane diagram. The Swimlane diagram should also include labels on the connectors or a legend to describe the type of data that is flowing between blocks. Each example should have at least 1 alternate or non-ideal path in addition to the ideal "sweet" path. Each example should have at least 5 major blocks in the flow process and at least 2 actors. Business Processes: 1. Car Sales 2. Payroll. 3. Helpdesk Ticket Submission/Resolution 4. User Account Creation, Access Privileges, and Termination for New Employee Grading • Each process 25% (4 processes for a total of 100%) o Business Process Flow diagram • At least 5 majors blocks -10% o Swimlane diagram - Data labels on connectors or data legend -5% 1 alternate, non-ideal path -5% At least 2 actors -5%arrow_forwardWhich step of the SDLC is the most crucial, and can you please specify with at least two instances or scenarios?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education