Case Study: Online Hiring Babysitters System Imagine that a system analyst made an interview with the manager of a famous company in children's care. This company provides the service of hiring female babysitters for fees.  The analyst summarized the interview report and found that the company requires a website to provide its service online. This website must work as follows: “A qualified babysitter registers online on the website by filling their required information. After that, an admin will check her profile to approve. If approved, an approval email will be sent to the babysitter. When a mother needs a babysitter, she will search the childcare website by entering the postcode to find the nearby babysitters. The search results will be shown and then the mother can browse the registered babysitters’ profiles and reviews. To book a babysitter online, the mother must do several procedures. The mother will select the details of the booking including date, time, and address, where she needs a babysitter. The website will automatically match the selected details with approved babysitters. From the babysitter list, she will choose the appropriate babysitter and pay fees online via credit card. Then, the booking will be saved, and a confirmation email will be sent automatically to this mother with the booking details. If a babysitter receives a booking request, she will call the mother before coming for knowing about her children's needs. Finally, this mother can review the care of the babysitter. Then, the profile of this babysitter and her reviews will be updated, and then she will get paid by the website." Also, the analyst found that the same company requires a database to hold employees’ data and to keep track of the online babysitters’ registration and booking records. The design of this database must meet the following specifications: “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager.   Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date. Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking.   The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a payment, the mother needs the credit card data and the fees total. It is important to know that the booking cannot be generated without the request of mothers. Reviewing babysitters’ care is optional. However, mothers can review them online once and the website will save this review with generated id and date and update the number of reviewers”.   Task Part1: Modeling System with Logical DFD Read and analysis the given case study carefully.   Now use any online editor to model the scenario of the system with logical DFD as follows:   Draw context diagram.   Draw level-0 DFD   Draw the child diagram (level -1) for the process ‘book a babysitter online’ which has been which is available in the Level-0 DFD.   Check the correctness of name notations and labels for all elements of your new DFD diagram [for more information, please refer to lab2 and Chapter 7 in lectures]. Remember to draw the boundaries of the system for each DFD   Do you think that other processes of level-0 DFD requires to be decomposed into lower levels of DFD? Justify your answer. Task Part2: Conceptual Modeling for the System Database Reread the given case study carefully and do the following tasks: Identify the main entities and their attributes for the given case study [Hint, the entities are similar between DFD and RED with a few differences].   Identify the main relationship types and specify the multiplicity for each relationship.   Based on your answers for (1) and (2), using any Online editor to draw a single ER diagram that represents the data requirements for the given website.   Check the correctness and completion of your model. For more information, please refer to lab9]. Remember that we are molding data using Chen Notation.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Case Study: Online Hiring Babysitters System

Imagine that a system analyst made an interview with the manager of a famous company in children's care. This company provides the service of hiring female babysitters for fees.  The analyst summarized the interview report and found that the company requires a website to provide its service online. This website must work as follows:

“A qualified babysitter registers online on the website by filling their required information. After that, an admin will check her profile to approve. If approved, an approval email will be sent to the babysitter.

When a mother needs a babysitter, she will search the childcare website by entering the postcode to find the nearby babysitters. The search results will be shown and then the mother can browse the registered babysitters’ profiles and reviews.

To book a babysitter online, the mother must do several procedures. The mother will select the details of the booking including date, time, and address, where she needs a babysitter. The website will automatically match the selected details with approved babysitters. From the babysitter list, she will choose the appropriate babysitter and pay fees online via credit card. Then, the booking will be saved, and a confirmation email will be sent automatically to this mother with the booking details.

If a babysitter receives a booking request, she will call the mother before coming for knowing about her children's needs. Finally, this mother can review the care of the babysitter. Then, the profile of this babysitter and her reviews will be updated, and then she will get paid by the website."

Also, the analyst found that the same company requires a database to hold employees’ data and to keep track of the online babysitters’ registration and booking records. The design of this database must meet the following specifications:

“There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager.  

Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date.

Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking.  

The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a payment, the mother needs the credit card data and the fees total. It is important to know that the booking cannot be generated without the request of mothers. Reviewing babysitters’ care is optional. However, mothers can review them online once and the website will save this review with generated id and date and update the number of reviewers”.  

Task Part1: Modeling System with Logical DFD

Read and analysis the given case study carefully.

 

Now use any online editor to model the scenario of the system with logical DFD as follows:

 

Draw context diagram.

 

Draw level-0 DFD

 

Draw the child diagram (level -1) for the process ‘book a babysitter online’ which has been which is available in the Level-0 DFD.

 

Check the correctness of name notations and labels for all elements of your new DFD diagram [for more information, please refer to lab2 and Chapter 7 in lectures]. Remember to draw the boundaries of the system for each DFD

 

Do you think that other processes of level-0 DFD requires to be decomposed into lower levels of DFD? Justify your answer.


Task Part2: Conceptual Modeling for the System Database

Reread the given case study carefully and do the following tasks:

Identify the main entities and their attributes for the given case study [Hint, the entities are similar between DFD and RED with a few differences].

 

Identify the main relationship types and specify the multiplicity for each relationship.

 

Based on your answers for (1) and (2), using any Online editor to draw a single ER diagram that represents the data requirements for the given website.

 

Check the correctness and completion of your model. For more information, please refer to lab9]. Remember that we are molding data using Chen Notation.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY