Monday, May 12, 2014

E-R Diagram for Sample University Database in My Pluralsight Course

I always like to have an E-R diagram handy whenever I am dealing with a database, and maybe some of you do as well.  If that is the case, there is the E-R diagram that I use in my Pluralsight course "Oracle Performance Tuning for Developers".  It should print on legal paper, so you shouldn't have too much trouble if you want a hard copy.

E-R Diagram for University Schema
Posted by at

8 comments:

  1. UnknownAugust 6, 2015 at 3:38 AM

    Hello David,
    Thanks for the E-R Diagram, I want to ask if there is any link we can use to download the dump file?

    BR//

    ReplyDelete
    Replies
    1. UnknownAugust 23, 2015 at 5:24 PM

      Hi Fatai,
      I apologize for not seeing this sooner. I assume you are talking about the sample database here. If you are a Pluralsight plus subscriber, you can download it as part of the course materials. Also, my later courses I have just been making the samples available here so anyone can get them, so here is a direct link to where they are.

      https://drive.google.com/file/d/0B-kpH7AX6Uc5dzJOcDROSFU5amc/view?usp=sharing

      I hope this works for you,

      Thanks,
      David

      Delete
  2. hanplJanuary 6, 2016 at 1:56 PM

    This comment has been removed by the author.

    ReplyDelete
  3. hanplJanuary 6, 2016 at 1:57 PM

    Hello David,
    I got a small problem to import this file:
    ORA-39142: incompatible version number 4.1 in dump file "C:\app\....\oradata\GDBN\Import\student_data.dmp"
    I'm using Oracle DB 11gr2 - 11.2.0.1.0. What can I do in this case to import this dump file?

    ReplyDelete
  4. UnknownFebruary 5, 2016 at 9:37 AM

    hello hanpl
    do you import the file ? if ok please could you give me your solution

    ReplyDelete
  5. UnknownDecember 29, 2018 at 3:31 AM

    Hello David,

    Can you please share the download location of the dump file "STUDENT_DATA.dmp" which contains the tables APPLICATIONS, STUDENTS, COURSE_OFFERINGS & COURSE_ENROLLMENTS.

    Thanks in Advance,
    Siva

    ReplyDelete
  6. UnknownDecember 24, 2020 at 5:58 AM

    Hi,

    I am using Oracle Autonomus database in Oracle cloud.
    Can somebody suggest me how to import the .DMP file to proceed furthe with the course.

    Thx
    Dhaya

    ReplyDelete
  7. Suman PanigrahiJune 20, 2022 at 5:55 AM

    Hi David,
    Can you please share the tool or the website which you used to build the ERD ?
    I want to build mine.

    ReplyDelete

Subscribe to: Post Comments (Atom)