CIS4365: Database Applications
Fall, 2017

Definitions of Relational database:

·        A relational database management system (RDBMS) organizes data into related rows and columns as specified by the relational model. Microsoft SQL Server and Oracle are examples of relational database management systems. A Microsoft Access database is an example of a relational database.

·        It stores data in such a way that it can be added to, and used independently of, all other data stored in the database. Users can query a relational database without knowing how the information has been organized. Although relational databases have the advantages of ease-of-use and analytical flexibility, their weakness can be slower retrieval speed. Structured Query Language (SQL) is one example of a relational database.
 

·        A database in the form of tables having rows and columns to show the relationships between items. If data is changed in one table, it will be changed in all related tables.

 

·        A database in which relationships between data items are explicitly specified as equally accessible attributes.

 

·        A database designed according to the relational model, which uses the discipline of Entity-Relationship modeling and the data design standards called normal forms.

 

·        A database in which the data is organized and can be accessed according to relations.

 

·        A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. The relational database was invented by E. F. Codd at IBM in 1970.

 

·        Stores data in such a way that it can be added to, and used independently of, all other data stored in the database. Users can query a relational database without knowing how the information has been organized. Although relational databases have the advantages of ease-of-use and analytical flexibility, their weakness can be slower retrieval speed. SQL is one example of a relational database.

 

·        An integrated repository of data in the form of tables that have rows and columns to show the relationship between items, and in which information can be cross-referenced between two or more tables to generate a third table.

 



 

·        A database in the form of tables which have rows and columns to show the relationships between items, and in which information can be cross-referenced between two or more tables to generate a third table. A query language is used to search for data. If data is changed in one table, it will be changed in all related tables. A database that has only one table is called a flat file database.

 

·        A database accessed and organized according to the relationships between data items. Relationships are expressed by means of tables that allow the accessing of items with matching attributes. The access path is determined at the time of access. SQL is an example of a relational database manager.

 

·        A database that is organized and accessed according to relationships between data items. A relational database contains a collection of relational tables, views, and indexes.

·        A method of structuring data as collections of tables that is logically associated to each other by shared attributes. Any data element can be found in a relation by knowing the name of the table, the attribute (column) name, and the value of the primary key. See also relate, relate key, and relational join.

 

·        A database in which related information is stored in tables within the database.

 

·        A database organization method that links files together in order to perform cross-tabulation and queries, resulting in value-added information. Non-relational databases organize information in a flat file structure.

 

·        A database where all information is arranged in tables containing predefined fields. Using structured query language, reports and comparisons can be generated by selecting fields of interest from the original database and creating new tables. Changing a field in one record automatically changes the same record in all related databases, allowing for easy global updating.

 

·        Database organized and cross-referenced in rows and columns that provides greater flexibility than a hierarchical database in answering ad hoc queries. Also, a software program that allows users to obtain information drawn from two or more databases that are made up of two-dimensional arrays of data. Not a hierarchical database.

 

·        A database composed of linked tables which have records which are made up of fields. No one table has all the information about a record.

 

·        A method of structuring data as collections of tables that is logically associated to each other by shared attributes. Any data element can be found in a relation by knowing the name of the table, the attribute (column) name, and the value of the primary key.

 

·        A database in which the data are stored in tables and are searched by using data in designated columns of one table to find additional data in another table.

 

·        A file containing a number of tables. Each table contains logically related data e.g. a table to contain name and address details. A special program (called a database engine or optimizer) determines the most efficient way to access the information and controls all access. Several users can access the data at the same time and data being updated by one user will be locked to prevent conflicting updates requested by another user.

 

·        A data base allowing users to interchange and cross-reference information among different types of data.

 

·        A database that shows the relationship between various pieces of information stored about customers. The information stored can include anything from names and addresses to customers buying habits. Relational databases make updating and altering records a much easier task.

·        A database in which relations between information items are explicitly specified as accessible attributes; "in a relational database the data are organized as a number of differently sized tables"