Guaranteed access- Every value in a relational database is guaranteed to be accessible by using a combination of the table name, primary key value, and column name.ģ. Information rule- All information in a relational database (including table and column names) is represented explicitly as values in tables.Ģ. A relational DBMS must be able to manage databases entirely through its relational capabilities.ġ. Codd defined thirteen standards that must be met before a database can be considered a relational database:Ġ. (Ted) Codd first developed the concept of a relational database in A Relational Model of Data for Large Shared Data Banks in 1970.ĭr. Relational database technology allows databases to be larger, faster, and more efficient.ĭr. This is accomplished through the use of keys, which are database fields used to uniquely identify specific records in a table. These relationships enable DBAs to combine data from several tables for querying and reporting. It then allows Data Base Administrators (DBAs) to define relationships between these tables. A relational database stores data in separate tables instead of placing all data in one large table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |