Database Management Systems Syllabus

Database Management Systems Syllabus - Saiwu Lin Saunders...

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

View Full Document Right Arrow Icon
Saiwu Lin, Saunders College of Business, Rochester Institute of Technology Database Management Systems Professor Saiwu Lin Database Management Systems(MGIS320) Spring (2014 – 2015) E-mail:[email protected] Tuesday Thursday 3:30pm - 4:15pm Web site: http://mycourses.rit.edu Classroom: LOW(12)-3135 Office Hours (LOW (12)-3344) Tuesday 2:00pm - 3:30pm Thursday 2:00pm - 3:30am Course Overview This course is designed to provide individuals with a complete introduction to database concepts and the relational database model. Topics include QBE, SQL, normalization, design methodology, DBMS functions, database administration, and other database management approaches. This course uses a problem-based approach to learning. Text and Course Materials Text: Concepts of Database Management, Philip J. Pratt and Joseph J. Adamski, Course Technology, 7 th edition. (The custom version ISBN: 9781285906720 ) (Hereafter, abbreviated DMC ) Materials: Lecture notes, Handouts, Videos, Internet resources Course Objectives After completing the course, you should be able to: Use Access to develop a database based on a business scenario. Use SQL to retrieve data. Use Visio to develop conceptual data model. Understand a user’s database requirements and translate those requirements into a valid database design Demonstrate an understanding of database concepts and technologies Assess data and information requirements Construct conceptual data models Develop logical data models Evaluate the normality of a logical data model, and correct any anomalies Develop physical data models for relational database management systems Implement relational databases Be familiar with the concepts related to advanced database topics including database administration, enterprise resource planning systems and big data Grading Policy: 1
Image of page 1

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

View Full Document Right Arrow Icon
2 Exam 1 20% Exam 2 20% Homework 20% Group Project 20% Class attendance and participation 20% A - Truly exceptional performance B - Exceeded expectations C - Met expectations D - Fell below expectations F - Did not meet required standard A 93-100 A- 90-92 B+ 87-89 B 83-86 B- 80-82 C+ 77-79 C 73-76 C- 70-72 D 60-69 F <60
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