Week 7 Blog Nisha

 

Week 7 Blog

 

 

 

1.      What were the most important concepts you learnt this week?

2.      Why do you think those concepts are important?

3.      What concepts from this week are causing you the greatest problems?

4.      How might the problems you are having be solved?

 

 

 

 

1.     The Most Important Concept learnt this week:

·        Data Design Concepts

·        File Processing system and various types of file.

·        Database system and components of database management system

·        Web Based data design

·        Concept of normalization

·        Importance of code and various coding schemes

·        Relational and object-oriented database models                                               

·        Data warehousing and data mining

·        Logical and physical storage and records

·        Data control measures

 

 

2.     These concepts are important because of the                         following reasons:

·        Data structures consist of files and tables about place or thing or event that interact with the system and stores and manage data in one or more separate files

·        Database systems consist of linked tables that form one overall data structure.

·        A properly design database system offers a solution to the problem of file processing

·        provides an overall framework that avoids data redundancy and supports a real  time, dynamic environment

·        Database management system offers timely, interactive, flexible data access, scalability, better support for client/server systems, and economy of scale, flexible data sharing, and enterprise wide application-database administrator, strong standards, controlled redundancy, better security, increased programmer productivity, data independence.

·        The query language allow user to specify a task without specifying how the task be accomplished

·        DML (Data Manipulation Language) controls database operations, including storing, retrieving, updating and deleting data.

·        The complete definition of a database, include description of all fields, tables, and relationship is called a schema.

·        In the web based design internet serves as the front end or interface for the database management system.                                 

·        Internet technology provides enormous power and flexibility and offer ease of access, cost-effectiveness, and worldwide connectivity

·        Intranet provides web based access to internal user and extranet allows access by external users.

·        Entity Relationship diagram is a model that shows the logical relationships and interaction among system entities and provide blue print for creating the physical data structures.

 

 

3.     The concepts causing the problem and there solutions are:

Problems related to database:

·        Data redundancy- Data that is common to two or more information system in several places.

Solution:

     The problem of redundancy can be solved by the centralization of data and this                                   result in data that is common at single place and allow sharing from there  wherever it is needed.

·        Data integrity problems can occur if updates are not applied in every file.

         Solution:

The problem of data integrity can be solved by updating data in each file and by the centralization of data as the redundancy is removed the update in one file result in constant information in every file.

·        Data security that is the web-based data some time lost or due to unauthorized access it is destroyed or used by fraud by competitiors.

Solution:

The security must be applied at all the levels that is at database itself, the web server, and the telecommunication links that connect the components of the system