Informatics Practices
Differentiate between database and table.
Relational Database
2 Likes
Answer
Database | Table |
---|---|
Database is an organized collection of interrelated data that serves many applications. | A table is a structure within a database that organizes data into rows and columns. |
It consists of multiple tables. | It is comprised of rows and columns. |
It is at higher level in the data storage hierarchy. | It is at lower level, as it is a component of the database. |
For example, MySQL database. | For example, employee table. |
Answered By
1 Like
Related Questions
Give the terms for each of the following:
(a) Collection of logically related records.
(b) DBMS creates a file that contains description about the data stored in the database.
(c) Attribute that can uniquely identify the tuples in a relation.
(d) Special value that is stored when actual data value is unknown for an attribute.
(e) An attribute which can uniquely identify tuples of the table but is not defined as primary key of the table.
(f) Software that is used to create, manipulate and maintain a relational database.
Why foreign keys are allowed to have NULL values? Explain with an example.
Differentiate between primary key and foreign key.
Differentiate between degree and cardinality of a relation.