___________________________________________________________________ IST 210 Course Syllabus ___________________________________________________________________ Semester : Fall 2010 Time : T R 04:15P - 05:30P Location : 202 IST [[ Course Web Page ]] http://pike.psu.edu/classes/ist210/2010-fall/ NOTE: Course ID and password: to be announced in the first class. This is different from your PSU ID and password. [[ Overview ]] This is an introductory course to teach the fundamentals and basic principles of databases and their related technologies. Throughout this course, students will explore those areas, which are fundamental to the design, development, and implementation of enterprise wide information systems. In this course, in particular, we will cover the following major topics: - Introduction to Databases and Database Technologies - Conceptualization of Database Designs - Database Design Refinement - Database Design Implementation - Database Management and Administration - The Future of Databases [[ Textbook ]] Fundamentals of Database Management Systems by Mark L. Gillenson (ISBN:0471262978) is the REQUIRED textbook. PSU Bookstore should have new copies ready, but feel free to buy a USED copy from the Internet for saving. From the textbook, we will mainly focus on chapters 2, 3, 4, 5, 6, 7, 9, and 15. In addition, we will study advanced SQL features beyond what is covered in the textbook. [[ DBMS ]] We use the Microsoft SQL Server in IST's VLabs environment. If you are within PSU IP domain, you can read related books from O'Reilly's Safari for free. Our choice of the DBMS has nothing to do with the superiority of the product. Therefore, by all means, if you are already familiar with other one, you are free to use other DBMS for your projects (i.e., MySQL, PostgreSQL, mSQL, DB2, Oracle, etc). [[ Staff ]] Instructor : Dr. Dongwon Lee, Email: dongwon -at- psu.edu TA : JY Kim, Email: bassjykim -at- gmail.com Helpdesk : IST 201, x38803, 777-0035 (ITS) [[ Office Hour ]] Instructor : Tue 10:00A - 12:00P (313A IST) or by appointment TA : Wed 4:30P - 6:30P (325D IST) or by appointment [[ Grading Scale ]] Grade Percentage Points --------------------------------------------- A 93% to 100% 930 to 1000 A- 90% to 92.9% 900 to 929 B+ 87% to 89.9% 870 to 899 B 83% to 86.9% 830 to 869 B- 80% to 82.9% 800 to 829 C+ 77% to 79.9% 770 to 799 C 70% to 76.9% 700 to 769 D 60% to 69.9% 600 to 699 F Less than 60% less than 600 [[ Grading Weights ]] % of Grade Points Freq. Assignments ------------------------------------------------------------------------------ 12% 120 6 Short Problems (20 points each) This substitutes attendance check 10% 100 2 Written Homework (50 points each) 25% 250 3 Team Projects (60, 80, 110, points each) 3% 30 1 Project Presentation (team presentation, individual grading) 20% 200 1 Closed Book Midterm 30% 300 1 Closed Book Final