Database Management Systems CS403 Assignment no 1 Idea solution Spring 2011

[Xpert]

[FONT=&quot]Q 1. State the significance of DFDs in the process of Database designing.[/FONT][FONT=&quot] [/FONT][FONT=&quot](5)[/FONT]
[FONT=&quot]Q 2. Draw a Context and level 0 Data Flow Diagrams of mobile SIM registration System. Guidelines are given below[/FONT][FONT=&quot]. (3+7)[/FONT][FONT=&quot] [/FONT]
[FONT=&quot]Guidelines / Requirements:[/FONT]
[FONT=&quot]The context level diagram must contain a major process and external entities.[/FONT]
[FONT=&quot]Level 0 diagram must consist of major functions and should work as follows: [/FONT]
[FONT=&quot] [/FONT]
Ø There should be 3 streams, or flows of data.
(i) The customer request to buy a number of his choice, system check the availability of number and get the details of customer for SIM card registration.
(ii) Bill will be generated on behalf of SIM card and customer detail.
(iii) And finally customer gets the SIM after payment in cash.

[FONT=&quot] [/FONT]
[FONT=&quot]Before Starting you should study and understand:[/FONT][FONT=&quot] [/FONT]
· [FONT=&quot]Significance of[/FONT][FONT=&quot] [/FONT][FONT=&quot]DFD[/FONT]

· [FONT=&quot]Rules for drawing DFDs [/FONT]

I will upload the video with practical soon