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
Database Management System: Unit II: Databases Design
Under Subject
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Related Subjects
Environmental Sciences and Sustainability
GE3451 ESS 4th Semester | 2021 Regulation | 4th Semester EEE Dept 2021 Regulation
Theory of Computation
CS3452 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Artificial Intelligence and Machine Learning
CS3491 4th Semester CSE/ECE Dept | 2021 Regulation | 4th Semester CSE/ECE Dept 2021 Regulation
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Algorithms
CS3401 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Introduction to Operating Systems
CS3451 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation