Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

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

Answer Attachments

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

Exams With Marking Schemes

Related Questions