Database Management System2080.110 marksInformal Design Guidelines for Relational Schemas
What are informal design guidelines for relational schemas? why do we need functional dependencies? Explain 2NF, 3NF with suitable example.
What are informal design guidelines for relational schemas? why do we need functional dependencies? Explain 2NF, 3NF with suitable example.[10]
--- Informal guidelines are used as measures to determine the quality of relation schema design. The four main guidelines are: --- Design a relation schema so that it is easy to explain its meaning. Do not combine attributes from multiple entity types into a single relation. Each tuple in a relat...