EBK SOFTWARE ENGINEERING
10th Edition
ISBN: 8220101455970
Author: SOMMERVILLE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 6, Problem 6.7E
An
Expert Solution & Answer
Learn your wayIncludes step-by-step video
schedule03:21
Students have asked these similar questions
A Central University wants to automate their all kind of fee payment such as admission, examination, course registration and re-registration and hostel for all type of courses through online, uploading their academic details as document and document verification for confirming their payment for the specific course.
Design this application by providing the entity relationship diagram and data flow diagrams for the scenario given above.
1. Draw dataflow diagram for a library management system.
A library management system data flow diagram (DFD) shows how the information within
a library system needs to flow to meet the needs of patrons or students as well as library
administrators. It contains all of the user flow and their entities such as all the flow of
Library, Book, Issue Book, Author, Publisher, Employee and Student.
The main Entities:
• Processing library records and generate report of all library
Processing book record and generate report for all book
•
• Process issue Book records and generate report of all Issue Book
Process Author records and generate report of all Author
• Process Publisher records and generate report of all Publisher
•
Process Employee records and generate report of all Employee
•
Process issue Student and generate report of all Student
The main Functional Requirements:
Admin logins to the system and manage all the functionalities of Library
Management System
•
Admin can add, edit, delete…
Draw an Enhanced Entity-Relationship (EER) diagram that describes the following business environment.The National Association of Zoos (NAZ) wants to develop an information system to keep track of the zoos, animals, and related zoo objects and people associated with zoos in the US.
Each Zoo in the U.S. has a unique name plus an address and a size in acres. Each state may have several zoos. In addition to the unique state name, the NAZ wants to record the state's governor and capital. Each animal in each zoo has an animal number that is unique across all NAZ zoos. Each animal also has a pet name (King, Rover, Fred, etc.), a species (tiger, eagle, shark, etc.) and a country of origin.
An animal may be a bird, a mammal, a fish, or any of several other broad categories of animal, but a particular animal may be classified in only one of these broad categories. Additional data about birds include their length and wingspan. Additional data about fish include their weight and top swimming…
Chapter 6 Solutions
EBK SOFTWARE ENGINEERING
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
What is the difference between operating system software and application software?
Starting Out with Java: Early Objects (6th Edition)
1 int sum(int x, int y) { 2 int result; 3 result = x + y; 4 }
Java How to Program, Early Objects (11th Edition) (Deitel: How to Program)
Write an SQL query to list each customer who bought at least one product that belongs to product line Basic in ...
Modern Database Management (12th Edition)
When displaying a Java applet, the browser invokes the _____ to interpret the bytecode into the appropriate mac...
Web Development and Design Foundations with HTML5 (8th Edition)
Consider the adage Never ask a question for which you do not want the answer. a. Is following that adage ethica...
Experiencing MIS
Restaurant Selector You have a group of friends coming to visit for your high school reunion, and you want to t...
Starting Out with Java: From Control Structures through Data Structures (3rd Edition)
Knowledge Booster
Similar questions
- Database management Diagram to be drawn for given statement. Downvote for illogical diagram.arrow_forwardDesign a normalized order management database with the requirements provided in the MS Excel worksheet. Each record should have at least one primary key field specified. After identifying the records and their corresponding fields, draw an entity-relationship (ER) diagram using the MS Excel worksheet to illustrate the relationships between entities and attributes. ORDER MANAGEMENT Entity-Relationship ITEM: Customer Header · customer number · buyer name · bill-to address · buyer phone · buyer email · credit rating Customer Shipping · location number · receiver name · receiver phone · receiver email · ship-to address Order Header · order number · order date…arrow_forwardDraw a neat and clean E-R diagram of a library management system. Draw the diagram by hand, the ER diagram will be made with the following specifications. There are books in library which are divided into various categories. Members can get the books from the library. There are various publishers who publish the books. Show proper relationships among entities and also mention attributes for each of the entities. Assume at least 3 attributes for each entity.arrow_forward
- 1.The phases of the systems development life cycle are circular in nature. true or false 2. Old-style methods of collecting system requirements include: 3. The database manager is responsible for initiating, planning, executing and closing down the project. 4. While developing a data-flow diagram for a hospital, web site's patient enrollment section is represented as a source on a data-flow diagram. True or false 5. Finding the best solution to a business problem or opportunity describes the attention to detail characteristic that a systems analyst should exhibit during the requirements determination phase. True or false 6. If your analysis of several written procedures reveals duplication of effort in two jobs, you should: Group of answer choices 7. Which of the following are organizational components that a systems analyst needs to understand? 8. A critical path refers to: 9. Explain the differences between a Gantt chart and a PERT/CPM chart. 10. Design a questionnaire to learn…arrow_forwardGiven the following Business case scenarios I need help creating UML activity diagrams to highlight the main activities. Business Use Case 1: Patient Admission Scenario: Patient Arrival: A patient arrives at the hospital for treatment. Registration: The front desk staff registers the patient in the HIS, capturing personal information and assigning a unique identifier. Insurance Verification: The HIS verifies the patient's insurance information to facilitate billing processes. Medical History Entry: The healthcare provider enters the patient's medical history into the HIS. Assigning a Room: Based on the patient's condition and availability, the system assigns a hospital room. Treatment Plan: The healthcare provider develops a treatment plan, documenting it in the HIS. Medication Orders: Medication orders are entered into the system for the pharmacy to prepare. Nurse's Care: Nursing staff access the HIS to view the treatment plan and administer…arrow_forwardLet’s take a look at the following context diagram of payroll system. 2. Design level-2 DFD based on following scenario. Calculate pay process is decomposed in two processes, compute net pay and prepare payroll. Compute net pay process take valid payroll data and exemption data from withholding datastore and generate Net pay and deduction which is saved to employee datastore and also sends to prepare payroll process. Finally prepare payroll process saves posting information to payroll journal datastore and send paychecks to Employees.arrow_forward
- Given the following Business case scenarios I need help creating UML activity diagrams to highlight the main activities.Business Use Case 1: Patient Admission Scenario: Patient Arrival: A patient arrives at the hospital for treatment. Registration: The front desk staff registers the patient in the HIS, capturing personal information and assigning a unique identifier. Insurance Verification: The HIS verifies the patient's insurance information to facilitate billing processes. Medical History Entry: The healthcare provider enters the patient's medical history into the HIS. Assigning a Room: Based on the patient's condition and availability, the system assigns a hospital room. Treatment Plan: The healthcare provider develops a treatment plan, documenting it in the HIS. Medication Orders: Medication orders are entered into the system for the pharmacy to prepare. Nurse's Care: Nursing staff access the HIS to view the treatment plan and administer medications. Monitoring: The HIS…arrow_forwardAir-india want to create database to stores details about an airline’s fleet, flights, and seat bookings. Again, it’s a hugely simplified version of what a real airline would use, but the principles are the same. Draw an ER diagram based on the information given.Consider the following requirements list: • The airline has one or more airplanes.• An airplane has a model number, a unique registration number, and the capacity to take at most 100 passengers.• An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time.• Each flight is carried out by a single airplane.• A passenger has given names, a surname, and a unique email address.• A passenger can book at most 5 seats on a flight.[7](b) Convert the diagram 1(a) in relational model.arrow_forwardDesign a normalized order management database using the information below. Each record should have at least one primary key field specified. After identifying the records and their corresponding fields, draw an entity-relationship (ER) diagram to illustrate the relationships between entities and attributes ORDER MANAGEMENT Entity-Relationship ITEM: Customer Header · customer number · buyer name · bill-to address · buyer phone · buyer email · credit rating Customer Shipping · location number · receiver name · receiver phone · receiver email · ship-to address Order Header · order number…arrow_forward
- Let's take a look at the following context diagram of payroll system. Timekeeping Timecards PAYROLL SYSTEM Paychecks Employees 1. Design level-1 DFD based on following scenario. Payroll system is divided into two processes, verify payroll data and calculate pay. To verify payroll data, it takes timecards from Timekeeping and current status from employee datastore and generate valid payroll data. Along with valid payroll data, calculate pay process receives exemption data from withholding datastore and generate Net pay and deduction which is saved into employee datastore, posting information which is saved into payroll journal datastore and send paychecks to Employees.arrow_forwardDraw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Astronaut mission business rules:• Every entity must have a surrogate primary key.• An astronaut lives in a specific country, and many astronauts can be from the samecountry.• The name for each astronaut must be stored in the database.• The name for each country must be stored in the database.• An astronaut is assigned to a mission to perform a specific role on board a specific vehicle.• An astronaut and a vehicle can be assigned to multiple missions over time.• The start date and end date of each mission must be stored in the database.• The model and name of each vehicle must be stored in the database.• The description of each role must be stored in the database.arrow_forwardPlease create an ER diagram for its database according to the following requirements: • company database will keep track of employees, facilities, and devices. • For each employee, it will keep track of a unique employee identifier as well as his or her name. • For each facility, it will keep track of a unique facility identifier as well as the facility type, and the date opened. • For each device, it will keep track of a unique device identifier as well as the device type. • Each employee can access one or more facilities. Each facility can be accessed by one or more employees. Assume that each facility can be accessed by at least one employee, and that each employee can access at least one facility. • Each device is issued to exactly one employee. Each employee can have zero or many devices issued to him or her. You can assume that each device is issued to an employee.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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