Get premium membership and access questions with answers, video lessons as well as revision papers.

Discuss the properties of a relational table.

      

Discuss the properties of a relational table.

  

Answers


kelvin
•The table has a name that is distinct from all other tables in the database.
•Each cell of the table contains exactly one value. (For example, it would be wrong to store several telephone numbers for a single branch in a single cell. In other words, tables don’t contain repeating groups of data. A relational table that satisfies this property is said to be normalized or in first normal form.)
•Each column has a distinct name.
•The values of a column are all from the same domain.
•The order of columns has no significance. In other words, provided a column name is moved along with the column values, we can interchange columns.
•Each record is distinct; there are no duplicate records.
•The order of records has no significance, theoretically

kevowmuchiri answered the question on July 4, 2018 at 15:33


Next: Discuss the advantages and disadvantages of DBMSs.
Previous: Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign...

View More Computer Science Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions