{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

2012S+-+MIS245+-+Syllabus

2012S+-+MIS245+-+Syllabus - MIS 245 Database Systems and...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
MIS 245 – Database Systems and Data Warehousing Course Syllabus & Schedule Class Information Prerequisite: MIS 235 (or equivalent approved by instructor) Time: Section A: TR 12:45-2:00 PM Section B: TR 2:15-3:30 PM Location: FSB 2050 Instructor Name: Dr. Douglas Havelka Office: 3119 FSB Office Hours: TR 3:35-4:30 and by appointment. Phone: 529-4836 E-Mail: [email protected] Textbook: Database Systems: Design, Implementation, and Management , 9th edition, by Coronel, Morris, and Rob (ISBN: 978-0-538-46968-5), Student data files and other helpful resources are available at www.cengagebrain.com . Course Overview: This course is designed to provide an understanding of database systems in organizations, their design methodologies, structured query language (SQL), data warehouses, and the implementation and management of database systems. We will analyze, design, and implement database applications using database management software, e.g. Oracle or MS Access. You will be expected to demonstrate proficiency in data modeling, database design, normalization, and SQL. Learning Objectives Upon successful completion of the course, you should be able to do the following: Conceptual knowledge: o Understand and use the terminology of the database management field. o Articulate the importance of data integrity requirements to organizations. Database design: o Within a given business context, develop and document information requirements in the form of business rules. o Construct the graphical representation (ERD or class diagram) of a conceptual model. o Evaluate alternative conceptual models.
Image of page 1

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

View Full Document Right Arrow Icon
o Translate entity-relationship diagrams into a set of tables in third normal form to be implemented using a relational DBMS. o Generate appropriate database documentation. Database implementation: o Write SQL statements to build database tables and populate them with data. o Write SQL statements to retrieve information from databases. o Use application tools to construct report layouts and convert retrieved data to reports useful for managerial decision making. o Construct forms in an application tool to allow end-users to use the applications effectively. o Demonstrate the value of the database for managerial decision making. Data Warehouses: o Describe the differences between transaction/operational data and decision support data. o Explain the importance of data warehouses and real-time access to decision support data. o Explain a simple star schema. o Write SQL statements to populate a simple data warehouse using transaction/operational data.
Image of page 2
Image of page 3
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