MySql keys information

-

 


1 Super key 







2 Candidate key 








3 Primary key 






alternet key





Foreign Key 






Comments

Post a Comment

Popular posts from this blog

Healthy Programmmer PROJECT

-
  # import time import time # from pygame import mixer from datetime import datetime from time import time def musicOnLoop(song , stopper): mixer.init() mixer.music.load(song) mixer.music.play() while True : a = input() if a == stopper: mixer.music.stop() break def Value(message): with open( "myValues.txt" , 'a' ) as f: f.write( f' { message } { datetime.now() }\n ' ) if __name__ == '__main__' : water=time() eyes=time() excercise=time() secOfWater= 30 secOfEyes= 20 secOfExcercise= 30 while True : if time()-water>secOfWater: print( "Water Drinking time ! Enter 's' to stop alarm" ) musicOnLoop( 'WG.mp3' , 's' ) water=time() Value( 'Drank at' ) if time()-eyes>secOfEyes: print( "Eyes Excercise time ! Enter 'done' to stop alarm" ) ...
Read more

Difference Between Procedural and Non-procedural Language

-
  Procedural language The program code is written in the form of a sequence of instructions. The user would specify what has to be done and how it can be done, i.e the step by step procedure of it. It is considered as a command-driven language. It works with the state of the machine. Its semantics are tough in comparison to other paradigms. The size of the program would be large. These steps would be executed in a sequential method. It returns restricted data types and certain allowed values only. The overall efficiency is high. The instructions are written to solve a specific/set of problems. Examples of procedural languages include BASIC, FORTRAN, ALGOL, C, COBOL, and Pascal. It is not suited for applications where time is a critical constraint. The iterative loops and recursive calls are used while working in procedural languages. Non-procedural Language The user would specify what has to be done but doesn't get into the how it has to be done part. It is known as an applicative ...
Read more

Dictionary Practice Question

-
  dict={} a= input ( "Enter your favoriat language Shubham: \n " ) b= input ( "Enter your favoriat language kartik: \n " ) c= input ( "Enter your favoriat language raghav: \n " ) dict[ 'Shubham' ] = a dict[ 'Kartik' ] = b dict[ 'raghav' ] = c print (dict)
Read more