Month: February 2022

Difference between RDBMS and Excel RDBMS 1. To communicate with RDBMS we use SQL 2. RDBMS maintain a database 3. It is a secured 4. It follows EFCODD Rules 5. It can store Meta Data 6. It follows relational Model Excel 1. We don’t use any language to communicate with excel 2. Does not maintain Continue reading

EFCODD Rules • Data should be a single value attribute • The data entered into a cell must be single value data/automatic data • We can store the data into multiple values • We can establish the connection by using key value attribute • To validate the data we can assign datatypes and constraint • Continue reading

Definition of DBMS and RDBMS DBMS: [Database Management System] is a software which maintains and manages the database, DBMS provides two important features 1. Security: to protect the data 2. Authorization: it is used to access the data. To communicate with DBMS software we use query language Types of DBMS 1. Network DBMS 2. Hardware Continue reading

Difference between DBMS and RDBMS DBMS: 1. Data base management system 2. Store the data in the form of files 3. Hierarchical arrangement of data 4. Allow one user at a time 5. Does not use acid form of storage 6. Manage the data in a computer 7. Does support integrity constraints 8. Cannot be Continue reading