The implementation of web based system for the improvment of good governance in the development of rwandan districts.
par Herménégilde HUNDWITIRO
National University of Rwanda - Bachelor Degree 2009
2.3.1. Definition and terminology 184.108.40.206 Definition
A database is a collection of information related to a particular subject or purpose.( RIHARD, T. WATSON,» DATA MANAGEMENT : Databases and Organization « , 3rd edition .p25) .
Data refers to pieces of information or facts usually collected as the result of experience, observation or experiment, or processes within a computer system, or a set of premises.
( Retrieved March 21.2009.from; http// www.wikipedia.org/wik/data)
Information is data that has been processed in a way that it makes it meaningful. Databases are designed to provide meaningful information .This information can only be provided if appropriate data exists in the database and the database is structured in such a way to support that information(PRESCOTT,M,& ALL « Modern Database Management»,5 edition, Addison Wesley Lonman , Inc, May 1999.p 4.)
A. Entities and Relationships
The very basics of what we are trying to model are entities and relationships. Entities are things in the real world that we will store information about in the database. Relationships are the links between these entities. Relationships come in different degrees. They can be one-to-one, one-tomany (or many to one depending on the direction you are looking at it from), or many to many. (GERAL V .POST «Database Management Systems, Designing and Bulding Business Applications 1st edition P34.)
Note that the entities, the relationships, and the degree of the relationships depend on your environment and the business you are trying to model. When you are coming up with a database design, you must take these rules into account for the system you are modeling .No two systems will be exactly the same.
In the relational model of databases, a set of tuples (also called rows), otherwise known as a table.
A foreign key (sometimes called a referencing key) is a key used to link two tables together. Typically you take the primary key field from one table and insert it into the other table where it becomes a foreign key (it remains a primary key in the original table).
(Retrieved from March 21.2009.from,http://databasev.co.uk/ primary- foreign-keyconstraints.html ,)
2.3.2. Database design principles 220.127.116.11 Redundancy
Data redundancy is a data organization issue that allows the unnecessary duplication of data within your database. (Retrieved March 21.2009.from http://databasev.co.uk/ primary- foreignkey-constraints.html).
A change or modification, to redundant data, requires that you make changes to multiple fields of a database.
Anomalies present a slightly more complex concept. Anomalies are problems that arise in the data due to a flaw in the database design. There are three types of anomalies that may arise:
needs to be deleted from only one place in the database, in an inadequately normalized database, information about that old entry may need to be deleted from more than one place.
(Retrieved March 21.2009.from , http://www.dbnormalization.com /database-anomalies,)
C .Update Anomalies
An update of a database involves modifications that may be additions, deletions, or both. Thus «update anomalies» can be either of the kinds discussed above.
All three kinds of anomalies are highly undesirable, since their occurrence constitutes corruption of the database. Properly normalized database are much less susceptible to corruption than are un-normalized databases. (Retrieved March 21.2009.from , http://www.dbnormalization.com /database-anomalies,)
18.104.22.168 Null Values
A final rule for good database design is that we should avoid schema designs that have large numbers of empty attributes.
Normalization is a method of organizing your data to prevent redundancy. Normalization involves establishing and maintaining the integrity of your data tables as well as eliminating inconsistent data dependencies. (Retrieved March 21.2009.from , http://www.databasev.co.uk/ data-redundancy.html,)
Normalization requires that you adhere to rules, established by the database community, to ensure that data is organized efficiently. These rules are called normal form rules.
The rules are defined as follows:
(Retrieved March 21.2009.from , http://en. wikipedia.org/wiki/Normal forms ,)
22.214.171.124. First normal form (1 NF)
Table faithfully represents a relation and has no "repeating groups".
126.96.36.199. Second normal form (2NF)
No non-prime attribute in the table is functionally dependent on a part (proper subset) of a
188.8.131.52 .3rd normal form (3NF)
Every non-prime attribute is non-transitively dependent on every key of the table.
184.108.40.206. Boyce-Codd normal form (BCNF)
Every non-trivial functional dependency in the table is a dependency on a superkey.
220.127.116.11. Fourth normal form (4NF)
Every non-trivial multivalued dependency in the table is a dependency on a superkey.
18.104.22.168. Fifth normal form (5NF)
Every non-trivial join dependency in the table is implied by the superkeys of the table.
22.214.171.124. Domain/key normal form (DKNF)
Every constraint on the table is a logical consequence of the table's domain constraints and key
126.96.36.199. Sixth normal form (6NF)
Table features no non-trivial join dependencies at all (with reference to generalized join
2.3.4. Database management system
A database management system (DBMS) is computer software that manages databases. DBMS's may use any of a variety of database models, such as the network model or relational model. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way.
(Retrieved March 22.2009. from, http://wikipedia.org/wiki/Database-management-system,)
2.3.5. Data processing architecture
Data architecture describes the data structures used by a business and/or its applications. There are descriptions of data in storage and data in motion; descriptions of data stores, data groups and data items; and mappings of those data artifacts to data qualities, applications, locations etc. (Retrieved March 22.2009. from , http://wikipedia.org/wiki/Data-architecture).
Essential to realizing the target state, Data Architecture describes how data is processed, stored, and utilized in a given system. It provides criteria for data processing operations that make it possible to design data flows and also control the flow of data in the system.