Course Syllabus LI 844XI Database Design Summer Semester 2018 Faculty: Anne Arendt E-mail: aarendt@emporia.edu or anne.marie.arendt@gmail.com Online Course Login: canvas.emporia.edu Credit Hours: 3 Instructor Contact Information Email is the strongly preferred method of communication via the online course shell. Program Goal The goal of the SLIM Master of Library Science program is to prepare creative problem solvers who will provide proactive client-centered services in information agencies. Catalog Description The course provides an introduction to the fundamentals of database design, including analyzing information requirements, developing an entity-relationship model, organizing data into a relational database, and querying the database. The focus is on database applications and assessing designs to determine efficient database access for various clients. (Approved 3/9/2015) Course Learning Outcomes By the end of the course, students will be able to: Program Outcomes Professional Values ALA Core Competence(s) 1 Describe the principles of relational database design and current trends in database technologies. 3, 4 3A, 3C 2 Conduct an analysis of information requirements for the purpose of designing a relational database. 3 3B 3 Apply the analysis of information requirements and the principles of relational database design to create a relational database that will meet specific information requirements. 3, 4 1 3B, 4A 4 Implement, and explain the purpose of, relational database design, including developing an entity-relationship model, creating tables and fields, and establishing keys and relationships between data sets. 3, 4 1, 3 3B, 4A, 4D 5 Evaluate database design and performance. 3, 4 4D, 8C Approved 11/13/12 Course Overview A key overall outcome of this class is that you each will be creating a functional relational database of your choosing (within limits and parameters given). The hope is that your custom created database will prove useful well beyond the duration of this class. Required Readings There are no required textbooks for this course. Instead we will be using online resources and materials in each module through a page called “required reading.” All materials will either be open access (free and publically available) or available via the online course platform in PDF or a similar format. SOFTWARE REQUIREMENTS: We will be using either Apache OpenOffice Base 2.0, LibreOffice Base, or Microsoft Access 2013 (you choose from the three). The first two are open source (free and publically available) and MS Access is something at least some of you may have with your Office Suite. OpenOffice Base Tutorials: http://inpics.net/tutorials/base2/base.html (LibreOffice is virtually the same) Microsoft Access Tutorials: https://support.office.com/en-us/article/Access-2013-videos-and-tutorials-a4bd10ea-d5f4-40c5-8b37-d254561f8bce Learning Activities As noted in the course overview, a key overall outcome of this class is that you each will be creating a functional relational database of your choosing (within limits and parameters given). The hope is that your custom created database will prove useful well beyond the duration of this class. Each week will have instructor insights which are optional but may prove useful in discussions and assignments. In some cases, there will also be short videos explaining concepts or assignment descriptions/walk-throughs as applicable. You will be completing a database in steps: Assessing overall database needs, assessing situation specific needs, database design, database development, database implementation, and post-assessment. Assignments Provide a summary of the assignments and their point values (with more detailed descriptions to be posted in Canvas). Assignment Course Outcome(s) Met Due Date Points Biography 5/27 25 Principles in database design 1 6/3 40 Trends in database technologies 1 6/10 40 General database analysis 2 6/17 125 Database description diagram 2 6/24 75 Analysis of database design 3 7/1 100 Database creation 4 7/15 225 Database 4 7/22 50 documentation Database instruction 4 7/29 70 Database evaluation 5 8/5 50 Database final report 5 8/10 200 Tentative Course Outline Session Topics Readings Activities and Due Dates Week 1: 5/21-5/27 Introductions 5/28 - Mini biography posted on the "Introductions" discussion forum Week 2: 5/28-6/3 Principles of relational database design Week 2 required reading online 6/4 Describe the principles of relational database design via discussion board Week 3: 6/4-6/10 Current trends in database technologies Week 3 required reading online 6/11 Research and discuss current trends in database technologies via discussion board Week 4: 6/11-6/17 Analysis of information requirements and desires for various entities Week 4 required reading online 6/18 Conduct an analysis of information requirements and recommendations while considering maintainability Week 5: 6/18-6/24 Key components of relational databases Week 5 required reading online 6/25 Describe entity-relationship model, creating tables and fields, and establishing keys and relationships between data sets Week 6: Information requirements when designing Week 6 required reading online 7/2 Conduct an analysis of information requirements for the purpose of designing Session Topics Readings Activities and Due Dates 6/25-7/1 relational databases a relational database Week 7: 7/2-7/8 Relational database creation Week required reading and tutorials online 7/16 Create a relational database that will meet specific information requirements offered in assignment detail Week 8: 7/9-7/15 Relational database creation continued None for this week; continue on database project Week 9: 7/16-7/22 Implementation and explanation of relational database design, specifications, and use Week 9 required reading online 7/23 Document the purpose of your relational database design, including entity-relationship model, tables, fields, keys and relationships between data sets Week 10: 7/23-7/29 Implementation and explanation of relational database design, specifications, and use continued Week 10 required reading online 7/30 Write instructions for database use and modification Week 11: 7/30-8/5 Evaluation of database design and performance. Week 11 required reading online 8/6 Evaluate database design and performance via peer review. Week 12: 8/6-8/10 Documentation, maintenance, ensuring use, best practices, and lessons Week 12 required reading online 8/11 Finalize database, documentation, lessons learned, and best practices Session Topics Readings Activities and Due Dates learned. Late Work Late work will be docked 5% per day seven-days-a-week for every day it is late until 30% total is hit (14 days). No matter when an assignment is turned in the student can earn up to 30% of the original grade. SLIM Technology Requirements SLIM has specific hardware, software and network requirements for all students that are specified on the SLIM website at http://tinyurl.com/SLIMtechnology. Computer technology is integrated throughout the curriculum, including the use of Canvas, ESU’s learning management system, and use of video-conferencing software. All students must have devices, high-speed Internet access, and current software for home use that makes possible full participation in extensive course assignments. The ESU financial aid office provides details about possible funding for purchase of computer equipment at https://www.emporia.edu/finaid/. Grading Criteria REQUIRED: These criteria should identify all the elements required and the degree of achievement necessary for each assignment. Due date Week Assignment Point value 27-May 1 Biography: Mini biography posted on the "Introductions" discussion forum 25 3-Jun 2 Principles in database design: Describe the principles of relational database design via discussion board and respond to a minimum of two other student's posts 40 10-Jun 3 Trends in database technologies: Research and discuss current trends in database technologies via discussion board and respond to a minimum of two other student's posts 40 17-Jun 4 General database analysis: Conduct an analysis of information requirements and recommendations while considering maintainability for various types of databases 125 24-Jun 5 Database description diagram: Describe entity-relationship models, tables, fields, and establishing keys and relationships between data sets via a visual diagram with descriptive text 75 1-Jul 6 Analysis of database design: Conduct an analysis of information requirements for the purpose of designing a relational database that will meet specific information requirements offered in assignment detail 100 15-Jul 7&8 Database creation: Create a relational database that will meet specific information requirements offered in assignment detail 225 22-Jul 9 Database documentation: Document the purpose of your relational database design, including entity-relationship model, tables, fields, keys and relationships between data sets in a written report 50 29-Jul 10 Database instructions: Write instructions for database use and modification using visual as well as written descriptions 70 5-Aug 11 Database evaluation: Evaluate database design and performance via review online and share thoughts via discussion board 50 10-Aug 12 Database final report: Finalize database, documentation, lessons learned, and best practices and submit a final report 200 Total points: 1000 Point scale below is percentage based, so simply divide your total points by 10 to get the percentage SLIM Grading Scale 96 -100 A 77 - 79 C+ 90 - 95 A- 74 - 76 C 87 - 89 B+ 70 - 73 D 84 - 86 B 0 - 69 F 80 - 83 B- SLIM Grade Policy All graduate courses required in the university-approved curricula of SLIM’s master’s programs, certificate programs, academic concentrations, and doctoral program--or their approved substitutions--must be passed with a final grade of B- or better to receive academic credit. If a student does not receive a final grade of B- or better in any or all of SLIM’s required courses, then the student will be given an academic warning and the student will be notified by SLIM administration that he or she must retake that course or those courses. In addition, if a student has a semester GPA of less than 3.0 he or she will be given an academic warning. When a student has been given an academic warning, an administrative hold will be placed on the student’s record to block future enrollment, and the student will be removed from any registered courses for the upcoming semester. Before the student can be enrolled, he or she is required to meet with the student’s academic advisor with the goal of developing an academic improvement plan. The administrative hold can only be released by the student’s academic advisor or by the SLIM dean upon satisfactory completion of the academic improvement plan. If the student fails to complete the terms set forth in the academic improvement plan, then the student’s academic progress will be reviewed by the student’s academic advisor and the SLIM dean, and a decision will be made regarding whether the student should be academically dismissed from SLIM’s graduate program. This SLIM Grade Policy applies to all students in SLIM’s master’s degree programs, certificate programs, the doctoral program, and academic concentrations. It also applies to all those who have passed into MLS or doctoral degree candidacy. (Updated 8/26/2014) SLIM Attendance Policy In cases of emergency, go to http://www.emporia.edu/slim/studentresources/policies.html for more information. SLIM Incomplete Grade Policy SLIM’s Incomplete Grade Policy upholds the Emporia State University Incomplete Grade Policy (for full policy, go to: http://www.emporia.edu/regist/trnscpt/grades.html). SLIM’s Incomplete Grade Policy further stipulates that an incomplete request will not be considered approved without an Incomplete Request Form having been submitted by the instructor and approved by the SLIM dean within two weeks after the issuance of the incomplete. If the incomplete grade is being requested for reasons of health, then documentation must be submitted to the SLIM dean’s office before the final grade change is made. If a SLIM student’s request for a single incomplete grade is approved by the instructor and dean, then the student will be limited to enrolling in six credit hours in the immediately succeeding semester. If a SLIM student requests more than one incomplete grade to be issued at the conclusion of a semester, then an administrative hold will be placed on the student’s record to block future enrollment until all incomplete grades are finished and the final grade changes have been submitted by the instructor(s), signed by the SLIM dean, and accepted by the ESU Registrar’s Office. SLIM Netiquette Policy This course will involve the exchange of ideas, questions, and comments in an online and/or blended learning community. In all of your class communications, please use the same tact and respect that you would if you were talking to classmates face to face. Remember that in online communication the visual and auditory aspects are missing, so be especially careful to ensure your emails and discussion postings accurately convey your meaning and are not open to misconstruction. Humor is especially difficult to convey in this environment, so take extra care with your writing. Please maintain your professionalism and courtesy at all times when interacting with others in the class. Course Evaluations Course evaluation is an important part of the process of teaching and learning. SLIM uses the IDEA evaluation instrument to gather feedback from students on the effectiveness of each and every course. The resulting data is reviewed by the instructors and the Dean, who work together to improve teaching and learning across the whole of SLIM. Evaluation surveys are made available to students toward the end of each semester, and periodic email reminders are sent to encourage participation. The surveys are administered by The IDEA Center through the Campus Labs platform, and student responses are anonymous (unless students share any identifying information in their comments). Nobody in SLIM has access to individual student surveys at any time, and aggregated data is only made available to instructors at least one week after final grades have been submitted. (Updated 4/16/2015) Faculty-initiated Student Withdrawal Procedure SLIM instructors follow the university's policy of faculty-initiated student withdrawal which states: If a student's absences from class, disruptive behavior, lack of prerequisites, or academic dishonesty become detrimental to the student's progress or that of other students in the class, the faculty member may advise the student to withdraw from the class. Withdrawal may also be advised if the student is inappropriately enrolled in the class. If the faculty member chooses to withdraw the student, he/she shall attempt to notify the student in writing that a faculty-initiated withdrawal is in progress. This notification will be copied to the department chair and Academic Affairs office to serve as the request for withdrawal. If efforts to contact the student have been unsuccessful, or unacknowledged, the faculty member shall then seek the aid of the Academic Affairs office in contacting the student. The Academic Affairs office shall provide the student with information about the existing appeals procedures. Upon receiving a written request for withdrawal from the faculty member, the Academic Affairs office may initiate a student withdrawal from the class. None of the above implies or states that faculty members are required to initiate any student withdrawal. [Policy and Procedures Manual 4E.13] Academic Dishonesty At Emporia State University, academic dishonesty is a basis for disciplinary action. Academic dishonesty includes but is not limited to activities such as cheating and plagiarism (presenting as one's own the intellectual or creative accomplishments of another without giving credit to the source or sources.) The faculty member in whose course or under whose tutelage an act of academic dishonesty occurs has the option of failing the student for the academic hours in question and may refer the case to other academic personnel for further action. Emporia State University may impose penalties for academic dishonesty up to and including expulsion from the university. Disabilities Policy Emporia State University will make reasonable accommodations for persons with documented disabilities. Students need to contact the Director of Disability Services and the professor as early in the semester as possible to ensure that classroom and academic accommodations are implemented in a timely fashion. All communication between students, the Office of Disability Services, and the professor will be strictly confidential. Contact information for the Office of Disability Services: Office of Disability Services 106 Plumb Hall Emporia State University 1 Kellogg Circle / Box 4023 Emporia, KS 66801 Phone: 620/341-6637 TTY: 620/341-6646 Email: disabser@emporia.edu