Amazing explanation. I missed my class and I could only look through the notes, but I couldn't gather the ideas until I saw this video of yours. Thank you so much
ssn -> last does hold because there is only one row which has ssn 333. You are thinking of last -> ssn which doesn't hold because of the (333, Smith) tuple.
The relation does not need to travel backwards. For X -> Y, If two tuples agree on X they must agree on Y. It does not mean that iif two tuples agree on Y they must also agree on X.
What a coincidence that i'm currently a student at UHCL in Database Designs coming to a video posted by a former professor that taught the same course at the same campus
Wow, you explain this really clear! Thanks Mr. Boetticher, you really helped me a lot, the book I have for my course explains things rather complex. By the way, for anyone who's looking for the second part of this video: ua-cam.com/video/j4GfUYdampo/v-deo.html.
I have a question: are all attributes in a DB dependent on a primary key? e.g. Administrator DB (Primary Key) AdminID AdminUserName AdminPassword AdminEmail Would AdminID -> all these attributes?
+predatorsc1992 I guess that depends on how well the database has been designed and more importantly, to what degree has the relational tables been normalised.
Professor, I am studying DBMS dependencies and it has to do with Full, Partial, ad Transitive. You do not mention any of these so I am sorta lost in your explanation since you do not reference these or at least not in the way I am to understand dependencies.
I didn't understand. your teaching was rushed and ineffective. though you sound like an expert on this, you don't seem like a very good teacher. sorry to say, but I am frustrated too
GaryBoetticher thanks..I have ADHD and so focusing is mission impossible for me when the tutor goes through so fast I dont like being a rude person , I dont know what comes over me...
You seem like a very passionate teacher. Thank you for sharing your videos with the world.
Dr. Boetticher, Thank you so much for uploading this video on the internet, it has helped me greatly !!
Dr. Boetticher, you are the best professor! thank you!
Amazing explanation. I missed my class and I could only look through the notes, but I couldn't gather the ideas until I saw this video of yours. Thank you so much
I think you have a good point there. I agree with you, the dependency for ssn->last should not hold.
ssn -> last does hold because there is only one row which has ssn 333. You are thinking of last -> ssn which doesn't hold because of the (333, Smith) tuple.
your videos are awesome!
The relation does not need to travel backwards.
For X -> Y,
If two tuples agree on X they must agree on Y. It does not mean that iif two tuples agree on Y they must also agree on X.
What a coincidence that i'm currently a student at UHCL in Database Designs coming to a video posted by a former professor that taught the same course at the same campus
Devan: Actually, I am teaching the same course this semester. I assume you have Dr. Hasan. Best, Dr. Boetticher
oh my goodness thank you, you're so much better than my teacher...
thank you, was useful just before the examination
Second part is here UHCL 19a Graduate Database Course - DBMS Theory - Armstrongs Axioms - Inference Rules
Thanks - better than my uni lecturers.
Isn't ssn -> last also incorrect, because the (333, smith) tuple exists?
Wow, you explain this really clear! Thanks Mr. Boetticher, you really helped me a lot, the book I have for my course explains things rather complex.
By the way, for anyone who's looking for the second part of this video: ua-cam.com/video/j4GfUYdampo/v-deo.html.
@swu880 They are available to those students who sign up for the course.
Great lecturer
Well explained, thank you
I have a question:
are all attributes in a DB dependent on a primary key?
e.g. Administrator DB
(Primary Key) AdminID
AdminUserName
AdminPassword
AdminEmail
Would AdminID -> all these attributes?
+predatorsc1992 I guess that depends on how well the database has been designed and more importantly, to what degree has the relational tables been normalised.
Hi ,
Are you saying that we cannot determine what are the FDs of a given dataset unless we are an expert ?
Good Explanation Sir....... Thanks........:)
Great help...Thank you.
The mentioned notes, are they available somewhere?
Professor, I am studying DBMS dependencies and it has to do with Full, Partial, ad Transitive. You do not mention any of these so I am sorta lost in your explanation since you do not reference these or at least not in the way I am to understand dependencies.
Transitive dependencies has to do with BCNF and I don't think he mentioned it because this was an intro.
Nvm he dose talk about transitive dependencies at about 6:00
awesome!!
thanx sir.
helpful
I want to study in your university!!!!
I didn't understand. your teaching was rushed and ineffective.
though you sound like an expert on this, you don't seem like a very good teacher.
sorry to say, but I am frustrated too
+12345a : Please consider rewinding and watching again. Sometimes it takes several views to get a concept. Keep trying! Best wishes, Dr. Boetticher
GaryBoetticher thanks..I have ADHD and so focusing is mission impossible for me when the tutor goes through so fast
I dont like being a rude person , I dont know what comes over me...
Greetings Sir, I am from India, you are videos are very useful Could you make videos on B+Trees Insertion and deletion