Software Engineering (10th Edition)
10th Edition
ISBN: 9780133943030
Author: Ian 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
QUESTION 6
Read the following scenario and draw a logical data flow diagram that includes both the Context diagram and
Level '0' diagram (Diagram 0 for students only) on a piece of paper
and upload it as a solution for this question.
C1.
, take a clear photo
UTAS-Suhar Library head decided to build a new online library system to facilitate borrowing books for students anả
instructors.
So, the proposed system will allow the students and instructors to login to the system with their usernames and password
and then the system will authenticate them to make sure that they are authorized people or not. Also, it will allow them to
search for books by using book title or ISBN. In addition it will allow them to borrow a book for a specific period. Finally,
when the due date arrives, they must return the books to the library and receive the confirmation receipt.
The system also will allow the Liberian to check for the available books and order new books.
The head of the Library will be able to…
Draw 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.
Design 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…
Chapter 6 Solutions
Software Engineering (10th Edition)
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
- 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_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_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_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_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_forwardHello, I'm attempting to create a scholarship management system where information of a student that earned scholarships can retrieve their current, past and present information on the matter. Please construct an EER diagram and ERD (relational diagram) that has the following information in regards to this goal: Entity: Students Eligible-Scholarship All-Scholarships Past-Scholarship Attributes: Student: StudentID Username Password Email Department Faculty CoursesTaken StudentPerformance CGPA Semester Fall Winter Summer StudentName NameFirst NameLast amount(winter & fall separately), student ID, Student Name etc Scholarship Information ScholarshipEligibleFor ScholarshipID ScholarshipName Amount EarnedScholarship ScholarshipID ScholarshipName Amount Please take a screenshot of your tables/diagrams Subject: MYSQLarrow_forward
- Air-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_forwardCreate an Entity/Relationship (ER) diagram to model the following scenario: An online magazine maintains a list that ranks restaurants based on reviews sent by the magazine's subscribers each restaurant is uniquely identified by an auto-generated code other attributes associated with a restaurant include its name, address, price range (1-3), rating (1-5 stars), and cuisine type there are many cuisine types and more can be added in the future subscribers are uniquely identified by their email and each have a name subscribers can review as many restaurants as they want, and a restaurant can be reviewed by many subscribers a review has a rating (1-5 stars), a date, and comments the system does not allow more than one review on the same date to the same restaurant and written by the same subscriber new reviews entered do not become immediately available as the magazine needs to check if the comments are appropriate and do not contain cursing or anything nasty/offensive once a new review…arrow_forwardCreate 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)arrow_forward
- A. Draw a data model for the following entities, considering the entities as representing a system for a patient billing system and including only the attributes that would be appropriate for this context: Patient (age, name, hobbies, blood type, occupation, insurance carrier, address, phone) Insurance carrier (name, number of patients on plan, address, contact name, phone) Doctor (specialty, provider identification number, golf handicap, age, phone, name) Draw an entity relationship diagram (ERD) for the following situations: B.Consider for Cadinality (Crow's Foot Notation)• Whenever new patients are seen for the first time they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients can be signed up with only one carrier, but they must be signed up to be seen by the doctor. Each time a patient visits the doctor an insurance claim is sent to the carrier for…arrow_forward6-40. Redesign PE Figures 6-1 and 6-2 so that they are clearer, more efficient, and more comprehensive.arrow_forwardDevelop a context diagram and a level-0 diagram for the contracting system described in the following narrative. If you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Supply these extra explanations along with the diagrams. Government Solutions Company (GSC) sells computer equipment to federal government agencies. Whenever a federal agency needs to purchase equipment from GSC, it issues a purchase order against a standing contract previously negotiated with the company. GSC holds several standing contracts with various federal agencies. When a purchase order is received by GSC’s contracting officer, the contract number referenced on the purchase order is entered into the contract database. Using information from the database, the contracting officer reviews the terms and conditions of the contract and determines whether the purchase order is valid. The purchase order is valid if the contract has not expired, the type of equipment…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Information Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning