Three Benefits of a Relational Database
Three Benefits of a Relational Database
Benefits of a relational database: https://www.sunadal.co.uk/db.php
Advantages of using a relational database: http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/index.jsp?topic=%2Fcom.ibm.itnetview.doc%2Fanmdbmst18.htm
Relational Database Systems: http://www.orafaq.com/wiki/Relational_Database_Systems
Three main benefits of a relational database are report generation, data storage, and data integrity. When putting information in a relational database the possibilities for running reports from the tables that have been created in the database are endless. As long as the information is organized well, the end user can create queries to generate reports based on the data that has been entering into the database. Another great benefit for creating a relational database is the data storage. Data is stored in tables that have a primary key which holds the identification of that data. It assures the end user that there is no duplication of data and helps to reduce data redundancy. Data integrity assures the end user or database administrator that the data that created follows the rules that are applied so that when reports are generated or queries are created that the data that the end user sees is accurate and good. If integrity rules are created with the relational database then it limits the end user of the type of data they can enter into those fields within those tables.
Terms that was unfamiliar:
1. Normalization = the process of organizing the fields and tables of a relational database to minimize redundancy.
2. Entity = an entity is most easily thought of as a person, place, or physical object; an event; or a concept.
3. Queries = a request for information from a database.
4. Attributes = a piece of information about the entity.
5. Clustering = a data mining technique used to place data elements into related groups without advance knowledge of the group definitions.
I am a technical writer and editor and
Benefits of a relational database: https://www.sunadal.co.uk/db.php
Advantages of using a relational database: http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/index.jsp?topic=%2Fcom.ibm.itnetview.doc%2Fanmdbmst18.htm
Relational Database Systems: http://www.orafaq.com/wiki/Relational_Database_Systems
Three main benefits of a relational database are report generation, data storage, and data integrity. When putting information in a relational database the possibilities for running reports from the tables that have been created in the database are endless. As long as the information is organized well, the end user can create queries to generate reports based on the data that has been entering into the database. Another great benefit for creating a relational database is the data storage. Data is stored in tables that have a primary key which holds the identification of that data. It assures the end user that there is no duplication of data and helps to reduce data redundancy. Data integrity assures the end user or database administrator that the data that created follows the rules that are applied so that when reports are generated or queries are created that the data that the end user sees is accurate and good. If integrity rules are created with the relational database then it limits the end user of the type of data they can enter into those fields within those tables.
Terms that was unfamiliar:
1. Normalization = the process of organizing the fields and tables of a relational database to minimize redundancy.
2. Entity = an entity is most easily thought of as a person, place, or physical object; an event; or a concept.
3. Queries = a request for information from a database.
4. Attributes = a piece of information about the entity.
5. Clustering = a data mining technique used to place data elements into related groups without advance knowledge of the group definitions.
I am a technical writer and editor and