Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
Good question. If you're creating a database for a single company, then the one company is all it cares about, so the relationship is "one company has many employees". If it's something different like an employment history feature of LinkedIn, you may find that both are true: a company has many employees, and an employee has many companies (and even multiple companies at the same time). In this case, it would be a many-to-many relationship.
Hey Database Star, I was thinking of getting a monthly subscription to your site. Are the concepts taught specific to SQL Server or can they be transferred to something like Postgres/MySQL? Also, do you have recommendations on good books about database design? I kind of struggle with it when it gets complex. I want to learn how to design a database for any sort of application needs I can think of.
Hi, the courses and content I have in the monthly subscription apply to Oracle, SQL Server, MySQL, and Postgres. There are demos and examples for all four of them. For books, I’ve heard Database Design for Mere Mortals recommended a lot but I haven’t read it.
all these comment lying about learning is crazy, I know data base but have some areas I can improve on and this helps none.i need the actual sql setup and codes to help.
@@DatabaseStar this example was created on a spreadsheet type program, not an actual sql database so ppl who do not know how to join and what allows the join can fully understand. for example creating two tables you never said in order to join you need to set a key and index in order for it to have the relation in the first place. Say I want my product page with a size option as one field and I want to join it with a size table with the full stock sizes how do I do that? the size field would need to be set as index and the size table would need to be primary......Then how is it rendered by code?
I found you a little bit too late but please forgive me for my haste and rudeness. I got only two items in my e commerce product list, very simple (those are free from categories and subcategories like color size etc. One is set of books (Romance, Textbook, Suspense, Horror) the other is set of Games. How soon can you reply to me for a complete Schema? Apology again, Thanks.
Thanks for the feedback! I agree it is hard to listen. This is one of my older videos where I did that, and my newer ones are much clearer (louder voice, clearer, better microphone).
![Lethal Company Music Video 🎵 "Follow The Orders" [VERSION A]](http://i.ytimg.com/vi/QeooZB4Z7RA/mqdefault.jpg)
Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
Okay step 2 is insanely helpful to me right now, the entire video is great but step 2 led to some breakthroughs for me
Glad to hear it's helpful!
Really love how these steps are laid out. It's better to give it an additional thought.
Thanks!
Great tutorial for beginners. Thank you very much for uploading it!
You're very welcome!
Step 4 and Step 7 was very helpful. Thank you
No problem, glad it helped!
Thank you so much!!!!!!! You are a great teacher!!!!! Thanking God for your videos!!! I was soooooo confused before!
Happy to help!
learning here more than in school
Great to hear!
Your comment is somewhat funny.
Jajakallahu khairon... Best wishes for you
Thanks!
NIce examples Benn, Audio is slightly low even when I set all voulme to 100%, please check it once
Thanks, I'll keep that in mind
@@DatabaseStar yes pls, talk louder, the video made me sleepy
very good explanation
thank you
You’re welcome!
Really good video, can’t thank you enough
Glad you enjoyed it!
I am going to try Microsoft Visio as this is part of Office 365. Thanks mate
No problem!
Thank you so much for this video
You are so welcome!
Thanks, it was helpful.
Glad it helped!
Wow it's all clear. Thank you very much.
Thanks! Glad you like the video.
Just what I needed, thank you!
Happy to help!
Great job for beginners like me..
Thanks, glad you like it!
you are really a star
Thanks!
Great video!
Thanks!
Awesome video !! thank you so much
Glad you liked it!
Thank You Sir
You’re welcome!
Drawing my idea on paper was a good idea.
Glad it worked for you!
Thank you so much it helped me a lot
Glad it helped!
thanks a lot
You’re welcome
Great video! Question: Why you didn't put the "1" crows foot notation on the other end of the line relationship?
Good question, I think it's due to the diagram tool I was using.
Very well explained :)
Thanks Andrea!
Amazing
Thanks!
which tool you have used to create diagram?
I use LucidChart
I am very new to SQL but want to pursue a career as SQL developer.Any path or suggestions please.
Thanks in advance
I’d probably start with learning the basics of SQL and then create your own database and practice your SQL skills.
Great Video
Thanks!
I'm confused because my question is:
Can a company have many employees or can an employee work at many companies?
Good question. If you're creating a database for a single company, then the one company is all it cares about, so the relationship is "one company has many employees".
If it's something different like an employment history feature of LinkedIn, you may find that both are true: a company has many employees, and an employee has many companies (and even multiple companies at the same time). In this case, it would be a many-to-many relationship.
Hey Database Star, I was thinking of getting a monthly subscription to your site. Are the concepts taught specific to SQL Server or can they be transferred to something like Postgres/MySQL? Also, do you have recommendations on good books about database design? I kind of struggle with it when it gets complex. I want to learn how to design a database for any sort of application needs I can think of.
Hi, the courses and content I have in the monthly subscription apply to Oracle, SQL Server, MySQL, and Postgres. There are demos and examples for all four of them.
For books, I’ve heard Database Design for Mere Mortals recommended a lot but I haven’t read it.
all these comment lying about learning is crazy, I know data base but have some areas I can improve on and this helps none.i need the actual sql setup and codes to help.
Thanks for the feedback. What sql code do you need?
@@DatabaseStar this example was created on a spreadsheet type program, not an actual sql database so ppl who do not know how to join and what allows the join can fully understand. for example creating two tables you never said in order to join you need to set a key and index in order for it to have the relation in the first place. Say I want my product page with a size option as one field and I want to join it with a size table with the full stock sizes how do I do that? the size field would need to be set as index and the size table would need to be primary......Then how is it rendered by code?
I found you a little bit too late but please forgive me for my haste and rudeness. I got only two items in my e commerce product list, very simple (those are free from categories and subcategories like color size etc. One is set of books (Romance, Textbook, Suspense, Horror) the other is set of Games. How soon can you reply to me for a complete Schema? Apology again, Thanks.
No problem! What do you need from me exactly?
why do you whisper & mumble? very very hard to listen.
Thanks for the feedback! I agree it is hard to listen. This is one of my older videos where I did that, and my newer ones are much clearer (louder voice, clearer, better microphone).
@@DatabaseStar awesome
what is Tible?! its a Table! not so hard
and its Paper not Piper
What do you mean? I say Table and Paper.
This was completely useless....
Thanks for the feedback. Why do you feel it was useless? What do you think could have been improved?
Great tutorial. I stumble on your blog , but the links to your uTube channel are not working so I had to google it.
Thanks, I'll fix those links.
Please tell what is the name of this tool
The tool is called Lucidchart