OMIS-452-SP16 - Week 7a - OMIS 452 Database Management for...

Info icon This preview shows pages 1–10. Sign up to view the full content.

OMIS 452 Database Management for Business Northern Illinois University Brian Bender
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Agenda Past, Present & Future Ch. 6 Transforming Data Models Into Database Designs We Will Use NIUResponse.com A Look Ahead OMIS-452 Week 7a 2
Image of page 2
Ch. 6 – Models Into Designs The Past – What Have We Done So Far? Ch. 1 – Intro To Database Ch. 2 – SQL – The Prequel Ch. 3 – Relational Model & Normalization Ch. 4 – Database Design Using Normalization Ch. 5 – Entity-Relationship Modeling To Paraphrase A Great Movie Scene… “What is a Database?” “Databases are everywhere. They are all around us.” “Unfortunately, no one can be told what a Database is. You have to experience it for yourself.” OMIS-452 Week 7a 3
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Ch. 6 – Models Into Designs The Present – What Are We Doing Now? Ch. 5 & P.3 – Creating E-R Models Ch. 6 – Transforming E-R Models Into Database Designs Continuing The Movie Reference… “Have you ever had a dream, Neo, that you were so sure was real? What if you were unable to wake from that dream? How would you know the difference between the dream world and the real world?” “I'm trying to free your mind, Neo. But I can only show you the door. You're the one that has to walk through it.” “Welcome to the real world.” OMIS-452 Week 7a 4
Image of page 4
Ch. 6 – Models Into Designs The Future – In Preparation For What? Ch. 7 – SQL The Sequel (Ch. 7) P.4 – Constructing The Database In MS SQL P.5 – Populating The DB With Data Final Movie Reference… “I know you're out there. I can feel you now. I know that you're afraid... you're afraid of us. You're afraid of change. I don't know the future. I didn't come here to tell you how this is going to end. I came here to tell you how it's going to begin.” “A world where anything is possible. Where we go from there is a choice I leave to you.” OMIS-452 Week 7a 5
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Ch. 6 – Models Into Designs Turning Data Models Into Database Designs Is A Three (3) Step Process: 1. Replace Entities & Attributes With Tables & Columns 2. Place Foreign Keys Represent Relationships Show Maximum Cardinalities 3. Constrain Values Of Primary & Foreign Keys Represent Minimum Cardinality Define Actions To Constrain Values OMIS-452 Week 7a 6
Image of page 6
Ch. 6 – Models Into Designs Step 1 – Create A Relation (Table) For Each Entity Identify Candidate Keys Select The Primary Key Define Column Properties Verify Normalization OMIS-452 Week 7a 7
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Ch. 6 – Models Into Designs Identify Candidate Keys Identify All Candidate (Alternate) Keys Unique Identifier For Each Row In A Table Select The Primary Key Select One (1) Or More Candidate Keys As Primary Ideally Short, Numeric & Fixed Meaningful To DB Users Surrogate Key If Necessary OMIS-452 Week 7a 8
Image of page 8
Ch. 6 – Models Into Designs
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 10
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '08
  • staff
  • character string, strong entities, SAME Company, Brian Bender

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern