Posts

Showing posts from May, 2025

RDBMS and Relational Model

Image
 RDBMS CRUD - create, read, update and delete Data - any information which can help you to make a decision or can help to make a choice. Data is of different type (Notes, Phone number, to-do list, pics etc.) Some of the application to read a data: Plain text reader, excel, access and other applications. Drawbacks of Excel which database overcome: Inefficiency to access data - If need to access a data to specific id then as need to iterate for informaiton, hence timecomplexity is O(n) Data Integrity - Columns can have any kind of data even numeric column can have string data which is not right. Concurrency - Allowing multiple users to read data at a time form same file. Which should not interfere with requirements, and don't manipulate the data. Data Security - Only authorized users should be able to access the data. Hence we have management and rules for this security enforcement. Scenario to understand need of database: If dats is present in excel sheet then steps to find psp of s...