Syllabus
NOTE:
Course ID/PWD will be distributed in the first class (or shown in the syllabus page in Canvas). This ID/PWD is different from your PSU ID/PWD.
Details
Time: M W 2:30 PM - 3:45 PM
Location: 205 IST
Staff
Instructor: Prof. Dongwon Lee (dul13@psu). Office Hour: WED 1-2 PM & 4-5pm @ 313A
TA: Jason Zheng (jpz5181@psu). Office Hour: TUE 1-3 PM @ 325D
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
The Fundamentals of Database Management Systems (2nd edition) by Mark L. Gillenson (ISBN:0470624701) is the REQUIRED textbook. The old edition of the same book (ISBN: 0471262978) can be also used if preferred (some chapters are re-arranged in the new edition so that those with old edition just have to convert chapter numbers properly in reading homework, etc). 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, 4, 5, 6, 7, and 8. 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).
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 ------------------------------------------------------------------------------ 10% 100 6 Short UNANNOUNCED Problems/Quizzes (20 points each) This substitutes attendance check
(students may miss up to ONCE)
12% 120 2 Written Homework (Individual) 23% 230 2 Team Projects (100/130 points each)
5% 50 1 Project Presentation (team presentation, individual grading) 20% 200 1 Closed Book Midterm 30% 300 1 Closed Book Final
Assignment Submission Policy
Please note the following:
Homework and Projects are usually assigned during WED class
Dues are by default SUN 11:55PM (EST)
Students can submit late with the penalty of 25% deduction for every 12 hours late (up to 2 days)
After 2 days, no more late submission is allowed
Academic Integrity
According to the Penn State Principles and University Code of Conduct: Academic integrity is a basic guiding principle for all academic activity at Penn State University, allowing the pursuit of scholarly activity in an open, honest, and responsible manner. In according with the University’s Code of Conduct, you must not engage in or tolerate academic dishonesty. This includes, but is not limited to cheating, plagiarism, fabrication of information or citations, facilitating acts of academic dishonesty by others, unauthorized possession of examinations, submitting work of another person, or work previously used without informing the instructor, or tampering with the academic work of other students. Any violation of academic integrity will be investigated, and where warranted, punitive action will be taken. For every incident when a penalty of any kind is assessed, a report must be filed.
Plagiarism (Cheating): Talking over your ideas and getting comments on your writing from friends are NOT examples of plagiarism. Taking someone else's words (published or not) and calling them your own IS plagiarism. Plagiarism has dire consequences, including flunking the paper in question, flunking the course, and university disciplinary action, depending on the circumstances of the office. The simplest way to avoid plagiarism is to document the sources of your information carefully.
Disability Access Statement
Americans with Disabilities Act: The School of Information Sciences and Technology welcomes persons with disabilities to all of its classes, programs, and events. If you need accommodations, or have questions about access to buildings where IST activities are held, please contact us in advance of your participation or visit. If you need assistance during a class, program, or event, please contact the member of our staff or faculty in charge. Access to IST courses should be arranged by contacting the Office of Human Resources, 332 IST Building: (814) 865-8949.
Students with Disabilities: It is Penn State’s policy to not discriminate against qualified students with documented disabilities in its educational programs. (You may refer to the Nondiscrimination Policy in the Student Guide to University Policies and Rules.) If you have a disability-related need for reasonable academic adjustments in this course, contact the Office for Disability Services (ODS) at 814-863-1807 (V/TTY). For further information regarding ODS, please visit the Office for Disability Services Web site at http://equity.psu.edu/ods/.
In order to receive consideration for course accommodations, you must contact ODS and provide documentation (see documentation guidelines at http://equity.psu.edu/ods/guidelines/documentation-guidelines). If the documentation supports the need for academic adjustments, ODS will provide a letter identifying appropriate academic adjustments. Please share this letter and discuss the adjustments with your instructor as early in the course as possible. You must contact ODS and request academic adjustment letters at the beginning of each semester.
Statement on Nondiscrimination & Harassment (Policy AD42)
The Pennsylvania State University is committed to the policy that all persons shall have equal access to programs, facilities, admission and employment without regard to personal characteristics not related to ability, performance, or qualifications as determined by University policy or by state or federal authorities. It is the policy of the University to maintain an academic and work environment free of discrimination, including harassment. The Pennsylvania State University prohibits discrimination and harassment against any person because of age, ancestry, color, disability or handicap, national origin, race, religious creed, sex, sexual orientation, gender identity or veteran status. Discrimination or harassment against faculty, staff or students will not be tolerated at The Pennsylvania State University. You may direct inquiries to the Office of Multicultural Affairs, 332 Information Sciences and Technology Building, University Park, PA 16802; Tel 814-865-0077 or to the Office of Affirmative Action, 328 Boucke Building, University Park, PA 16802-5901; Tel 814-865-4700/V, 814-863-1150/TTY.
For reference to the full policy (Policy AD42: Statement on Nondiscrimination and Harassment): http://guru.psu.edu/policies/AD42.html