Instructor: Dongwon Lee (dul13)
Office Hour: THUR 8:30-10:30am @ http://tiny.cc/ist210-zoom/
Section 3
Time: WED/FRI 12:45pm-2pm @ Westgate E202
TA: Jason Lucas (jsl5710)
Office Hour: FRI 10am-noon @ https://psu.zoom.us/j/92119771762
Section 8
Time: WED/FRI 2:30pm-3:45pm @ Waring 108
TA: Wooyong Jung (wjung)
Office Hour: TUE 4-6pm @ https://psu.zoom.us/j/3125661431
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 and Implementation
Indexing and Storage Systems
Querying Databases using SQL
The Future of Databases
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.
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 DBMS, you are free to use them for your projects (i.e., MySQL, PostgreSQL, mSQL, DB2, Oracle, etc).
A : 93% to 100% (930 to 1000 points)
A- : 90% to 92.9% (900 to 929 points)
B+ : 87% to 89.9% (870 to 899 points)
B: 83% to 86.9% (830 to 869 points)
B-: 80% to 82.9% (800 to 829 points)
C+: 77% to 79.9% (770 to 799 points)
C: 70% to 76.9% (700 to 769 points)
D : 60% to 69.9% (600 to 699 points)
F : Less than 60% (less than 600 points)
Attendance: 3% (30 points)
Two Assignments: 12% (120 points)
Project: 35% (350 points)
Project #1 (team): 15% (150 points)
Project #2 (team): 20% (200 points)
Exam: 50% (500 points)
Midterm: 20% (200 points)
Final Exam: 30% (300 points)
Students can submit assignments/projects 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
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.
Penn State welcomes students with disabilities into the University’s educational programs. Every Penn State campus has an office for students with disabilities. Student Disability Resources (SDR) website provides contact information for every Penn State campus (http://equity.psu.edu/sdr/disability-coordinator). For further information, please visit Student Disability Resources website (http://equity.psu.edu/sdr/).
In order to receive consideration for reasonable accommodations, you must contact the appropriate disability services office at the campus where you are officially enrolled, participate in an intake interview, and provide documentation: See documentation guidelines (http://equity.psu.edu/sdr/guidelines). If the documentation supports your request for reasonable accommodations, your campus disability services office will provide you with an accommodation letter. Please share this letter with your instructors and discuss the accommodations with them as early as possible. You must follow this process for every semester that you request accommodations.