Data Integrity Normalization Synonym,homonym,Redundancy,Mutual Exclusiveness of Data

Data Integrity Normalization Synonym,homonym,Redundancy,Mutual Exclusiveness 

Database In this lecture we discuss with Practicals & Animation at the end of lectures : 

1) What types of problems may exist in the relations before normalization? 

a) Synonym 

b) Homonym 

c) Redundancy 

d) Mutual Exclusiveness of Data

2) What are the database anomalies? Briefly Discuss insertion , deletion, and modification anomalies ? a) Database Anomalies 

i) INSERTION ANOMALY 

ii) DELETION ANOMALY 

iii) MODIFICATION ANOMALY

3) Now So Let's Start For Practical With Example Book IT Series

 #ICSPart2 #Chapter4 #Database #integrity#Normalization 

#Synonym #Homonym #redundancy #mutualExclusiveness 

Next Lecture is most important We Will Start :

Q: What is normalization ? how it can be used to bring database in a consistent state? Express graphically

Q: What is FUNCTIONAL DEPENDENCY?

Q: What is a relation in First Normal Form #1NF ? Explain with example?

Q: What is Partial Dependency ? How does partial dependency affect a relation?

Q: What is a relation in Second Normal Form #2NF ? Explain with example?

Q: What anomalies arise due to TRANSITIVE DEPENDENCY ? Discuss Briefly?

Q: What is a relation in Third Normal Form #3NF ? Explain with example?

CHAPTER COMPLETE CONGRATULATIONS



SUPERIOR COLLEGE MANDI BAHAUDDIN

#1Trending



(C) Computer Lecturer: Shahzaib Naz