.NET Frame work consist of  CLR ( Common Language Runtime ) and BCL ( Basic Class Liberary )

Suppose we can consider the FX. (.Net Fram Work ) as a factory we find the manager of this factory is CLR and the material of this factory is BCL .

CLR responsible for (automatic memory management, Errors handling, Compilation).

note : Compilation means How to convert source code to native machine language? or How to execute the code?

BCL ( Basic Class Liberary ) such as C#, J#, C++, VB.NET.

The Execution Process done as the following:

1. Source code is converted to common Intermediate Language (CIL).

2. CIL is then assembled into bytecode and the .NET assembly is created.

3. upon executionof a .NET assembly its bytecode is passed through JIT (Just In Time Compilation) to generate native code.

4. The Native Code is executed by the computer’s processor.

CIL: Formally called the Micrsoft Common Intermediate Language or MSIL, is the lowest level human readable programming language defined by the common language Infrastructure specification and used by .NET and MONO on LINUX or UNIX.

note:  During the compilation of .NET programming language the source code is translated into CIL code.

JIT (Just In Time compilation): involves turning the bytecode into executable code by the CPU.

such as engineering, medicine, Sporting and other sciences the database has its own terminology

maninpulation of data is subject to certain rules that are set by developers these rules called constraints.

Not null: prevent null values from being used in the columns.

when an employee doesn’t have a mobile number then his/her mobile number is a null, and when every employee must have a name value then the name column is a not null column.

Note :: The null value is not the same as a zero or space. (Zero and Space are characters)

Unique Key: requires that every value in a column or set of columns must be unique. by another meaning no two rows of table can have duplicate values in specified column or set of columns.     i.e no two employees can have the same mobile number.

Note :: Unique constraints enable the input of null values in the unique columns but don’t allow of repeating.

Primary Key: is one or more columns whose values uniquely identify each row in a table.

Note :: primary key don’t allow using of null values and don’t allow repeating of values.

Foreign Key: column or a set of columns that contains logical pointers rather than physical data values and these logical pointers must refer to an existing primary key.

for example the department number in the employee table is a logical pointer that refers to the actual department number in the departments table.

With the foreign key constraint you can ensure that : achieving data consistency, data integrity, data redundancy.

Note :: any set of columns that constitute together one unique ,primary, or foreign key constraint is treated as single logical unit that is called a composite key or compound key.

In the previous period I were in exams of preliminary in computer science and finally I success and now in period of making decision of my life of work but in principle I decide to make my master in neural networks and artificial intelligence.

I’ll complete what i began in my blog to benifit all readers and my self and I’m very happy with all comments of you.

I’m very happy with success

Congratulations for me  for my blog

www.whpp.me

الحمد لله اليوم اصبحت مدونتي

.me

مبروك عليا

ايها القراءاتمني من الله ان يتم عليكم وعليا الصحة والعافية واستطيع افادتكم في مدونتي هذه

]]> http://whpp.me/blog/?feed=rss2&p=92 23 http://whpp.me/blog/?p=85 http://whpp.me/blog/?p=85#comments Thu, 29 Apr 2010 17:19:01 +0000 admin http://whitepaperandpencil.wordpress.com/?p=85 this person was so frightened from seeing life with its colors

to some extent in this depression is reduced

in this also to some extent  depression is reduced and start to see butterfly with its colors

in this image this person begin seeing butterfly and what’s around him

now his status is improved he decided to wear his jacket to go out

now he decide to color his life and buy a flower

now he returned to his home

he puts the flower at home and butterfly is stopped above it

Now he opens the window to permit the sun ray to light his home and his life

now he is wearing his colorful wear to go outside

Now he is gone outside with its colorful wears and lightening life

Now he buys more and more flower to color his home with more flowers

he returns to his home with flower bought it

Now he is enjoying with happy life and can see all aspects of happiness in any thing he do in his life

this person was so frightened to open his eyes and see the sweet things in his life but he decide to change his life when the colorful butterfly entered his home and decide to buy the best thing in the life (Flowers) and begin to make his home good and beautiful with putting flowers in every corner of his home and decide to enjoy with its life and see the best thing of his life not the worst thing.

I’ll explain basic concepts and table elements:

Basic Concepts:

Data and storage methods

Data: is a collection of facts about a person or a thing used to describe that person or thing like employee number, name, salary, hiring date and so on.

Data Storage methods: there are several ways to store data in computers according to the nature of the data you can choose the most suitable program to store your data.The most common types of programs for storing data are described as follow:

1. Microsoft Word for storing text and paragraphs in files.

2. Microsoft Excel for storing numbers, formulas and mathematical functions.

3. Microsoft PowerPoint for storing information in slides and shows.

4. Database Programs to store data in tables as we’ll see in the next blogs.

Databases

is an organized collection of logically related data stored in tables in order to provide some advantages described as follow:

- Linking data tables through relationships.

- Controlling data storing and retrieving.

- Maintaining data integrity and accuracy.

- Avoiding data redundancy and inconsistency.

- Storing and filtering data.

- Application programming.

Relational Database Management System(RDBMS)

RDBMS in an application that creates, organize and edits databases, display data through related tables using a system programming language. The most common RDBMS programs are Oracle, Microsoft SQL Server, Sybase, DB2, and Microsoft Access.

Database Applications

Depending on the abilities, tools and features of the chosen RDMS program, you can create different kinds of database applications as follow:

Desktop applications this meant to run on local computers only, represented single and standalone files. Microsoft Access is one of the most famous programs to create desktop applications.

Client/server applications this meant to run through database servers on any intranet environment such as internal or local networks.

Web applications this meant to run through database servers combined with Web servers on the internet. Web applications are three tier applications(Data tier, Business tier and presentation tier).

Note:

Oracle and Microsoft SQL server are the most famous and powerful database engines used to create client/server applications and/or Web applications.

Table Elements

Row is a set of different data types that describe one object for instance the first row in the previous table represent data about the employee’s last name is King.

Column represent one kind of the data for many objects in the table the 4th column in the table represent the department ID for all employees.

Field can be found at the intersection of the a row and column. there can be only one value in the field for instance the field between the second row and third column in the previous table represent the Job ID for the employee Kochhar.

I hope that I have to Benefit you

1. 0, 1, 2, 4, 6, 9, 12, 16, ?
What number should replace the question mark?

2. Which number is the odd one out?
9678 4572 5261 5133 3527 6895 7768

3.

???????????????

كان هناك نجار تقدم به العمر وطلب من صاحب العمل أن يحيله على التقاعد ليقضي بقية عمره مع أولاده وزوجته. ولكن  صاحب العمل رفض طلب النجار ورَغبه بزيادة راتبه إلا أن النجار أصَر على طلب التقاعد

فقال له صاحب العمل إن لى عندك رجاءً أخيرأً وهو أن تبني منزلا وسيكون هذا آخر عمل لك وبعد الإنتهاء منه سأوافق على طلبك بالتقاعد. وافق النجار على مضض

وبدأ النجار العمل ولعلمه أن هذا البيت سيكون الأخير فلم يحسن الصنعة واستخدم مواد رديئة  وأسرع في الإنجاز دون الجودة المطلوبة. وكانت الطريقة التي أدي بها العمل نهاية غير جيدة لعمر طويل من الإنجاز والتميز والإبداع

وعندما انتهى النجار العجوز من البناء سلم صاحب العمل مفاتيح المنزل الجديد وطلب السماح له بالرحيل إلا أن صاحب العمل استوقفه وقال له : إن هذا المنزل هديتي لك نظير سنين عملك معي فآمل أن تقبله مني

فصعق النجار من المفاجأة لأنه لو علم انه يبني منزل العمر لما تواني في الإخلاص في الأداء والإتقان في العمل

وقال رسول الله صلى الله عليه وسلم : إن الله تعالى يحب إذا عمل أحدكم عملاً أن يتقنه

فكل منا في حياته مثل هذا النجار يبني سمعته بعمله ويبني بيته بعمله فيجب عيلنا ألا نتوانى في الإخلاص وأن تقن عملنا في كل الأوقات ومهما كانت الظروف مع العلم أن العمل بإخلاص يريح العامل ويريح صاحب العمل من المشاكل التي قد تظهر فيه فيما بعد

العمل بإخلاص وبإتقان يقربنا من الله تعالى ويجلعنا ذو سمعة نظيفة ويريح بالنا من العمل الذي نقوم به

Organizational Levels are described as in the following image:

the four organizational levels and their responsibilities , decision making styles and information systems requirements are described in the following image:

Operational personnel: Perform a company’s repetitive day-to-day functions following well defined procedures.

Lower Management: Supervises operational personnel and establishes the day-to-day plans,based on direction and longer range plans from higher levels of management.

Middle Management: Focuses on the short range, tactical time frame, usually in the range of one month to one year.

Top Management: is responsible for long range, strategic time frame measured in one or more years. establishes overall company policies and goals, determines when organizational restructuring must occur and sets new directions for the company in terms of producers services and acquisitions.

Types of information system that use computers divided into four types as follow:

1. Operational System: system designed to process data generated by day to day business transaction of company for example operational system are accounting, and billing. Note the operational system are called transaction processing systems.

2. Management Information Systems(MIS): refers to a computer based system that generates timely and accurate information for the top, middle and lower levels of management. for example to process  a sales order would record the sales, update the customer’s accounts receivable balance and make a deduction from the inventory but in the management information system reports would be produced that show slow or fast slowing items, customers with past due accounts receivable balances and inventory items that need recording. In the management information system the focus in on the information that management needs to do its job.

3.Decision Support System (DSS): is a system designed to help someone reach a decision by summarizing or comparing data from either or both internal and external sources. Internal sources include data from an organization’s file such as sales, manufacturing  or financial data.External sources could include information on interest rates, population trends or new housing. Decision support system often include query languages, statistical analysis capabilities, spreadsheets and graphics to help and evaluate the decision data.

4. Expert Systems : combine the knowledge on a given subject of one or more human experts into a computerized system that simulates the human experts reasoning and decision making process.