Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): databasestar.mykajabi.com/lpkj-dbdesign/?
@@DatabaseStar I haven’t gotten a chance to watch all of your videos only bits and pieces cause work is crazy right now, but if you could make a video that shows how to design a Database from scratch for a new application you wanna create that would be awesome. So for example, let’s say I have to build a database for an e-commerce store which will handle payments, orders, and shipping all in house, how do we even start to design a database for an application idea we have? In the example I gave most companies handle payments and shipping through 3rd parties but I would wanna handle it all in house so the database would have to be designed differently than most, so understanding how to design a database no matter what application you plan on building would be awesome. I guess my request may overflow a bit into the business analyst realm as well but if it’s detailed enough it would be extremely valuable cause a developer at a startup has to wear multiple hats. As a new developer who wants to build applications on his own, understanding how to design a database well in the beginning is crucial because if we don’t we will either have to make difficult changes to the database design later without losing data or the business logic for the application itself will be more complicated to write.
For example, an application about recycling, that allows users to exchange Different types of plastic in containers, distributed around the city, and for each exchange user can receive points that can be used later to exchange, again, for some offers from markets or any products @@DatabaseStar
Great video. Couple questions: 1. ENUM vs table (for listing type: sale, rent) 2. If this listing page will have 200k properties and you wanna use filters to filter out by types, features, and price with pagination. What are the strategies for fast querying?
Thanks! 1. I prefer table instead of ENUM as it's more flexible and you can get the list of values easier. But ENUM can still work. I'll make a video on this in the future. 2. Generally, indexes will be the first solution to use here. You can add indexes on columns being used in the filter. If queries are still slow, there are other strategies you can use.
@@DatabaseStar thanks. Maybe in the future you will have a video about a similar case, when you wanna have a search (like in listings) using multiple parameters.
if you get the time mate, some time spent on auditing solutions of various robustness would be absolutely awesome, its one of those things in my experience that if i go searching for an answer to this, ill get a million different solutions and get no closer to implementing something with confidence. some like to create 'god' tables that hold auditing information for the whole system, others prefer to have audit tables alongside tables that track versions of information prefixed with 'audit_' in the table name....anyway....food for thought
8:25. Hi. I have a qeustion. Shouldn't be a joining table between `employee_id` and `listing_id`? Why `property_id`. I think it may should be based on listing id instead of property id?
Hey, that's a good point. It would be better to link it to listing instead of property, in case a property is listed multiple times and different employees work on it.
Hi, Excellent video, I have a question, should we have 2x tables, tblUser for Public site login and tblAdminUsers for Admin site login or just one table tblUsers for both?
Hi, good question. I think it depends on how similar they are. Generally I would recommend using one table for both. I created a video recently on this exact topic here: ruclips.net/video/Pg0ADtwt32k/видео.html
Got clear idea about db design for real estate. I have one question, What will be scenario for if an agent done listing, and later on he left the job. then what will be happen to the property or listing?
Good question. Ideally the listing and property will stay. And it could either be moved to a different agent, or the agent could be marked as inactive or their employment ended.
I don’t know if there are any that follow this exact design. But there are many that use the same concepts, such as real estate companies or property management companies.
Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): databasestar.mykajabi.com/lpkj-dbdesign/?
I love these! Please keep making more database design videos!
Thanks! Glad to hear you like them. Do you have any database design topic suggestions?
@@DatabaseStar I haven’t gotten a chance to watch all of your videos only bits and pieces cause work is crazy right now, but if you could make a video that shows how to design a Database from scratch for a new application you wanna create that would be awesome.
So for example, let’s say I have to build a database for an e-commerce store which will handle payments, orders, and shipping all in house, how do we even start to design a database for an application idea we have?
In the example I gave most companies handle payments and shipping through 3rd parties but I would wanna handle it all in house so the database would have to be designed differently than most, so understanding how to design a database no matter what application you plan on building would be awesome.
I guess my request may overflow a bit into the business analyst realm as well but if it’s detailed enough it would be extremely valuable cause a developer at a startup has to wear multiple hats.
As a new developer who wants to build applications on his own, understanding how to design a database well in the beginning is crucial because if we don’t we will either have to make difficult changes to the database design later without losing data or the business logic for the application itself will be more complicated to write.
perhaps topic about scheduling appointments@@DatabaseStar
For example, an application about recycling, that allows users to exchange Different types of plastic in containers, distributed around the city, and for each exchange user can receive points that can be used later to exchange, again, for some offers from markets or any products @@DatabaseStar
Great ideas, thanks for the suggestions! I'll add them to my list of videos.
the knowledge that these videos provide is incredible, thank you!
Glad you like them!
Wonderful! Please do database design for Airbnb.
Thanks! That's a good idea.
Love your videos. Like the new tool.. but creating ref line outside tables feels weird
Thanks! Yeah it does feel a bit strange!
Great video. Couple questions:
1. ENUM vs table (for listing type: sale, rent)
2. If this listing page will have 200k properties and you wanna use filters to filter out by types, features, and price with pagination. What are the strategies for fast querying?
Thanks!
1. I prefer table instead of ENUM as it's more flexible and you can get the list of values easier. But ENUM can still work. I'll make a video on this in the future.
2. Generally, indexes will be the first solution to use here. You can add indexes on columns being used in the filter. If queries are still slow, there are other strategies you can use.
@@DatabaseStar thanks. Maybe in the future you will have a video about a similar case, when you wanna have a search (like in listings) using multiple parameters.
if you get the time mate, some time spent on auditing solutions of various robustness would be absolutely awesome, its one of those things in my experience that if i go searching for an answer to this, ill get a million different solutions and get no closer to implementing something with confidence. some like to create 'god' tables that hold auditing information for the whole system, others prefer to have audit tables alongside tables that track versions of information prefixed with 'audit_' in the table name....anyway....food for thought
Good idea! I can create a video on that topic. I've seen some approaches to this I can use.
Love your videos been following you for some time! Can you please make for a Hotel management application! Thank you!
Thanks! Good idea, I think that's on my list.
8:25. Hi. I have a qeustion. Shouldn't be a joining table between `employee_id` and `listing_id`? Why `property_id`. I think it may should be based on listing id instead of property id?
Hey, that's a good point. It would be better to link it to listing instead of property, in case a property is listed multiple times and different employees work on it.
Hi. @@DatabaseStarYeah. Thanks for the reply and confirmation. Love your videos. I leart a lot from your channel. Thank you again. :)
It is easy to understand. May you design a small database design for a POS system for a coffee shop?
Thanks! Yes I can create a video for that.
very interesting. thanks
Glad you enjoyed it!
The content is very good as always. The new tool i feel is a distraction. Thanks for all the effort.
Thanks for the feedback on the new tool! Glad you like the videos too.
Hi, Excellent video, I have a question, should we have 2x tables, tblUser for Public site login and tblAdminUsers for Admin site login or just one table tblUsers for both?
Hi, good question. I think it depends on how similar they are. Generally I would recommend using one table for both. I created a video recently on this exact topic here: ruclips.net/video/Pg0ADtwt32k/видео.html
Got clear idea about db design for real estate. I have one question, What will be scenario for if an agent done listing, and later on he left the job. then what will be happen to the property or listing?
Good question. Ideally the listing and property will stay. And it could either be moved to a different agent, or the agent could be marked as inactive or their employment ended.
love it! is that 3rd normal form we used?
Thanks! Yes it should be!
Does anyone know about the website that follows this database design this helps me to understand the flow of the project to create
I don’t know if there are any that follow this exact design. But there are many that use the same concepts, such as real estate companies or property management companies.
@@DatabaseStar ok
This is great work, but is it suitable for converting to My SQL?
Yeah, it can be converted to any SQL database including MySQL.
keep uploading
Sure! I usually upload once per week.
Thx a lot so informative video but I wish u would speak up a bit.
Thanks! I’ve worked on my volume in recent videos but thanks for the feedback