Relationship is the most crucial concept in relational database management system (RDBMS). The whole existence of RDBMS is due to the Normalization process and normalization is founded on defining and maintaining relationship between different entities.First of all, let's think about normalization … [Read more...]
Database and MS Access Questions
Database and MS Access Questions - This can be quite confusing for the beginners to start preparing Database and MS Access for competitive questions. At the same time, many just wonder what would be the questions for interview from databases? Here I collect some of the basic and intermediate … [Read more...]
What is Data Redundancy in Database?
Confused with the formal definition of Data Redundancy in Database in your text books? I'm going to explain data redundancy in simple words in this post. First of all consider the term 'redundancy'. The meaning of the word 'redundancy' is no longer needed, exceeding what is necessary or natural, … [Read more...]
Conceptual Database Model
This post is related to Conceptual database design, conceptual database model, Software Development Life Cycle, ER Diagram Presentation: Conceptual Database Model What is Conceptual Database? While developing a new (software) system or upgrading an existing one (to automate any … [Read more...]