DBMS

RDBMS

1. The relation between tables is maintained programmatically.

1. The relation between tables is store in the form of tables in the database itself.

2. DBMS does not support multiple users accessing the same files.

2. RDBMS are multi-user systems.

3. The security in a DBMS is not provided to a higher extent.        

3. RDBMS provides multiple levels of security.

4. Each table in a DBMS is stored as a single file.

4. Tables from different users are stored in single or multiple database files.

5. Users can directly access the stored files in a DBMS.

5. Users have no access to the stored files in RDBMS.

6. Distributed database is not supported here.

6. Distributed database is supported.

7. DBMS does not support abstract views from base tables.

7. RDBMS supports abstract views.

8. DBMS satisfies less than 8 of Codd’s 12 rules.

8. RDBMS supports more than 8 of Codd’s 12 rules.