Lecture_1_ERD_print.pptx - Data Management Visual Analytics...

  • No School
  • AA 1
  • 56

This preview shows page 1 - 9 out of 56 pages.

Data Management & Visual Analytics MSCI:6050 FALL 2019 LECTURE 1: INTRODUCTION AND E-R MODEL 1
Image of page 1

Subscribe to view the full document.

Course Overview Objectives Learn the core concepts and technologies of relational database systems Learn how to visualize the data and information using Tableau Main topics Conceptual data model (E-R model) Relational data model SQL (Structured Query Language) Data analysis using SQL Web-based database application Visual analytics using Tableau 2
Image of page 2
Textbook & References Textbook (optional) Jeffrey A. Hoffer, V. Ramesh, Heikki Topi, " Modern Database Management ", 13th Edition, ISBN: 9780134792279, Pearson, 2019. Online References Oracle Database SQL Language Reference http:// docs.oracle.com/cd/E11882_01/server.112/e41084.pdf Application Express Tutorials Tableau Free Training Videos Course materials ICON ( / ) 3
Image of page 3

Subscribe to view the full document.

Computer and Software Laptop computer o Main-stream browser with WiFi access Oracle SQL Developer o Download it and install it onto your laptop o http:// Oracle Application Express (APEX) o Sign up for a free workspace on APEX – tutorials will be posted on ICON o https:// apex.oracle.com/en/ Tableau o Download Tableau desktop and request your one-year license for free o https:// 4
Image of page 4
Assignments and exams 4 HW assignments 30% -- individual work 1 group project 30% -- no more than 5 students for each group 1 mid-term exam 30% Class participation 10% Assignments should be submitted online at ICON Late submissions subject to 25% penalty per day See syllabus for more details 5
Image of page 5

Subscribe to view the full document.

Grading Policy Final Grade – Based on Class Ranking o A range: A, A- o B range: B+, B, B- o C range and below: Performance far below the majority of the class 6 Grade Percentage A range B range C range and below As needed for lack of mastery
Image of page 6
Expectations Attend lectures : Students are responsible for being aware of everything taught/announced in class There will be in-class exercises to help improve understanding of lectures. Don’t miss them. Time commitment : spend time reviewing lectures, reading textbooks, and doing homework. Only sitting in class does not help much. Finish assignments as required on time. Plan things ahead. Don’t wait until the last minute! Travel plans, make-up exams, projects, homework 7
Image of page 7

Subscribe to view the full document.

Contact Information Email : weiguo-fan[email protected] [Please include “MSCI:6050” in your subject line] Phone : 319-467-0388 Office : S262 Pappajohn Business Building (21 E Market St, Iowa City) Office hours : Before/after class in classroom or office By appointment (on campus) ICON discussion I will try to reply as soon as I can Other students are welcome to discuss and reply No disclosure of homework solutions!
Image of page 8
Image of page 9
  • Fall '19
  • Entity-relationship model, Multivalued, Mellissa Kraft

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

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes