Question

Prepare Level 3 DFD diagram on Passport Automation System.

Also Prepare E-R (Entity Relationship) diagram on Passport Automation System.

Based on the points :

1. User signup : User Registration , Enter Required Details , Login to continue ..... 2.Application form : Fill the application form,Update Required details, Records stored in database.... 3.Submit the application : By Mail , By Courier

4. Passport fee : Credit Card , debit Card ... 5. Appointment Scheduling .... 6.Verifying the documents : Proof of Canadian Citizenship, Documents supporting identity,Two identical passport photos

7. POlice Enquiry : Applicant Name, Age ,Address,Two references verified... 8.Passport Request :Generation of passport printout , email sent to applicant ... 9.Passport status :Status check request, check status 9.. REceving Passport :Dispatch of passport via mail, Confirmed passport identity, Passport Received

Answer 1

1. Level 3 DFD diagram on Passport Automation System

I have uploaded below the DFD diahram for the system explainimg all the processes, external entity and attributes together.

DFD(data flow diagram) represents the system of different levels of abstraction.

2. E-R (Entity Relationship) diagram on Passport Automation System.

I have created an ER diagram for the following system with 6 entities/tables-

• USER
• APPLICATION
• STATUS
• SHIPPING
• DOCUMENTS
• PASSPORT FEE

​​​​​​​