Intro to Relational Database Design & Entity-Relationship Diagrams

  • May 8, 2013 · 6:30 PM
  • This location is shown only to members

Speaker Mark Abramson of Forward Thought

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.

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 demo usage, pitfalls, problems and design tradeoffs.

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. There will be discussion of various commercial and open source tools to streamline your work.

Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder of Medicine of Cycling and Vice Chairman of USA Cycling.  A veteran of both early-stage startups and enterprise software projects, he has particular technical expertise in complex global supply chains for high-growth companies.  He's also a dad, runs the Microsoft BizSparkSF group for Bay Area startups, collects antique woodworking machines and mentors on Lean Startup methods.

Join or login to comment.

  • Mark G.

    Thanks to Mark Abramson for a terrific session. We appreciate your time and and knowledge-sharing with the SQL Server community.

    May 14, 2013

  • Nelson L.

    Mark Abramson did a good job in presenting the material. He covered the items on the agenda in some details and stayed on the topic items. The session has added knowledge to my understanding of database design. Performance came up in the discussion, I think a good follow up session would be one on creating data table indexes and writing database queries to utilize the available indexes.

    May 9, 2013

  • william h.

    One may have added some caveats in SQL coding when there is a self-referential (recursive) relationship in the ERD.

    May 9, 2013

  • Mark A.

    @Alex - we'll go over the theory, work through a couple of examples and then dive into a demo.

    @Alp - those topics are more in line with the Microsoft BI Meetup group - they have some incredible data warehouse and business intelligence experts every month.

    @Shibani - move to the west coast! But seriously, there are some great sessions on online learning sites like Udemy.

    May 7, 2013

    • Alex

      Thanks Mark. Should I have dinner before arriving?

      May 7, 2013

    • Mark A.

      The SQL Server Group provides pizza and beverages along with the event. Pizza and DB design? Can't be beat.

      1 · May 8, 2013

  • Christian H.

    Looking forward for clearing a few SQL related things up.

    May 7, 2013

  • Nan H.

    Thnaks

    May 7, 2013

  • Shibani D.

    Is there any way I can get the video to watch tomorrow's presentation and /or PDF to learn about relational database design and entity relationship diagram with real life examples. I am at East coast - Massachusetts and a rising DBA. webcasts and Webiner that I attended and came across have not touched upon this topic and I believe it is an essential part of DBA/ Developers role. Thank you in advance.

    Shibani

    May 7, 2013

  • Bob A.

    I planning to attend, if all goes well earlier in the day.

    May 7, 2013

  • Alp O.

    if you have enough time, "differences between OLTP and OLAP systems" ,"star design and snow flake design" and "Facts, Dimension, Measures" would be good topics..

    1 · May 6, 2013

  • Alex

    I'm with Paul, I'd like to get a review of concepts and then see some implementation. To Jim - installation, configuration, and connectivity protocols are usually pretty straightforward. You'd be surprised how much you can learn just by googling. MySQL is a good db that you can dl standalone from Oracle's site or bundled with server languages, try XAMP by apache friends to start.

    May 6, 2013

  • Rafael E.

    We have a payment processing database. I'd like to be able to follow and trace the payment chains to different payment accounts in order to determine and project potential pay-per-use revenues.

    May 6, 2013

  • Mark A.

    @Shibani the talk is live only - no webcast will be available.

    @Carlos - great! I hope it will be informative for you.

    Everyone else, please post any specific areas you would like to cover and I will try to incorporate it into the talk. Look forward to seeing everyone on Wednesday!

    May 4, 2013

    • Paul K.

      I'd like to hear about "is a" relationships and mapping schemes used in ORMs (table per type vs. table per hierarchy)

      May 6, 2013

  • carlos r.

    Needing more exposure to SQL

    May 3, 2013

  • Shibani D.

    Is it Online ? I can atleast particpate and watch the webcast/webinar as I am in east coast. Iam looking forward to this event, very interesting.

    May 1, 2013

Our Sponsors

People in this
Meetup are also in:

You don't have to be an expert to start your own Meetup Group

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

Start your Meetup today

Act now and get 50% off.
Until February 1.

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