Intro to Relational Database Design & Entity Relationship Diagrams

  • May 17, 2012 · 6:30 PM
  • Microsoft Office

Update:  Meeting Rescheduled for May 17!

Speaker: Mark Abramson of Forward Thought

Mark will cover the basics of designing and setting up a database schema. He'll define some common business scenarios, build out some tables, create relationships, and then go through usage, pitfalls, problems and design tradeoffs.

With so many database-driven projects for consumer desktop software applications, websites and enterprise software systems, the database design plays a crucial role in the success of your project.


You'll see real-life examples and issues such as:

  • Creating a new table
  • Choosing data types
  • Normalization (and when to denormalize)
  • Types of relationships
  • Referential integrity
  • Join/relationship tables
  • 1-to-many, many-to-many
  • How to actually use these structures in your application

While the examples will focus on SQL Server, the techniques and SQL code will work for virtually any SQL database.

Mark Abramson is CEO of Forward Thought in Sausalito, which solves global supply chain challenges for high-growth companies. He's a veteran of several startups and has worked with companies in the Global 50 and NASA. Mark runs the Microsoft BizSparkSF user group for Bay Area startups. He's also a dad, a power tool aficionado, and a cyclist. Mark is a past President of USA Cycling and co-founder of Medicine of Cycling.

Join or login to comment.

  • Sergey Z.

    Btw, I think it was very basic for the most of the audience. I do not see how developers and DBAs would not know the material unless they are just starting.

    May 21, 2012

  • A former member
    A former member

    This was a refresher, and was presented such that it was easy to understand for newcomers as well as a good presentation of concepts.

    May 18, 2012

  • J. B.

    good knowledge, good info, good presentation - well done

    May 18, 2012

  • Mark A.

    Thanks everyone for taking your own personal time to come out and learn at the intro to DB design talk. It was a blast! I'll be giving the talk again at Code Camp in Oct (free): http://www.siliconvalley-codeca...­

    Slides & Files: http://www.forwardthought.com/?...­

    And please drop a line (@mark__a or www.linkedin.com/in/abramsonmark) and let me know what you're doing/learning -- great to hear stories from the field.

    May 18, 2012

  • A former member
    A former member

    Great into to relational databases. Speaker was good, and nice that they had some snacks and refreshments.

    May 18, 2012

  • Catt

    What is the time of talk start?

    May 17, 2012

  • Mark A.

    @Sergey, the presentation is on the fundamentals of DB design using Entity Relationship diagrams. It should be useful for a broad audience and experience levels from newer developers to seasoned programmers. I've found that even experienced developers can benefit from a review of the concepts of schema design and we can go deeper into some specific areas during the demo. Look forward to seeing you tonight!

    May 17, 2012

  • Sergey Z.

    who is the targeted audience? What level? Is it for developers who do it every day or people who never saw a DB?

    May 17, 2012

Our Sponsors

People in this
Meetup are also in:

Sometimes the best Meetup Group is the one you start

Get started Learn more
Katie

I'm surprised by the level of growth I've seen since becoming an organizer, it's given me more confidence in my abilities.

Katie, started NYC ICO

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy