Post reply

An Introduction to Database Design

  • January 17, 2011 at 9:23 pm

    #230493

    Comments posted to this topic are about the item An Introduction to Database Design

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • January 18, 2011 at 12:06 am

    #1274497

    Excellent article paul.Couldn't ask much better than this.

    Great work done.

    Satnam

  • January 18, 2011 at 12:09 am

    #1274498

    Very nice Paul. A good primer for the millions of simple database conversions out there.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • January 18, 2011 at 12:20 am

    #1274501

    Hats off to you, Paul! Excellent article. Very beautifully explained via the use of a nice, gripping story that evolves itself into shape.

    Thank-you!

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • January 18, 2011 at 1:17 am

    #1274517

    Brilliant article!

    Well explained - I think even a DB novice would be able to understand this.

    I wish I could have given more stars 🙂

    Kelsey Thornton
    MBCS CITP

  • January 18, 2011 at 1:57 am

    #1274536

    Excellent article!

    It really explains the basics of database design in a fun, not-too-technical manner.

    Great job!

    And it's been a long time since I've seen Alice and Bob 🙂

    (I guess the last time was when Trudy tried to hack into Bobs email account while impersonating Alice)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 18, 2011 at 2:02 am

    #1274540

    Hey Paul,

    I couldn't stop myself to say that your article was great and nicely present even a layman can understand what you trying to describe through your post.

    It just like reading some story about the SQL man.

    Good work keep it up..!!!

    Thanks,

    Anil Maharjan

  • January 18, 2011 at 5:03 am

    #1274609

    Paul, thanks for this article and very needed for me at this time as I have an intern who is learning about SQL Server database design. I quickly printed your article out for him to read today and we can discuss later.

    Brad

  • January 18, 2011 at 6:46 am

    #1274675

    Great article. I plan on sharing this with a few of my co-workers who are being pushed to learn SQL, yet don't understand DBs.

  • January 18, 2011 at 6:56 am

    #1274681

    This is quite possibly one of the best technical articles for a wide audience that I have read in a long time, Paul. To anyone who is already well acquainted with database design, there won't be much new here but that isn't the target audience, is it? I really like how the story was used and how concepts were built upon each other in manageable chunks to get to the final point.

    I haven't rated an article in long while but had to stop to log in and rate this one. Anytime I need to explain any of the concepts of normalization or explain database design to a business person, I'll be including this article as a reference.

    While the database design aspect of this article may have been a review, I did learn something here - a great method for teaching and writing.

    __________________________________________________

    Mike Walsh
    SQL Server DBA
    Blog - www.straightpathsql.com/blog |Twitter

  • January 18, 2011 at 7:02 am

    #1274689

    Its an awesome article I came across in recent past for freshers. I have suggested many freshers to see this article for understanding the table design.

    Nice example to demonstrate the complete idea of designing table.

    Great Work!!!

  • January 18, 2011 at 7:16 am

    #1274701

    Good Work Paul!

    I haven't seen any article that explains the database designing concepts like a story,easy to understand format. 🙂

  • January 18, 2011 at 7:32 am

    #1274716

    Nice work!! It's often said that to truly understand a concept you should be able to explain it to others in simple terms and you've definitely done that with this article. Simplicity to the point of brilliance. I shall refer to this when explaining database design concepts to customers.

  • January 18, 2011 at 8:01 am

    #1274741

    I believe there are some serious flaws in this article. For example, recepts represent a historical record of a transaction occuring in a moment in time.

    If one normalizes the customer as is done in this example, and simply uses a foreign key in each receipt, what happens if a customer changes their address at some later time? or name? (people do get married).

    Now, ALL of the historical receipts return the NEW address or customer name, not the address or name of record at the time of the sale.

    This can't be correct, and would get most businesses in serious legal trouble. And I personally have seen this type of nonsense in many amateurish attempts at normalization.

    This presentation is oversimplified to the point of providing poor instruction I am afraid...

  • January 18, 2011 at 8:07 am

    #1274745

    I should dd that bob's original paper receipts were MORE accurate than the DB design offered. At least the paper receipts would always return accurate info for the customer for the moment in time the sale was completed....

Viewing 15 posts - 1 through 15 (of 125 total)

You must be logged in to reply to this topic. Login to reply