![Dustin Ormond](/img/default-banner.jpg)
- Видео 141
- Просмотров 502 468
Dustin Ormond
Добавлен 23 янв 2010
Firewalls: Antivirus Filtering, DoS Protection, Unified Threat Management, & Firewall Architecture
Firewalls: Antivirus Filtering, DoS Protection, Unified Threat Management, & Firewall Architecture
Просмотров: 897
Видео
Firewalls: Application Proxy Firewall
Просмотров 7 тыс.2 года назад
Firewalls: Application Proxy Firewall
Firewalls: Network Address Translation
Просмотров 2312 года назад
Firewalls: Network Address Translation
Firewalls: Interesting but Scary Statistics
Просмотров 1692 года назад
Firewalls: Interesting but Scary Statistics
Host Hardening: Elements of Host Hardening
Просмотров 6752 года назад
Host Hardening: Elements of Host Hardening
Host Hardening: Local Security Policy
Просмотров 3052 года назад
Host Hardening: Local Security Policy
Application Security: Authorization Flaws
Просмотров 2002 года назад
Application Security: Authorization Flaws
Application Security: Client Validation Flaws
Просмотров 2502 года назад
Application Security: Client Validation Flaws
Application Security: Client Filtering Flaws
Просмотров 1212 года назад
Application Security: Client Filtering Flaws
Application Security: Authentication Flaws
Просмотров 2732 года назад
Application Security: Authentication Flaws
Data Protection: Database Security and SQL Injections
Просмотров 2322 года назад
Data Protection: Database Security and SQL Injections
Forensics: Steps of Computer Forensics
Просмотров 732 года назад
Forensics: Steps of Computer Forensics
Forensics: Identification and Acquisition
Просмотров 622 года назад
Forensics: Identification and Acquisition
Thanks Dustin, very clear and concise. Thumbs up!
this isn't easy or simplified. it sounds like you're reading out of a textbook.
how would you describe unary many to many relationship on table , in context of referencing ?
how would you describe unary many to many relationship on table , in context of referencing ?
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.
Thanks a lot, as a beginner to this concept why is Customer ID not the Primary key?
Because it is determined by order_id. It is a primary key of the relation CUSTOMER, but not in 1NF.
Thanks!
Very clear explanation
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/
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
how to proxy work
0:10
great video 👍
clear explanation, thank you
thanks sir keep going
what application did you use to create database that you crated directory may I know?
I created my own server that runs all this. I haven't made it public yet.
Explained extremely well, thanks a lot for this playlist
OMG Speak up
I am sorry you are experiencing issues. The volume seems fine on my end even at 50%.
audio is completely fine lmao
Thank you for this video, this is really going to help me with my studies
Underrated, thanks
Clear and concise!! Thank you
This is a great video thank you
Came here for education. Thanks Dustin!
dick and balls
Very well presented . Thanks for sharing.
Thank u for the explanation it's useful for my seminar
thanks
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?
Unfortunately, I only allow students access right now. In the future, I may open it up to the public.
@@DustinOrmond Oh alright and thank you so much for the courses
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
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.
@@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
@@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)."
@@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
@@user-kh9ee4oo7p Yes.
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?
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.
@@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?
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..
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.
Thank you, simple and short video. very helpful
Thank you so much!
Awesome video.
why did you put quotation marks on order?
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.
@@DustinOrmond thank a lot for your help. I got it 🙏
This is so helpful. Keep up the good work, Dustin!
so transitional dependency is C or all A,B and C ?
It is A -> B -> C, not just C.
Thanks for useful information
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
Where was this video, I mean I have been struggling with this and getting more confuse with other RUclips videos but this right here is magic, thank you sir
why do you sound like chris chan it took me a while to concentrate because of this😂😂
This helped me so much indeed. Thanks a lot! Great video! 👍👍👍
why is the Code considered a Primary Key?
Because code determines fine is a functional dependency.
I wish I had seen your channel before I spent much time understanding this concept. Expert decomposition.
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. 😁
How it was🥺?!
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.
Interesting. Thanks for bringing this to my attention. I will look into it.
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
This could definitely be a way to model this. Each database may be designed slightly different depending on the assumptions that are made.
@@DustinOrmond ahh thanks mate. Reckon we got to take the ideal scenario for such cases
THANK YOU KING 👑
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
It is my own custom built application which isn't publicly available yet.
this was really helpful! Thank you so much :)
Better than my $60k a year private college professors