concept of database
-
Hi everyone, I have a question about databases.are these correct? A database is a structured collection of data. A DBMS is a software package,it creates and management databases,sql server,access and oracle are examples of DBMS. Is RDBMS a subroutine of DBMS or no? I want to know what are Flat ,Hierarchical,Relational,Object-oriented databases? they are relative to DBMS or database? Thanks
-
Hi everyone, I have a question about databases.are these correct? A database is a structured collection of data. A DBMS is a software package,it creates and management databases,sql server,access and oracle are examples of DBMS. Is RDBMS a subroutine of DBMS or no? I want to know what are Flat ,Hierarchical,Relational,Object-oriented databases? they are relative to DBMS or database? Thanks
RDMS[^] DBMS[^] Flat File Databases[^] Hierarchical Database model[^] Relational Database[^] Object Orientated Database[^] Have a read of the above links from WIKI
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
-
Hi everyone, I have a question about databases.are these correct? A database is a structured collection of data. A DBMS is a software package,it creates and management databases,sql server,access and oracle are examples of DBMS. Is RDBMS a subroutine of DBMS or no? I want to know what are Flat ,Hierarchical,Relational,Object-oriented databases? they are relative to DBMS or database? Thanks
I like to add with Simon_Whale answer. See E. F. Codd Rules If a dbms follows more than 7 codes rules than it become rdbms.oracle follows 10 rules which is considered as ideal rdbms.no rdbms exist till now which follows all the 12 codes rules.
Quote:
Excel is an example of a DBMS. and Access,SQL Server ,Oracle are RDBMS. Every RDBMS is DBMS but reverse is not true.
we categorize dbms and rdbms by E.F. Codd rules.
-
I like to add with Simon_Whale answer. See E. F. Codd Rules If a dbms follows more than 7 codes rules than it become rdbms.oracle follows 10 rules which is considered as ideal rdbms.no rdbms exist till now which follows all the 12 codes rules.
Quote:
Excel is an example of a DBMS. and Access,SQL Server ,Oracle are RDBMS. Every RDBMS is DBMS but reverse is not true.
we categorize dbms and rdbms by E.F. Codd rules.
Last time I checked, there were seven, and most are normalized to BNF. Humor me, introduce me to the five that I don't know. And no, it's not the database-software that needs to implement the rules, it's the database that needs to be designed according to those rules. I've seen databases in Oracle that would be well in 1NF. --edit; You're right on the distinction between DBMS and RDBMS. Codds rules determine whether it's a relational database.
Bastard Programmer from Hell :suss:
-
I like to add with Simon_Whale answer. See E. F. Codd Rules If a dbms follows more than 7 codes rules than it become rdbms.oracle follows 10 rules which is considered as ideal rdbms.no rdbms exist till now which follows all the 12 codes rules.
Quote:
Excel is an example of a DBMS. and Access,SQL Server ,Oracle are RDBMS. Every RDBMS is DBMS but reverse is not true.
we categorize dbms and rdbms by E.F. Codd rules.