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

112 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



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?