Identifies the functions of a computer system



Download 123.29 Kb.
Page4/5
Date02.02.2024
Size123.29 Kb.
#63405
1   2   3   4   5
Assignment On Computer Fundamentals
Presentation on Computer Fundamentals & DBMS, task
Relational database:


Data classification: database administrators can easily categorize and store data in the relational database which can then be interviewed and filtered to extract information for reports.


Accuracy: Data is stored only once, eliminating duplication of data in stored procedures.


Easy to use: Complex queries are easy to perform with SQL, the main query language used with relational databases.


Collaboration: several users can access the same database.


Security: Direct access to data in RDBMS tables may be limited to specific users.


Reference: https://searchdatamanagement.techtarget.com/definition/relational-database
Normalisation database:



  1. Updates run quickly because no data is duplicated in multiple places.

  2. Insertion is fast because there is only one insertion point for one data and no copying is required.

  3. Tables are typically smaller than those found in non-standard databases. This generally allows the tables to fit in the cache, thus providing faster performance.

  4. Data integrity and consistency is an absolute must if the database is ACID compliant. A standardized database is of great help in such an endeavor.



Reference: https://dzone.com/articles/pros-and-cons-of-database-normalization
1   2   3   4   5




The database is protected by copyright ©ininet.org 2024
send message

    Main page