In The Management Information System Subject 1 Describe how

In The Management Information System Subject;

1) Describe how models that were developed during system analysis are used during system design.

2) Describe database normalization. What is the goal of normalization? What is involved in ensuring that a table in a database is in 3^rd normal form.

Solution

1) System analysis means gathring of information,needs,requirementfor the system from the client.Whenever the   system get designed,the designer or developer design such a model that will help to visualize the world in which your system works .It not only define the user needs but also analyze the code and architecture of the system that will ensure that your program meets the requierement and help to reduce the error,ambiguty in the system design.

2) Normalisation is the technique that will be used organise the information,data in the database to eliminate the repitetion of the data or the information.It is also useful for the certain data or information that will enable to represent.

Third normal form are ensured when an attribute that does not occur in any candidate key i.e non prime attribute of the table depend on primary key.for example,consider a table with following fields.

Consider the obove table in that Customer_id is Primary key, but street, city and state depends upon Pin_code. The dependency between Pin_code and other fields is called transitive functional dependency. Hence to apply 3NF, we need to move the street, city and state to new table, with Pin_code as primary key.