UHCL 18a Graduate Database Course - DBMS Functional Dependencies - Logically Implies - Keys

Подписаться 6 тыс.

Просмотров 97 тыс.

50% 1

This video corresponds to the unit 4 notes for a graduate database (dbms) course taught by Dr. Gary D. Boetticher at the University of Houston - Clear Lake (UHCL). The theme is relational database theory. This video focuses on functional dependencies by defining the term functionally determines. Next, the idea of logically implies is presented. Afterwards, the video presents the idea of "F-closure." Finally, there is a revised definition of a database key.

Опубликовано:

28 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

@justopposite 12 лет назад

Dr. Boetticher, Thank you so much for uploading this video on the internet, it has helped me greatly !!

@RaptorDragoon 11 лет назад

I think you have a good point there. I agree with you, the dependency for ssn->last should not hold.

@PinkSocksSuck 4 года назад

You seem like a very passionate teacher. Thank you for sharing your videos with the world.

@K0nserv 11 лет назад

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.

@All4thaCash 11 лет назад

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.

@funky7281 10 лет назад

Second part is here UHCL 19a Graduate Database Course - DBMS Theory - Armstrongs Axioms - Inference Rules

@AmolGautam 9 лет назад

thank you, was useful just before the examination

@PeterMIcedVoltage 7 лет назад

Thanks - better than my uni lecturers.

@dan10ds 3 года назад

your videos are awesome!

@Leonn189 9 лет назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-j4GfUYdampo.html.

@malharjajoo7393 8 лет назад

Hi , Are you saying that we cannot determine what are the FDs of a given dataset unless we are an expert ?

@theonerohan 12 лет назад

Isn't ssn -> last also incorrect, because the (333, smith) tuple exists?

@liamfoley9614 8 лет назад

The mentioned notes, are they available somewhere?

@SeanSKZ 9 лет назад

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?

@thedeserteagle9059 8 лет назад

+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.

@AlirezaX1 11 лет назад

Great lecturer

@Randystites66207 8 лет назад

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.

@ilikefoxess 7 лет назад

Transitive dependencies has to do with BCNF and I don't think he mentioned it because this was an intro.

@ilikefoxess 7 лет назад

Nvm he dose talk about transitive dependencies at about 6:00

@edmundmlala2827 7 лет назад

Well explained, thank you

@rahuljhaver1990 13 лет назад

thanx sir.

@zhiyudu1106 10 лет назад

helpful

@Moonfox87 12 лет назад

I want to study in your university!!!!

@Leon-pn6rb 8 лет назад

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 8 лет назад

+12345a : Please consider rewinding and watching again. Sometimes it takes several views to get a concept. Keep trying! Best wishes, Dr. Boetticher

@Leon-pn6rb 8 лет назад

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...

@vaibesb4u 7 лет назад

Greetings Sir, I am from India, you are videos are very useful Could you make videos on B+Trees Insertion and deletion

@ernestgty1442 5 лет назад

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

@GaryBoetticher 12 лет назад

@swu880 They are available to those students who sign up for the course.

@kscs1192 4 года назад

Dr. Boetticher, you are the best professor! thank you!

@HevyDevyD 4 года назад

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

@GaryBoetticher 4 года назад

Devan: Actually, I am teaching the same course this semester. I assume you have Dr. Hasan. Best, Dr. Boetticher