6

Relational Database Design

1.   What are the features of a good relational database design?

Ans: The goal of the relational database design is to generate a set of relations having no duplicate tuples, tuples having no particular ordering associated with them and each element in the relation being atomic. To qualify as a good relational database design, it should also have the following features:

images Minimum redundancy: A relational database should be designed in such a way that it should have minimum redundancy. Redundancy refers to the storage of the same data in more than one location. That is, the same data are repeated in multiple tuples ...

Get Express Learning: Database Management Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.