See discussions, stats, and author profiles for this publication at: https://www.researchgate.

net/publication/269105794

Fundamentals of System Analysis & Design

Book · November 2014

DOI: 10.13140/2.1.1469.7280

CITATIONS READS
0 49,920

1 author:

Alireza Salehi Nejad

University of Tehran
71 PUBLICATIONS 327 CITATIONS

SEE PROFILE

Some of the authors of this publication are also working on these related projects:

EU & Brexit View project

Political Communication View project

All content following this page was uploaded by Alireza Salehi Nejad on 13 January 2015.

The user has requested enhancement of the downloaded file.




            
        
                    
              
                
     !                "
     #$%             
                 !   

       

    "     
    
     & '  (   )     
                  
                    
   
          
          


   

*+,   

  

  # "
  
  "    -          
 
  !    #  
.      .   / 
 .      
     .    
    




   

   
   



   

   
  

 



 !"
##$ 


 


  
  

 
   

 
   
 
 
 


 
   
 
  
 




 ! 
  

"

 

 
# 

 

$  !%
 !

   
& 
$

'  

 
'  

($
 

' 

# %
 %
)   %
*   %
'  
 $

 
'
 

 
 
+ 
 


" %

 
 

&

'  !

#   



 
$,

 

( 

$
 

  
  
 
-
 
 
   
. 
 
   
 
 
 

 
 
   
 
  
 

  

 


 ! 

"-
 
 

 
 


 


( 

  %
 

 
 


  

 
  

 
  

. 
 

 
  %
 
  %

  %
 
  %
 
 


$ 

   
 

 
$



$ -


 

 
 

 
 -

 

  

  

  

 
 
  


 

 
-
-

/

/
 
$$$   

0 

 

1"
1"#23.
" 
 
 






  

4& 
)*
5
/
+)
* !6 !&
7!8%
779:9
&  %
  

) -
2 
 ; !  

* 
 

&





 
 



/- 
<
:=9>
4& 
)*
5
/
+)

"
3 
 

"
 
 
&  
:=9>
 Fundamentals of System Analysis & Design


Table of contents:

Table of contents:.......................................................................................................................iv
Acknowledgments:......................................................................................................................1
Chapter I .....................................................................................................................................2
Business System Analysis, Design and Construction..................................................................2
Abstract: .....................................................................................................................................3
Introduction: ...............................................................................................................................4
System analysis: ...............................................................................................................5
System analysis and design:..............................................................................................6
Systems analysis, design, and programming: ...................................................................8
Problem definition: ...................................................................................................................10
Problem identification: ..............................................................................................................11
Additional Concept: ..................................................................................................................13
Attendance Requirements...................................................................................................13
Steps to implement the solution:................................................................................................14
Using Spreadsheets to Keep Track of Students' Grades .............................................................15
Setting up the grade sheet...................................................................................................15
Converting letter grades to numbers ...................................................................................15
Converting numbers to letter grades ...................................................................................16
Weighted grades ................................................................................................................17
Missing grades and averages ..............................................................................................18
Dropping lowest grades......................................................................................................19
Additional Recommendation: ....................................................................................................21
Feasibility: ................................................................................................................................22
Data Flow Diagram: ..................................................................................................................24
Conclusion: ...............................................................................................................................26
Bibliography: ............................................................................................................................27

ƒ‰‡v
 Alireza (Arash) Salehi Nejad

Chapter II..................................................................................................................................29
Easy Reading Online Bookstore System....................................................................................29
Introduction: .............................................................................................................................30
Project Proposal: .......................................................................................................................31
Aim: ..................................................................................................................................31
System Overview: .....................................................................................................................32
Assumption:..............................................................................................................................35
Database Assumptions: ......................................................................................................35
System Assumptions: .........................................................................................................36
Benefits:....................................................................................................................................37
Development of Approach: .......................................................................................................38
Entity Relationship Diagrams (ERD): .......................................................................................39
Logic Steps: ..............................................................................................................................40
Normalization: ..........................................................................................................................41
Unnormalized Data: ...........................................................................................................41
First Normal Form: ............................................................................................................42
Explanation:..............................................................................................................................45
Explanation:.......................................................................................................................47
Second Normal Form: ........................................................................................................48
3rd Normal Form:...................................................................................................................51
Explanation:.......................................................................................................................51
Relational Table Structure:........................................................................................................54
tblCSP: ..............................................................................................................................55
tblOrder: ............................................................................................................................55
tblPurchases: ......................................................................................................................56
tblGame: ............................................................................................................................56
tblDVD: .............................................................................................................................57
tblMusic:............................................................................................................................57
tblBook:.............................................................................................................................58
Development:............................................................................................................................59

ƒ‰‡vi
 Fundamentals of System Analysis & Design

Site Map: ...........................................................................................................................59
Story Board:..............................................................................................................................60
Home Page: .......................................................................................................................60
Careers Page: .....................................................................................................................61
About the Company Page:..................................................................................................62
Contact us Page:.................................................................................................................63
Registration Page: ..............................................................................................................64
View Item Details Page:.....................................................................................................65
Add to Cart Page:...............................................................................................................66
View Cart Page: .................................................................................................................67
Customer Information Page:...............................................................................................68
Purchasing Page:................................................................................................................69
Purchase Ticket Page: ........................................................................................................70
Customer Service Personal Information Page: ....................................................................71
Customer Service Personal Orders Page: ............................................................................72
Customer Service Personal Edit Orders Page: ....................................................................73
Management Report 1 Page: ..............................................................................................74
Management Report 2 Page: ..............................................................................................75
Database Code Structure: ..........................................................................................................76
Data Definition Language:.....................................................................................................76
Accounts Table: .................................................................................................................76
Customers Table: ...............................................................................................................77
Customer Service Personal Table: ......................................................................................78
Orders Table: .....................................................................................................................79
Purchases Table: ................................................................................................................80
Games Table: .....................................................................................................................81
DVD Table: .......................................................................................................................82
Music Table: ......................................................................................................................83
Books Table:......................................................................................................................84
Data Manipulation Language: ...................................................................................................85

ƒ‰‡vii
 Alireza (Arash) Salehi Nejad

First Report:.......................................................................................................................85
Second Report:...................................................................................................................86
Testing: .....................................................................................................................................87
Test Plan: ..............................................................................................................................88
Testing Table: ....................................................................................................................89
Conclusion: ...............................................................................................................................90
Bibliography: ............................................................................................................................91

ƒ‰‡viii
Buy your books fast and straightforward online - at one of the
world’s fastest growing online book stores! Environmentally sound
due to Print-on-Demand technologies.

Buy your books online at

www.get-morebooks.com
Kaufen Sie Ihre Bücher schnell und unkompliziert online – auf einer
der am schnellsten wachsenden Buchhandelsplattformen weltweit!
Dank Print-On-Demand umwelt- und ressourcenschonend produziert.

Bücher schneller online kaufen

www.morebooks.de
OmniScriptum Marketing DEU GmbH
Heinrich-Böcking-Str. 6-8 info@omniscriptum.de
D - 66121 Saarbrücken Telefax: +49 681 93 81 567-9 www.omniscriptum.de
View publication stats