Page 66 - CITS - Computer Software Application -TT

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