The purpose of this pedagogical approach is to

Info icon This preview shows pages 2–4. Sign up to view the full content.

View Full Document Right Arrow Icon
The purpose of this pedagogical approach is to introduce and reinforce ideas and skill sets so that students can master these on their own after class hours. To bring this knowledge to a highly proficient, professional level, students will have to spend time and effort outside of class using the system. To ensure that you have the basic knowledge that will allow you to function on your own after class, be sure to ask the instructor questions during class, either during the lecture/discussion, demo, or lab. Classroom guidelines: Attendance is not mandatory but highly recommended. Coming to class fully prepared helps push the conversation much further. Make-up exams are not available (except for excused absences). Individual deliverables are to be submitted individually and group work is collaborative. Grading: Deliverables Lab Assignments 25% Project 20% Midterm 25% Final exam 25% Participation 5% Total 100% *Late submission policy: deliverables submitted after their due date will be penalized 10% per day. No submission is accepted after the fifth day. Letter Grade Scale 98 94 90 86 82 79 75 71 68 65 62 Less than 61 A+ A A- B+ B B- C+ C C- D+ D F Additional information: Refer to for additional guidance on instructional information.
Image of page 2

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

View Full Document Right Arrow Icon
Schedule of Classes (also check the schedule of readings & questions in the next table) Week Topic Deliverables References Downloads 1 Introduction to database management systems - Basic concepts Database Modeling Project assignment S&E: Ch. 1 pp. 1-20 S&E: Ch. 2 pp. 31- 42; 51-53; 60 Hierarchical Data Model Network Data Model Intro. Slides DBMS Concepts Slides Semantic Modeling Slide 2 The Relational Data Model Conceptual Design: Mapping Relational Model Lab 1 assigned S&E: Ch. 3 pp. 65- 71 S&E: Ch. 3 pp. 72- 89 ER for class example Relational Data Model Slides Mapping the ER Model Slides Perfect Pets Practice Specs Perfect Pets ER Solution 3 SQL an introduction SQL (DDL) SQL (DML) Lab 1 due S&E: Ch. 4 - pp. 169- 191; 201 Oracle SQL Developer - Installation SQL Slides 4 SQL (Oracle specific) S&E: Ch. 5 213-267 S&E: Ch. 6 pp. 288- 311 Oracle SQL / Oracle DDL Oracle Char. Func. Oracle Numeric & Date Functions Oracle Parameters, Variables, & Views Oracle PL/SQL Intro. R.A. Example Answers from In- class exercise 5 Midterm Relational Commands, Embedded SQL, Stored Procedures, Triggers Guest Speaker Lab 2 assigned Topic : Database management & Big data Relational Views and the System Catalog Slides Flavio Villanustre ; VP - Infrastructure & Security at HPCC Systems & LexisNexis 6 Exam Review Functional Dependencies, Normalization Guest Speaker S&E: Ch. 7 - pp. 319- 334 Topic : the evolution of thinking towards DBMS Normalization Slides Kent's Five Normal Forms Article
Image of page 3
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ 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