SQL Server

-

Question 1: What is redundancy?

Answer: Redundancy occurs when the same piece of information is stored in the database multiple times. Normalization helps remove redundancy.

Three major problems arise due to redundancy:

  1. Insertion anomaly: When the same information is entered in the database multiple times.
  2. Deletion anomaly: When deleting information from the database may lead to unintended deletions.
  3. Modification anomaly: When updating one piece of information requires updating multiple instances of the same data.

Example: Consider a scenario where a doctor attends to a patient, creating a relationship between a particular patient and a doctor.

Table Example: Patient Information
PatientID PatientName DoctorID DoctorName
1 John Doe 101 Dr. Smith
2 Jane Smith 102 Dr. Johnson
3 Bob Johnson 101 Dr. Smith

Comments

Post a Comment

Popular posts from this blog

Text Mining In Python For Beginners to Advance

-
Text Mining in Python for Beginnners Text is everywhere, you see them in printed material and in book. you have newspaper, you have Wikipedia and other Social Media. You have people talking to each other in online formus, and disscussion groups, and so on. You could Parse The text, classify the text document, try to understand and it says. Find and extract relevant information from text, even define what information is. You're to search for relevant text documents, this is information retrieval. text contains all  information like politics news, any sports news and any celebrity news and etc. today's world you can find any information in text. everything is available in text. Their are lots of information in text but we need to find some specific information that we use text mining. In text mining we can analyze the text, scarpe the text, find specific word, find repetition of words and so on. if you are beginners then i sure this blog definatly help You. You Can try this co
Read more

Docker Tutorial For Beginners: Basic Commands of Docker

-
Technologies gyan What is Docker: Docker Tutorial For Beginners Docker is fastest technology tool that is used to launch the operating system within a second. It provide the platform to launch a operating system, Programming Language (like python, java & etc..) and many Software Like Wordpress and etc.. within a seconds. docker is can't run directly in windows but its run on window 2016 version to latest version. if you need to work on docker in window you can install docker tool box and read the official docker documentation . Docker is a tool In docker we are create a container for create, deploy and running a application. Docker is open Source Project. It is written in GO language. there are two types of docker in market     a). docker CE  it's free to use     b). docker EE  it's not free For learning a Devops Technology you need to learn Docker.  in
Read more

Stock Buy and Sell to earn Maximize Profit programme in Python

-
Stock Buy and Sell to earn Maximize Profit programme in Python def sell_profit(price,n):          i =  0      while (i<n- 1 ):         """We check if next price is less so we use next price becaue we need minimum           buy amount."""          while (i<(n- 1 )  and  price[i+ 1 ] <= price[i]):             i +=  1          if  i == n- 1 :              break         buy = i          i +=  1                     """we check if previous price is less than our current price so we                 increment price and  again check it previous price                 because we need maximum profit for selling."""          while (i<(n)  and  price[i] >= price[i- 1 ]):             i +=  1         sell = i- 1          print ( "buy on the day :  {}  , sell on the day :  {} "  .  format (buy,sell)) price = [ 50 , 100 , 250 , 300 ,3 0 , 540 , 620 ] n =  len (price) sell_profit(price,n) # Time Complexity O(n) # For m
Read more

Full Forms Of Computer, www, pdf, Http, ok, BSNL, JIO, AIRTEl, SIM, VoLTE, GOOGLE and many more

-
Full Forms Of Important Common Words:- 1. Computer :-                     C=common                     O=oriented                     M=machine                     P=particularly                     U=united and used under                     T=technical and                     E=educational                      R=research 2. VPN :- virtual private network 3. WWW :- world wide web 4. DCIM in mobile :- digital camera image 5. PDF :-portable document format 6. USB :- universal serial bus 7. HTTP :- hyper text transfer protocol 8. MB :- mega byte 9. FTP :- file transfer protocol 10. CAD :- computer-aided design 11. SMS :- short massage service 12. QR CODE :-quick response code 13. OK :- oll korrect. 14. YAHOO :- yet another hierarchical officious oracle. 15. JPEG :- joint photographic experts group. 16. AIRTEl :- Affectionate Interested Respectful Tolerant Energetic and loving. 17. BSNL :
Read more