Developers' tools

Again, again and again; developing proficient programs does not depend on your only technical skills but you should have some tools that help you in that
1- You should work on reputable OS like my beloved OS Microsoft Windows XP.
2- You should work on reputable IDE like Visual Studio 2005/.NET 2003
3- First and Second points in brief you should work on Microsoft products to make useful from the INTEGRATION they support to developers, only developers who work on multi-OSs or multi-IDEs know the difference between Microsoft and other technologies(SUN, IBM, so on)
4- Mirror, yes while developing new application you should look to yourself to discuss something with yourself like mmmmm, should I make this class abstract or base class what a datatype should I use in that column believe me you will find someone shares ideas with you and you won’t feel lonely :D
5- Sure, your girl should have a role in your work you should put her picture in front of you, that if you became so angry from something like your program hiiss (has fatal and logic error) or you fed up your boss you take a look on her beautiful eyes, you would feel something and you would have ability to debug and tolerate your silly boss
6- Telephone, only if you work in team, to call member from your team and curse him/her if they did something wrong (team leaders, software designers and software architects) included, you can curse them do not scare :)
7- Mobile, do not call your team from your mobile, you will be mulcted, but you should have a one to call your girl that misses you and you miss her, sure 24 hours/day and 30 days/month you coding, what a pity!, you have no time for her!!!
8- Paper and Pencil, never ever begin any developing for a program (small or big) on computer directly, you should decide on paper how will life move.
9- Working in clean and comfortable place.
10- I don’t know what else???! So I'll let you tell me your opinion

Thank you for reading
Ramy Mahrous

My CV

My CV last update was in 14/4/2006
To view my CV:
http://209.245.59.131/Gimme/56390915/324261445/93690466/3935545F-3433-489B-AD7A-7FE248A168B7/0.635015/2/RamyMahrous.doc

Data Normalization

In the name of ALLAH

Data Normalization

Abstract:

After gathering required information from end-users who are going to use your
application, you move to design database and you should spend sometime to design
it well because any mistake in your design would cost you a lot of effort, money
and time if your application built on it…

Introduction:

Data Normalization is the process of organizing information in your database
to should be able to develop professional code to update and retrieve data efficiently
and your code comes from a series of rules of standards called NORMAL FORMS

FIRST NORMAL FORM:

Let's execute that code [SELECT * FROM student] so the output is



It's definitely wrong as what about if I want to sort by Student's Last Name
I have no way except writing functions to do this job and that's wrong

After modification solution is:

Let's execute that code [SELECT * FROM student] so the output is


So now it's very easy to make all operations I need to sort by any attribute
and update and retrieve needed data

Let's execute that code [SELECT * FROM student] so the output is


Unquestionably very wrong to do that for many reasons first of them I can not
count all students who take Microsoft SQL Server 2005 course second what about
if a student intend to take another course you need to modify the schema or
the design of the relation and never ever put yourself in a case according to
it you may change your database schema, believe me if you did, you would be
fired, assume well to design well…

After modification solution is:



Now I can count all students who take any specific course and also update data
smoothly without any modification in database schema

So we can summarize FIRST NORMAL FORM as:

1- Each attribute in a relation should contain only one piece of information
that you can care about.

2- And also each piece of in formation that you can care about should be contained
in just ONE attribute.

SECOND NORMAL FORM:

It focuses on relation itself and its concepts are:

1- Database must be in FIRST NORMAL FORM.

2- Every attribute should be functionally dependant on the entire primary key.

3- Every relation should model just one entity, object or event.

Let's execute that code [SELECT * FROM student] so the output is



According to SECOND NORMAL FORM concept we see that relation violate SECOND
NORMAL FORM as CourseName dependant on to primary keys they are StudentID and
CourseID

After modification solution is to have two tables one for
StudentCourse and one for Course respectively as shown

Here, we divided first table to two tables to avoid violation
of SECOND NORMAL FORM as in last table CourseName became just dependant on CourseID.

THIRD NORMAL FORM:

Let us show what the concepts of the THIRD NORMAL FORM

1- Database must be in SECOND NORMAL FORM.

2- The attributes in addition to be dependant on entire primary key it should
not be dependant on another attributes.

3- Don't store any calculated or derived values, only store the raw data and
use queries to perform calculations and looks up as needed.

Let's execute that code [SELECT * FROM Item] so the output is


Here, all attributes dependant on ItemID as it's the primary key of this table
however the problem is in TotalCost as you see TotalCost is a calculated value
result FROM multiplication of ItemCost by ItemQuantity and that's a violation
of THIRD NORMAL FORM.

Conclusion:

As we saw applying normalization to our design is very easy and logical but
also not applying it will cost us a lot and a lot, and while designing large
database you will find some difficulty to achieve the equation that you must
attain performance, normalization, efficiency, all end-users requirements and
so forth so they are cases you should DENORMALIZE your design i.e. what about
if end-user asked you to store calculated or derived values in this case if
you didn't find solution you would be forced to say "Ok".

In the article I just mentioned 3 forms of NORMALIZATION and there are other
forms like Boyce-Codd normal form – BCNF, Forth normal form - 4NF and
fifth normal form - 5NF, may next article will mention them in details.

I appreciate your reading.

Thank you,
Ramy Mahrous