Page 66 - CITS - Computer Software Application -TT
P. 66
COMPUTER SOFTWARE APPLICATION - CITS
table/Relation
All contents within a relational database are organized into relations. RDBMS databases utilize tables for data
storage. A table constitutes an assembly of interconnected data elements, arranged in rows and columns. These
tables symbolize real-world entities, like individuals, locations, or occurrences, for which data is accumulated.
The systematic arrangement of data within a relational table embodies the conceptual portrayal of the database.
Properties of a Relation
• Every relation within the database possesses an exclusive name for distinct identification.
• Within a relation, duplication of tuples is prohibited.
• Tuples within a relation are unordered.
• All attributes contained in a relation are indivisible; each cell comprises a singular value.
• A table serves as a fundamental illustration of data storage within RDBMS
Benefits(Advantages)
1 Ease of Management: Independent manipulation of tables simplifies database management without impacting
others.
2 Enhanced Security: Multiple layers of security ensure controlled data access and sharing.
3 Flexibility: Centralized data updating prevents the need for modifications across various files. Expanding the
database to include more records is straightforward, ensuring scalability. SQL queries can be applied easily.
4 User Support: RDBMS accommodates multiple users through a client-side architecture.
5 Efficient Data Handling
- Rapid data retrieval due to the relational design.
- Keys, indexes, and normalization minimize data redundancy.
- ACID properties ensure data consistency during transactions.
6 Large Data Storage and Retrieval: RDBMS facilitates handling vast data volumes.
7 Effortless Data Handling
- Swifter data fetching resulting from relational structure.
- Keys, indexes, and normalization principles avert data redundancy.
- Data consistency maintained through ACID properties in transactions.
8 Fault Tolerance: Database replication permits simultaneous access and aids system recovery during crises
such as power outages or abrupt shutdowns.
Drawbacks(Disadvantages)
1 High Costs and Infrastructure: RDBMS demand substantial investments in terms of both expenses and
infrastructure to establish and maintain their operations.
2 Scalability Challenges: Expanding data necessitates additional servers, increased power, and memory
resources, which can be complex and costly.
3 Complexity: Large datasets can result in intricate relationships that might impede comprehension and even
decrease performance.
4 Structured Limits: Relational databases have predefined limits on fields or columns, which could lead to data
truncation or loss.
53
CITS : IT&ITES - Computer software application - Lesson 18 - 36