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