CMU ISM 95703 - 37222_2774272_Syllabus+95703+E+F2018 (7 pages)

Previewing pages 1, 2 of 7 page document View the full content.
View Full Document

37222_2774272_Syllabus+95703+E+F2018



Previewing pages 1, 2 of actual document.

View the full content.
View Full Document
View Full Document

37222_2774272_Syllabus+95703+E+F2018

126 views


Pages:
7
School:
Carnegie Mellon University
Course:
Ism 95703 - Database Management
Unformatted text preview:

Course Information 95 703 E Database Management 12 Unit Course Fall 2018 Instructor Janusz Szczypula Office Hamburg Hall HbH 3036 Phone 268 6096 E mail js1m andrew cmu edu Office hours Wednesday 9 a m 12 noon and by appointment Teaching Assistants TBD Meeting Times Monday Wednesday 3 00 p m 4 20 p m HbH 2008 Class Website www cmu edu canvas Prerequisites There are no prerequisites for this course for students in Data Analytics in MISM and in MSIT Programs in the Heinz College For other Heinz College students 90728 Introduction to Database Management is a prerequisite Description Databases systems are central to most organizations information systems strategies At any organizational level users can expect to have frequent contact with database systems Therefore skill in using such systems understanding their capabilities and limitations knowing how to access data directly or through technical specialists knowing how to effectively use the information such systems can provide and skills in designing new systems and related applications is a distinct advantage and necessity today The Relational Database Management System RDBMS is one type of database systems that is most often used these days and is the primary focus of this course Further to provide students with opportunity to apply the knowledge they learn from the lectures various homework assignments SQL assignments and a database implementation project will be given All the TAs will be helping students from any section of the Database Management class Complete list of TAs and their office hours will be posted on the class website Course Materials Lecture Notes Lecture notes will be provided for each class They can be used during the semester you take the class They cannot be shared after the class is concluded without permission of the instructor Textbook Casteel J Oracle 11g SQL Course Technology Cengage Learning 2014 Suggested Books Connolly T and C Begg Database Systems A Practical Approach to Design Implementation and Management 6th edition Addison Wesley 2015 Coronel C and S Morris Database Systems Design Implementation Management 12th edition Cengage Learning 2017 Hoffer J A R Venkataraman and Heikki Topi Modern Database Management 11th edition Prentice Hall 2012 Price J Oracle Database 11g SQL McGraw Hill 2008 Software We will use Oracle Database 11g Express Edition for Windows No other components of Oracle Software will be used in this class Course Objectives Objective Gain good understanding of relational data model in terms of data structure data integrity and data manipulation How Assessed Homework Assignment Final Exam Understand and create conceptual database models utilizing entity relationship modeling Homework Assignment Final Exam Design data structures that will limit redundancy and enforce data integrity while conforming to organizational requirements utilizing normalization methodology Homework Assignment Final Exam Understand the theory behind the relational data model as it applies to interactions with current database management systems Homework Assignment Final Exam Read and interpret a given data model to query the database and transform the data into information using Structured Query Language SQL SQL Assignment Project Implement a data model in a current relational database management system Project Create reports based on transactional data including elements such as data groupings and summary values SQL Assignment Project 2 Evaluation Method Student s performance in the class will be evaluated based on the following components Homework Assignments SQL Assignments Project Final Exam 20 15 15 50 100 Homework Assignments The homework assignments require students to employ holistic critical thinking to design database models applying the concepts learnt in the lectures The focus is on understanding business requirement and designing data models to capture good quality data The range of topics covered in the assignments includes conceptual and logical database modeling normalization and relational algebra The relational algebra assignment is a foundation for learning the Structured Query Language SQL SQL Assignments The SQL assignments are hands on assignments that require students to create and execute various SQL statements and queries using Oracle Database 11g Express System The submitted assignments are required to be well formatted and readable Project Based on the logical model of a small database the project consists of implementing the data structure performing specific queries data manipulation tasks and querying system catalog to retrieve metadata The project will integrate and apply the concepts you have learned in class Detailed guidelines for the project assignment will be distributed and discussed in a later part of the semester The project deliverables are due at the beginning of the last class meeting see the course outline below Exam The exam will be a comprehensive closed book closed notes exam The exam is to be completed by you individually without help of any other student The date for the exam is specified in the class schedule The exam will be graded by the Instructor and class TA Final grades will be posted in the official Student Information System that can be accessed by students directly through the Internet Grading Scale A A A 97 100 93 96 99 89 92 99 B B B 85 88 99 81 84 99 77 80 99 Scores below 65 equate to a failing grade R 3 C C C 73 76 99 69 72 99 65 68 99 Course Outline Topic Suggested Readings Week 1 August 27 M August 29 W M Introduction to Database Models W Relational Model CM Ch 1 2 pp 2 48 CB Ch 4 pp 101 115 Week 2 September 3 M September 5 W M Labor Day No Class W Entity Relationship ER Modeling Suggested Readings CB Ch 12 pp 357 381 Assignment HW 1 handed out Due September 12 Topic Week 3 September 10 M September 12 W M Extended ER Modeling W Logical Database Design Suggested Readings HVT Ch 4 pp 153 175 CB Ch 17 pp 479 496 Assignment HW 2 handed out Due September 19 Topic Week 4 September 17 M September 19 W M Normalization of Database Tables W Advanced Normal Forms Suggested Readings CM Ch 6 pp 201 220 HVT appendix B pp 548 553 Assignment HW 3 handed out Due September 26 Topic Week 5 September 24 M September 26 W M Relational Algebra W Relational Algebra Examples Suggested Readings CB Ch 5 pp 119 130 Assignment HW 4 handed out Due October 3 Topic Topic Required Readings Topic Required Readings Topic Required Readings Assignment Week 6 October 1 M October 3 W M


View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view 37222_2774272_Syllabus+95703+E+F2018 and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view 37222_2774272_Syllabus+95703+E+F2018 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?