Database Design for Real Estate Company

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 44

  • @DatabaseStar
    @DatabaseStar  Місяць тому +1

    Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?

  • @JimRohn-u8c
    @JimRohn-u8c Рік тому +10

    I love these! Please keep making more database design videos!

    • @DatabaseStar
      @DatabaseStar  Рік тому +1

      Thanks! Glad to hear you like them. Do you have any database design topic suggestions?

    • @JimRohn-u8c
      @JimRohn-u8c Рік тому +1

      @@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.

    • @sobeck6900
      @sobeck6900 Рік тому

      perhaps topic about scheduling appointments@@DatabaseStar

    • @CarlosRL97
      @CarlosRL97 Рік тому

      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

    • @DatabaseStar
      @DatabaseStar  Рік тому +1

      Great ideas, thanks for the suggestions! I'll add them to my list of videos.

  • @CarlosRL97
    @CarlosRL97 Рік тому +3

    the knowledge that these videos provide is incredible, thank you!

  • @NotAllHeroesWearCapes-101
    @NotAllHeroesWearCapes-101 Рік тому +4

    Love your videos. Like the new tool.. but creating ref line outside tables feels weird

    • @DatabaseStar
      @DatabaseStar  Рік тому

      Thanks! Yeah it does feel a bit strange!

  • @michaelyao9389
    @michaelyao9389 Рік тому +1

    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?

    • @DatabaseStar
      @DatabaseStar  Рік тому

      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.

    • @michaelyao9389
      @michaelyao9389 Рік тому

      Hi. @@DatabaseStarYeah. Thanks for the reply and confirmation. Love your videos. I leart a lot from your channel. Thank you again. :)

  • @thomasmabika7291
    @thomasmabika7291 Рік тому +1

    Wonderful! Please do database design for Airbnb.

  • @AndrulisTravel
    @AndrulisTravel 11 місяців тому +1

    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?

    • @DatabaseStar
      @DatabaseStar  11 місяців тому +2

      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.

    • @AndrulisTravel
      @AndrulisTravel 11 місяців тому

      @@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.

  • @susmantobealivebruh4238
    @susmantobealivebruh4238 Рік тому +2

    Love your videos been following you for some time! Can you please make for a Hotel management application! Thank you!

    • @DatabaseStar
      @DatabaseStar  Рік тому

      Thanks! Good idea, I think that's on my list.

  • @codingcambodia
    @codingcambodia Рік тому +1

    It is easy to understand. May you design a small database design for a POS system for a coffee shop?

    • @DatabaseStar
      @DatabaseStar  Рік тому +1

      Thanks! Yes I can create a video for that.

  • @3ALEGIONS
    @3ALEGIONS Рік тому

    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?

    • @DatabaseStar
      @DatabaseStar  Рік тому

      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: ua-cam.com/video/Pg0ADtwt32k/v-deo.html

  • @AnsarIqbal-n4p
    @AnsarIqbal-n4p 10 місяців тому

    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?

    • @DatabaseStar
      @DatabaseStar  10 місяців тому +1

      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.

  • @rohitpandey832
    @rohitpandey832 Рік тому

    The content is very good as always. The new tool i feel is a distraction. Thanks for all the effort.

    • @DatabaseStar
      @DatabaseStar  Рік тому

      Thanks for the feedback on the new tool! Glad you like the videos too.

  • @trentcox9239
    @trentcox9239 Рік тому +2

    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

    • @DatabaseStar
      @DatabaseStar  Рік тому +2

      Good idea! I can create a video on that topic. I've seen some approaches to this I can use.

  • @SherryLonyy
    @SherryLonyy Рік тому

    love it! is that 3rd normal form we used?

  • @tareq6364
    @tareq6364 Рік тому

    This is great work, but is it suitable for converting to My SQL?

    • @DatabaseStar
      @DatabaseStar  Рік тому

      Yeah, it can be converted to any SQL database including MySQL.

  • @muhammadali7092
    @muhammadali7092 Рік тому

    Does anyone know about the website that follows this database design this helps me to understand the flow of the project to create

    • @DatabaseStar
      @DatabaseStar  Рік тому +1

      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.

    • @muhammadali7092
      @muhammadali7092 Рік тому

      @@DatabaseStar ok

  • @YacineBenjedidia-wm6pw
    @YacineBenjedidia-wm6pw Рік тому

    very interesting. thanks

  • @arupde6320
    @arupde6320 Рік тому

    keep uploading

  • @user-yz2ct2sy3l
    @user-yz2ct2sy3l Місяць тому

    Thx a lot so informative video but I wish u would speak up a bit.

    • @DatabaseStar
      @DatabaseStar  Місяць тому +1

      Thanks! I’ve worked on my volume in recent videos but thanks for the feedback