answersLogoWhite

0

In a table each column attributes are independent, In a table row order & column order are mandatory & that cannot be changed, Table can be of more than 2 dimentions, There may be of rows and columns duplication in a table. Relation: In a Relation in which all attributes are dependent in one or the other way, The row and column orders are not considered, Relation is always 2 dimentional, There cannot be duplication of rows and columns in a relation There is no difference they both refers to the collection of rows and colls which used to store data.

_________________________________________________________

Table The physical instantiation of a relation in the database schema. Relation A logical construct that organizes data into rows and columns.

A table is essentially a two-dimensional matrix. But, a relation need not be so.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What is the difference between relation and relationship in database?

Relation: In Database a relation represents a table or an entity that contain diffrenet attributes.An Entity constructs a relation(table) in DBMS . Relationship: In Data base relationship is that how the two entities are connected to each other ,i.e what kind of relationship type they hold between them.Primary/Foreign key is used to specify or hold this relationship. By Tanzeel Ur Rahman Bhatti


What is the difference between database file and datafile?

Datafile is a group of files in each table space in an Oracle database. Database files are all files that are found within the database.


Difference between excitation table and truth table?

truth table gives relation between i/p & o/p. excitation table is use for design of ff & counters.


What is the difference between relation and table in data base?

Table is where the data is stored and in a well designed schema a table represents some real world object such as CUSTOMER, ORDER, etc., Now the real world objects have relationships. For example, a CUSTOMER has many ORDERS. To represent this relationship a database relationship was invented.


What does Design view mean in relation to a database?

its used to creat and modify the structure of the table


What is difference between primary key and foreign key?

A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. A primary key is designated by underlining the attribute name. The primary key of an entity set allows us to distinguish among the various entities of the set. A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.


What is the difference between reports and queries?

query takes a table and given the criteria entered into it it displays the results that meet that search. While a report just spits out a table in the database


A database user manually notes that The file contains two hundred records each record containing nine fields Use appropriate relational database terminology to translate that statement?

The RELATION/table has 9 ATTRIBUTES/columns, and there are 200 TUPLES /rows in the RELATION/table.


What is relation instance in DBMS?

In DBMS, a relation instance refers to a particular set of data rows within a database table at a given point in time. It represents the actual values stored in the database for that specific table. Each row in a relation instance corresponds to a record or tuple within the table, containing values for each attribute.


Relationship between a database and a table?

A table is contained within the database and consists of columns and rows. A table is meant to store data and, in relational databases, are related to other tables within the same database.


What is the difference between database instance and relation schema?

Database Instance The term instance is typically used to describe a complete database environment, including the RDBMS software, table structure, stored procedures and other functionality. It is most commonly used when administrators describe multiple instances of the same database.Also Known As: environment Examples: An organization with an employees database might have three different instances: production (used to contain live data), pre-production (used to test new functionality prior to release into production) and development (used by database developers to create new functionality). RELATION SCHEMA A relation schema can be thought of as the basic information describing a table or relation. This includes a set of column names, the data types associated with each column, and the name associated with the entire table. For example, a relation schema for the relation called Students could be expressed using the following representation: Students(sid: string, name: string, login: string, age: integer, gpa: real) There are five fields or columns, with names and types as shown above.


What is the difference between table and database form?

Database table objects store data. Form objects used by applications provide a visually pleasing or sensible way of accessing or updating data contained in the database tables. This means that the form object is a display specification.