Database Management System: Unit II: Databases Design
Concept of Relational Database Design
Databases Design - Database Management System
There are two primary goals of relational database design - i) To generate a set of relation schemas that allows us to store information without unnecessary redundancy, and ii) To allows us to retrieve information easily.
Part II: Relational Database Design
Concept of Relational Database
Design
AU: Dec.-19, Marks 7
• There are two primary goals of relational database design -
i) To generate a set of relation schemas that allows us to store information without unnecessary redundancy, and
ii) To allows us to retrieve
information easily.
• For achieving these goals, the database design need
to be normalized. That means we have to check whether the schema is it normal
form or not.
• For checking the normal form of the schema, it is
necessary to check the functional dependencies and other data dependencies that
exists within the schema. Hence before letting us know what the normalization
means, it is necessary to understand the concept of functional dependencies.
Database Management System: Unit II: Databases Design : Tag: : Databases Design - Database Management System - Concept of Relational Database Design
Related Topics
Related Subjects
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation