Draw clearly from existing scenario text the Entity Relationship Diagram (ERD)
Draw clearly from existing scenario text
the Entity Relationship Diagram (ERD)
“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”.
Step by step
Solved in 2 steps with 1 images
