Key Points - Advanced Programming Development Methodology

1. What is a system?

2. Steps in SDLC a) Preliminary study/survey c) Investigation and fact recording e) System design g) Testing b) Feasibility study d) System analysis f) Coding h) Implementation and maintenance
Block Diagram for SDL

3. Tools used for system analysis a) Data flow diagram DFD b) Process chart c) Data dictionary d) Decision table e) Decision tree
System : A system is a collection of interrelated different component which work together. For eg. A computer system is a collection of H/W and S/W.
1. Prilimnary Study/Survey: This is a very first step for developing a system.During this phase the main effort is given on the problem with the existing system.here the key question is “why do we need to develop a new system”,”what is the problem with the existing system”.Here the system analyst do the requirement analysis.
2. Feasibility Study: In this phase we find out whether the new system is worth Developing or not, means the organization will be benefited by the new system or not. Does the organization has all the facilities, all the tools for developing a new system. After the feasibility study a feasibility report is prepared and if the report is positive new system is approved to be developed.
There are 3 types of feasibility study: a) Economic F.S : In this F.S the analyst do the cost-benefit analysis that is how much cost would be required for the system to be developed and whether the benefit will outweigh the cost. If benefit is more than the expenditure or cost then it is approved. b) Technical F.S : In this F.S technical requirements are looked for like whether the technical software or hardware needed to develop a s/w are easily available.
c) Behavioural F .S : In this F.S it is checked whether the people or the users will be comfortable with the new s/w as they need to be trained on the usage of the software.
After all three types of FS if all are positive the system analyst moves on to the next step.
3. Investigation and fact recording: In this Phase information and facts or raw data is collected for the new system. For this analyst applies the following procedures: a)Interviewing : Interview is taken individually from the employees. b)Questionaires: set of Questions are given to everyone and answers are collected to know about the problem. c)On site observation: By really going on to the site and watching the actual working of the organization without letting the people to know that they have been watched. d) Sampling : To collect or calculate some thing on large data , some samples are collected randomly on weekly or monthly basis and then calculation is done. e) Reviewing of the manuals: Last option is to view or by reading the documents and manuals of the organization.

4. System Analysis: In this phase complete analysis of the current system is done in order to reach at the specifications of proposed new system. following points are analyzed:a) b) c) c) d) e) f) g)
Goals and objectives of the the proposed system.
Fundamental actions that must take place in the s/w
Outputs to be produced
Inputs to be used
Process es to be performed
Interfaces to be provided
Performance requirements to be met.
Organizational and other constraints to be met.

5. System design: This phase is concerned with the design of final system. Here the modules for the new system are designed and the relation between the modules. Following diagram shows the steps Of designing.
1.output design
Processin g design
Detailed system documentation input design
File design
Design submitted to management
No
Design accepted
Abandon project
Yes
Test programs

6.Coding : In this phase a particular language is taken and programming is done or coding is done for that new system.For ex c,c=+,java,.net etc
7. Testing: After coding testing is done .In testing it is checked whether the s/w is working according to the need and requirements of the user. Whether the s/w is running successfully without any error and is running for all types of data combinations.
Types of Testing: a)Online Response: Online Response of the system is checked. b)Stress Testing:
In this Testing System is checked under heavy workloads. c)Volume Testing: In this large no of data transaction is teseted to ensure the proper functioning of hardware and software. d)Recovery Testing: System is forced to have failure so that recovery can be tested. e)Unit Testing:
In this testing each or individual module is tested for errors and proper functioning. f) Integration Testing: In this integration of modules is done and proper interface of the modules with each other is tested.

7.Implementation: After all this The new system is finally implemented means used by the Clients for whom the s/w has been developed.It is used by the end users.In this phase training to the users is provided on the newly made s/w.

8.Maintenance : The last step is maintenance. Maintaining and updations of the s/w from time to time is very nessesary as the needs of the user changes periodically So the new requirements need to be incorporates into the s/w.
Hardware maintenance is also necessary which aids in the proper functioning of s/w.

Maintenance is of 3 types
1.Corrective maintenance 2) Adaptive maintenance 3) Perfective maintenance

Entity Relationship Model
ER model is a high level, conceptual model that describes data as entities, attributes, and relationships.

Entity
A real world object is called entity. An entity can be a person, place, thing or any concept.
An entity is an object that exists and is distinguishable from other objects.

Example:
Car
Person
Animal
Entity Type:
Example:
Entity Instance:
Example:
An entity type is a set of same type, which share common properties.
Car
Entity instance is example of an entity.
Indica, Santro, Zen, Maruti
Attribute:
Example:
Properties or characteristics of an entity.
Student (R no, Name, Class, Marks)
Note: Where Rno, Name, Class And Marks Are Attributes Of Student Entity.

TYPES OF ATTRIBUTES
1. Key attribute
2. Simple single value attribute
3. Composite attribute
4. Single value attribute
5. Multivalued attribute
6. Derived attribute

1. KEY ATTRIBUTE:
A key attribute uniquely identifies an entity instance.

Example:
Student (Rno, Name, Class)
Here RNO is key attribute because by RNO each student uniquely identified.

2. Single Value Attribute: An Attribute That Contains Only One Value For An Entity Instance.
Example:
Student(Rno , Name, Class)
One student can have only one RNO, NAME or CLASS.

3. Multivalued Attribute:
Example:
An attribute that contains more than one value for an entity instance.
Student(Rno , Name,Hobby, Class)
Rno
Name
Hobby
1
Ram
Singing,Painting
2
Geeta
Reading
3
Shyam
Singing
One student can have more than one hobbies. So, it is multivalued attribute.

4. Simple Attribute: An Attribute That Can Not Be Broken Into More Than One Attributes.
Example:
Student(Rno , Name, Class)
Rno, Name And Class Can Not Be Broken Into Parts.

5. Composite Attribute: An Attribute That Can Be Broken Into More Than One Attributes.
Example:
Student (Rno, Name, Class, Address)
Rno
1
2
3
Name
Ram
Geeta
Shyam
Hs_no
1. 2.
1.7
Colony
Lig
Morar Cantt
Sai Colony
City
Indore
Gwalior
Rajpur
Address
Hs_no
City
Colony
Address is composite attribute i. e. broken into HS_NO., COLONY & CITY attributes.

6. Derived Attribute:
Example:
A derived attribute’s value is derived from another attribute.
Student (Rno, Name, Class, Address)
Age = Current_date – Date_of_birth
Here AGE is derived attribute because its value depends on CURRENT_DATE and
Date_of_birth.
Relationship

Association among several entities. A relation is represented by a diamond symbol. Each relatin can have a nameand properties also.
Example: Teacher Teaches Students.
Types Of Relationship: 1.
One-to-one/ 1:1 / | |
2. One-to-many Or Many-to-one/ 1:M /
3. Many-to-many/M: M
One-to-one: For Each Instance Of One Entity There Exist Only One Instance Of Another Entity.
Example: One person can married with only one person.
Married
To
Person
Person
One-to-many: For each instance of an entity there may be exist more than one instances of another entity.
Example: One country can have more that one states.
Has
Country
State
Many-to-many: For Each Instance Of An Entity There May Be Exist More Than One Instances Of Entity B And Vice Versa Also Possible.
Example: One Employee Can Be Assigned To More Than One Project & One Project Can Be Handled By More Than One Employees.
Assigned
Employee
Project
Degree Of Relationship
1. Unary

Number of entity is 1 involved in a single relation.
2. BINARY

Number of entities 2 involve in a single relation.
3. TERNARY: Number of entities 3 involve in a single relation.

Supertype & Subtype
An entity that can be classified into more than one entities (subtypes) is called supertype.
Example: Supertype: Patient(Pname,Add)
Subtype:
Inpatient (Ward_no, Bed_no.)
Outpatient (Next_apppintment)
Cardinality
Participation or involvement of entity instances in a relation.

Types Of Cardinality
1. Optional (Minimum No. Of Instances Can Be Zero)
2. Mendatory (Minimum No. Of Instances At Least One)
Assigned
Movie
Videotape
In a videoshop if videotape available than its is of some movie means for existence of videotape, the existence of movie is compulsory but for existence of movie the existence of videotape is not compulsory. Participation of movie is mandatory but participation of videotape is optional.

Example of ER-Diagram
Consider a university database for scheduling for classrooms for final exams. There are exams taking place for various courses. Each course has a unique name, department and a course number. For each course there may be many sections. Sections have a section_number and enrollment. There are multiple rooms available in various buildings. Each room is identified room_number, seating capacity and building_number and is reserved for one or more courses exam. For each exam date and time are stored.

Steps of developing an ER diagram:
1. List all entities, attributes and relationships.
2. Find types of relationship and cardinality between entities.
3. Draw ER diagram according to given standard notations.

Capacity
R_no
C_no
Cname
Exam
Takes
Place In
Course
Room
Dept
Section
Date
S_n
O
Time
Enro
L