Relational Database Model
Comparing and Contrasting the Relational Database Model and OO Model
The relational database model is based upon tables or relations. In this model, the physical implementation of the database is abstracted away from the user. Users query the database using a high-level query language, such as SQL. The relations are made up of columns, which have headings indicating the attribute represented by that column. Tables have key fields, which can be used to identify unique records. Keys relate tables to each other. The rows of the relation are also called tuples, and there is one tuple component for each attribute or column in that relation. A relation or table name, along with those relation's attributes, make up the relational schema. Relational Database models are server-centric.
When designing a Relational Database, you must create a table for each entity type, choose or invent a primary key for each table; add foreign keys to represent one-to-many relationships; create......
View the rest of this paper...
Approximate Word Count: 965
Approximate Pages: 4 (250 words per double-spaced page)
Why should you join Frat Files?
- - It's safe, secure, and private.
- - Instant access to over 100,000 papers. New papers are added hourly.
- - Fast and reliable customer support.
Similar Essays
-
Relational Database Model
Relational Database Model. Comparing and Contrasting the Relational Database Model
and OO Model The relational database model is based upon tables or relations. ... -
Database
... concepts. The Relational Model The relational database model was conceived
by EF Codd in 1969, then a researcher at IBM. The model ... -
Relational Model
Relational Model. The Relational Database Model A database can be understood
as a collection of related files. How those files are ... -
Database Concepts
... Relational Database Model Dr. Edgar F. Codd worked at IBM in San Jose, California,
were he worked primarily in the development of hard disk systems. ... -
Database Concepts
... oriented database models will likely play a big part in the future of databases;
however, it has not yet become as popular as the relational database model. ...
