I'm confused by this explanation... aren't the magnetic fields aligned horizontally? And isn't it the distance between the reversals of the magnetic field direction that actually determines whether it's a 1 or a 0?
Hang on... surely the data in Tournament Name, Winner and Winners DOB are all non-atomic? thus not in 1NF and as a result not in 2NF and 3NF? - did I miss something?
Very helpful with the diagrams as well, the resource which i'm currently learning this from, does not have diagrams and i believe the author of the textbook purposely makes it difficult to understand. Thank you very much.
Thank you for this great tutorial, which makes some difficult concepts easy to understand. My only little contribution is to wonder why you did not use some raw data from the beginning and showed through 1st - 3rd Normal Form how to transfer such data. Most people start their database life via Excel, and as you're aware they pick up some terrible habits very quickly. Thank you, it gave me that Eureka realisation moment I'd been searching for.
Regarding clearing a bit So given the definition of bitmask as "A value where only the bit you want to act on is set to 1 and all other bits are 0" If we want to clear a bit we need to get the NOT of the above bit mask and then the result can do an AND with original number to clear that particular bit of interest. For me the order in which he explained was confusing. Hope this help people like me
its not working for the right arrow for some reason but this tut is good but for me its not working i done every thing correct i think bc i need to reset i donno
if track 2 only has room for 40 characters and each character responds in binary how would it convert to a 20 hexadecimal long account number? thank you for the wonderful video, i am just curious
I think each one of those 40 characters consists of millions of tiny magnetic particles. So basically, each character has the ability to generate millions of different values. Now multiply that by 40 characters and you have the ability to generate billions and billions of different values.