how would you describe unary many to many relationship on table , in context of referencing ?
@HemantaShrestha-zm7dc4 күн бұрын
how would you describe unary many to many relationship on table , in context of referencing ?
@DustinOrmond4 күн бұрын
In this example, an item has many items (call a component) and each component (item) may be in many items. Therefore, we would need an associative entity because of the many to many relationship.
@fouz124514 күн бұрын
Thanks a lot, as a beginner to this concept why is Customer ID not the Primary key?
@DustinOrmond10 күн бұрын
Because it is determined by order_id. It is a primary key of the relation CUSTOMER, but not in 1NF.
@robyee332526 күн бұрын
Thanks!
@Aneix12Ай бұрын
Very clear explanation
@TheAbsoluteSirАй бұрын
I think a game can definitely be within multiple seasons in a different year! However, within the same year, a game will only ever be in one season, like how Basketball is in winter. I feel like either answer is fine, but you have to make sure you have words between tables to help understand the relationship/
@pretender1971Ай бұрын
Dear Justin, Thank you so much for the brilliant videos on Normalization. It is the best resources and explanation about Normalization out there. I am using these videos to teach Normalization to my students in Year 12 Computer Science over here in Australia. I was wondering if you could share some Normalization exercises that you use at Uni for your students. It is very hard to find good flat file to normalize to 3NF with answer key. I would appreciate if you could share a few Normalization exercises similar to the examples that you use in your videos. With Thanks Regards
@VinhLeang-dj9efАй бұрын
how to proxy work
@forheuristiclifeksh78362 ай бұрын
0:10
@kartikkumar-xh1if2 ай бұрын
great video 👍
@kartikkumar-xh1if2 ай бұрын
clear explanation, thank you
@nalimawlana2 ай бұрын
thanks sir keep going
@nielcaspillo58032 ай бұрын
what application did you use to create database that you crated directory may I know?
@DustinOrmond2 ай бұрын
I created my own server that runs all this. I haven't made it public yet.
@wickedwater242 ай бұрын
Explained extremely well, thanks a lot for this playlist
@AlexLucard3 ай бұрын
OMG Speak up
@DustinOrmond3 ай бұрын
I am sorry you are experiencing issues. The volume seems fine on my end even at 50%.
@felipemurta91603 ай бұрын
audio is completely fine lmao
@mariandapotgieter4704 ай бұрын
Thank you for this video, this is really going to help me with my studies
@imwinniedr4 ай бұрын
Underrated, thanks
@MikeKm-hd1ve4 ай бұрын
Clear and concise!! Thank you
@eliknowsbest49464 ай бұрын
This is a great video thank you
@ii7mdj_3534 ай бұрын
Came here for education. Thanks Dustin!
@phoenixHen-fh5mj5 ай бұрын
dick and balls
@bobburke43365 ай бұрын
Very well presented . Thanks for sharing.
@Spaceoholic_20055 ай бұрын
Thank u for the explanation it's useful for my seminar
@nezhabouguerza87435 ай бұрын
thanks
@user-kh9ee4oo7p5 ай бұрын
excuse me sir, I tried to register on your website, it asked me for a netID I tried different things could you please provide me netID or how to do it?
@DustinOrmond5 ай бұрын
Unfortunately, I only allow students access right now. In the future, I may open it up to the public.
@user-kh9ee4oo7p5 ай бұрын
@@DustinOrmond Oh alright and thank you so much for the courses
@user-kh9ee4oo7p5 ай бұрын
For multivalued attributes how it becomes one-to-many, I think it should be many-to-many because An employee can have multiple skills and A skill may be owned by many employees Also in the nurse and care center example is it the care center the optional or the nurse regarding to erd
@DustinOrmond5 ай бұрын
Multi-valued attributes don't become one-to-many. The employee_skill table essentially serves as an associative entity where you can have an employee with multiple skills and a skill can pertain to multiple employees: employee_id skill 1 router 1 table saw 2 router 2 mitre saw The care center is on the optional side. In essence, a nurse may or may not be in charge of a care center.
@user-kh9ee4oo7p5 ай бұрын
@@DustinOrmond but nurse is the optional right? because it may be in charge of care center and the care center is mandatory because it’s must be charged or managed by a nurse
@DustinOrmond5 ай бұрын
@@user-kh9ee4oo7p The cardinalities of the relationship state that a nurse can optionally manage a care center, but each care center is only managed by one nurse. So, yes what you are saying is true in your last two sentences. In other words, you read it like this, "A nurse optionally manages one care center (the optional-one cardinality touching the care center), and a care center is managed by one and only one nurse (the mandatory-one cardinality next to nurse)."
@user-kh9ee4oo7p5 ай бұрын
@@DustinOrmond That’s mean the care center is total participation and nurse partial participation so that a nurse is the optional one and the care center is the mandatory because each instance must take part in the relationship
@DustinOrmond5 ай бұрын
@@user-kh9ee4oo7p Yes.
@user-kh9ee4oo7p5 ай бұрын
In my college they taught us that we have weak entities my question is Should I just not use it? Also Should I use surrogate key instead of composite primary key and why?
@DustinOrmond5 ай бұрын
Yes, weak entities exist but they are such a small use case. I have slides that talk about them, but I do not have lecture videos. In fact, I choose not to focus on these because the time is better spent on other topics. You choose whether to use a surrogate or a composite. The surrogate is often easier, and I tend to use a surrogate in all cases where the composite is 3+ attributes.
@user-kh9ee4oo7p5 ай бұрын
@@DustinOrmond Thank you so much, actually I use Django and I can only use surrogate key and Could you please tell me where can I find these slides?
@user-kh9ee4oo7p5 ай бұрын
Thank you so much, actually this short course is very useful, and I want you to advise me please where to go next to master ERD..
@DustinOrmond5 ай бұрын
I recommend you think of a personal aspect in your life or data that you (or someone you know) normally track and model the database that would exist related to this data. Applying the concept to a real situation will help you learn leaps and bounds more than other arbitrary exercises.
@Abaadio5 ай бұрын
Thank you, simple and short video. very helpful
@krisztiantamasi14935 ай бұрын
Thank you so much!
@user-eo8hh7yf6g5 ай бұрын
Awesome video.
@guneyfatma5 ай бұрын
why did you put quotation marks on order?
@DustinOrmond5 ай бұрын
This is actually a tick mark and not a quote. The tick mark is the key above the tab key on your keyboard. The word "order" is a reserved keyword used in ORDER BY. Therefore, without the tick mark, running the query would fail.
@guneyfatma5 ай бұрын
@@DustinOrmond thank a lot for your help. I got it 🙏
@TriNguyenuc-jc3fp5 ай бұрын
This is so helpful. Keep up the good work, Dustin!
@mosawo54916 ай бұрын
so transitional dependency is C or all A,B and C ?
@DustinOrmond6 ай бұрын
It is A -> B -> C, not just C.
@MdIbrahim-qg1nj6 ай бұрын
Thanks for useful information
@adriannafenee78857 ай бұрын
Thanks, Dustin! This is exactly what I needed for today's exam. I dont know why those crows feet were giving me such a hard time but thank you for this breakdown! LOL
@bongkiyungalabee28587 ай бұрын
Where was this video, I mean I have been struggling with this and getting more confuse with other KZfaq videos but this right here is magic, thank you sir
@enviousshade17708 ай бұрын
why do you sound like chris chan it took me a while to concentrate because of this😂😂
@peternydahl61508 ай бұрын
This helped me so much indeed. Thanks a lot! Great video! 👍👍👍
@kabs16818 ай бұрын
why is the Code considered a Primary Key?
@DustinOrmond8 ай бұрын
Because code determines fine is a functional dependency.
@AbdinurKhalif9 ай бұрын
I wish I had seen your channel before I spent much time understanding this concept. Expert decomposition.
@huda54509 ай бұрын
I have a midterm tommorow on this chapter and you honestly put together everything , it made sense, it had all the content I needed to learn. thank you so much truly. It is hard enough to find content when you are a university student and i appreciate your efforts!! :) stay blessed. 😁
@yasmeenabdelazime7699 ай бұрын
How it was🥺?!
@JohnBuildWebsites9 ай бұрын
On line 50, where you have `Count(o.order_id)` I've recently been shown it is more performant to NOT use the primary key if other non null fields exist, with `Count(o.*)` actually being perfectly fine despite myths to the contrary. Something to do with PK fields beings stored in a more robust format that has some additional overhead.
@DustinOrmond9 ай бұрын
Interesting. Thanks for bringing this to my attention. I will look into it.
@devakinandan76599 ай бұрын
I'd argue that players might not always need coaching and might self train as well, so it is probably optional-many. Anyways, excellent video, made me understand the concept pretty well. Thank you, justin
@DustinOrmond9 ай бұрын
This could definitely be a way to model this. Each database may be designed slightly different depending on the assumptions that are made.
@devakinandan76599 ай бұрын
@@DustinOrmond ahh thanks mate. Reckon we got to take the ideal scenario for such cases
@chantel268910 ай бұрын
THANK YOU KING 👑
@trygvemb10 ай бұрын
What program did you use to draw those tables in. It looked like a super helpfull tool to get an overview when working with databases
@DustinOrmond10 ай бұрын
It is my own custom built application which isn't publicly available yet.
@vaishnavi46110 ай бұрын
this was really helpful! Thank you so much :)
@user-mr9yf9de1d10 ай бұрын
Better than my $60k a year private college professors
@AnjeMae11 ай бұрын
Thank you so much. Your playlist on normalization is so easy to follow and understand :)