Fall Semester 2020

Subject Software Engineering (3+0) Program BSCS

4th Jan, 2021
Dated:
Faculty Engr. Darakhshan Syed 14th Jan, 2021
Deadline:

Student Name:
Student ID:
Weight (Max.
Assessment Activity Assignment -3 10
Marks)
Semester Fall 2020 (Semester- VI) Section Code

IMPORTANT INSTRUCTIONS:

Read the Instructions carefully.

1- Assignment must be type in the given question paper’s document

2- Attempt all questions on MS-Word. Font theme and size must be Time New Romans and 12
respectively. Use line spacing 1.5.
3- Mention your assumptions clearly.
4- Make the file name as per given format:
Subject Name (last four digits of your Registration Number)
e.g. Software Engineering (2342).doc
5- It must be submitted on Blackboard before the due date.
6- Please do not copy.
7- If you are copying the idea from internet then please first understand it and then produce it in your own
words.
8- Don’t forget to write your name in the blank space provided in the question paper.

Page 1 of 11
ASSIGNMENT TASKS:

Question 1: A web based software for an online book store is to be developed when a valid customer logon
to the site a list of available books is displayed. When the customer selects the required book a form will be
displayed that will take input the credit card number and other necessary information of the user.

After submission of the form by the customer the validity of the credit card is ensured by a banking system
(external to the system). The valid orders are passed to the shipment department and an email is sent to the
customer that his order is being shipped.

a) Mention your brain storming as well before the drawing.

b) Write four functional (user+system) requirements.
c) Draw level 1 DFD of the given scenario.
d) Draw ERD of the given scenario.

Answer 1:

A) Brainstorming Points:

1. Collect the information from the other book stores like what kind of software were being used.

2. The website should be user friendly easy to access.

3 Should collect all the reference books by other authors too.

4 Payment gateway should be created book records and generate the reports of all the books processing
customer records and generating report for all customers and also processing for order ,update, bills, books
stock and delivery records and generating reports for all orders, update, bill, book stock and delivery.

B) Functional requirements for user and system as follows

For USER:

1. Allow new user account for registration.

2. After registration User need to login.
3. User will have access to update his/her address, password etc.
4. User will do Book search (by author name, title, category, year or combinations)
5. User will have access to Add/delete books from shopping cart.
6. Need to merge shopping carts and then shopping carts turns as orders (note that once a shopping cart is
changed to order, all of this shopping carts info should be removed from the database).

7. Place the order.

Page 2 of 11
8. Order tracking information to be provided.

For system:

1. System need to List book information (e.g., title, author, price) and quantity-in-stock of some chosen
books.

2. List information about those orders assigned to him/her.

3. Update order status.

4. Insert new books

Should also check for

What type of books are better sold in quarter wise?

What categories of books are the most profitable ones?

What is the average time between the order placed and shipped?

C) Draw level 1 DFD of the given scenario:

Page 3 of 11
 GENERATE
BOOK REPORT
BOOK
MGMT

GENERATE
CUSTOMER
CUSTOMER
REPORT
MGMT

BOOK STOCK
MGMT ORDER REPORT

ONLINE
BOOK
STORE

ORDER
MGMT BOOK STOCK
REPORT

LOGIN
MGMT
CHECK USER
LOGIN DETIALS

SYSTEM USER
MGMT GENERATE
SYSTEM USER
REPORT

D) Draw ERD of the given scenario:

Page 4 of 11
 CITY EMAIL

NAME

CUSTOMER BUY

ADDRESS

PASSWORD
LOGIN ID AUTHOR

BOOKS

TITLE

CART CONTAINS

PRICE

BOOK-ID
BOOK-NO

PRICE QUANTITY

TRACK-NO

ORDER
ORDER-ID

Question 2: Tom is starting a dental practice in a small town. He will have a dental assistant, a dental
hygienist, and a receptionist. He wants a system to manage the appointments.

 When a patient calls for an appointment, the receptionist will check the calendar and will try to schedule the
patient as early as possible to fill in vacancies. If the patient is happy with the proposed appointment, the
receptionist will enter the appointment with the patient name and purpose of appointment. The system will
verify the patient name and supply necessary details from the patient records, including the patient's ID
number. After each exam or cleaning, the hygienist or assistant will mark the appointment as completed, add
comments, and then schedule the patient for the next visit if appropriate. The system will answer queries
name and by date. Supporting details from the patient's records are displayed along with the appointment
information. The receptionist can cancel appointments. The receptionist can print out a notification list for
making reminder calls 2 days before appointments. The system includes the patient's phone numbers from
the patient records. The receptionist can also print out daily and weekly work schedules with all the patients.

a) Mention your brain storming as well before the drawing.

b) Write four functional (user+system) requirements.
c) Draw level 1 DFD of the given scenario.
Page 5 of 11
 d) Draw ERD of the given scenario.
Answer 2:

A) Brainstorming:
For the given scenario, we need to generate data flow design as DFD level 1 and conceptual model
as ERD for the given requirements, so as to comply with the business rules. To generate the data
flow design we need to identify the entities that interact with the system, identity the process, sub
process and how entities interact with the processes and which entities need to be mapped into data
models.
From the identified data model, we have to design the conceptual model where we need to identify
the attributes of the entities, their relationships and their cardinalities.

B) Four Functional Requirements:

User Requirements:
 Receptionist has to enter patient details in the system.
 Receptionist has to enter appointment details in the system which includes the patient name,
purpose of the appointment based on the call from patient for appointment.
 When the patient visits the clinic based on appointment, a dental hygienist or dental assistant
completes the appointment after examining the patient by updating the status of the
appointment as completed, adding comments and scheduling the next visit if needed in the
system.
 The receptionist has to cancel appointments.

System Requirements:
 When the receptionist enter the patient details, the patient details has to be stored in the
database securely since the patient medical records are confidential.
 When the receptionist enters the appointment details, the system has to verify patient
name and provide the needed details including the patient ID from the patient records
database.
 The system has to provide search option providing search results for queries by name and
date.
 The system has to provide supporting details and the appointment details when searched
by name.
 The system has to generate:
(i) Notification list for appointment reminders fetching data from necessary database
tables with option to print out.
(ii) Day and weekly appointment schedule from necessary database tables with option
for printouts.

C) DFD level 0 diagram

System Admin enter details of employee (receptionist) and dental staff directly into the database or
through the system which is not in the scope of the question but has been added for normalization.

Page 6 of 11
 Admin
Dental
Management
System

Employee Details entry

Employee Details Save employee details Employee

Dental Staff Details entry

Doctor Details Save dental staff details Employee

Receptionist Role:

Page 7 of 11
 Dental
Management
System
Receptionist

Patient details
Patient Records
Save patient details Patient_Details
Management

Retrieve patient ID and necessary details

Verify patient name

Appointment details
Appointment
Save appointment details Appointment
Booking

Cancel Appointment
Retrieve appointment number and details

Cancel
Update the appointment status
Appointment

Page 8 of 11
 Dental
Management Patient_Details
System
Receptionist

Retrieve patient phone number and name

Take printout Notification List Retrieve details before 2 days of appointment date

Appointment

Take printout

Day Schedule Retrieve daily appointment details

Take printout

Retrieve weekly appointment details

Weekly Schedule

Page 9 of 11
Dental staff (dental hygienist/assistant) role

Dental Hygienist

Dental
Management
System

Update the appointment status

Add comments

Schedule future visit Complete

Update the appointment status Appointment
Appointment

Insert comments update the date of schedule

Page 10 of 11
D) ERD diagram:

Patient_Nam
e
Patient_No Appointment
DOB PK
_No
Attending_R
PK eceptionist

Patient Patient_No Appointment

Phone_Num
ber Attending_D
ental_staff

Appointment
Allergies
_Date

Purpose_of_ Patient_No
Appointment
Chomic_Ailm
BMI
ents

Dental_staff_ Employee_ID
ID
PK
Employee
PK

Dental Staff

Is_Hygienist_
Or_Assistant
Employee_N
ame
Dental_Staff
_Name

_________________________
Faculty Signature
Page 11 of 11