Database Development and Management

This syllabus covers all sections of LIS 470/570

This version is Draft until the course begins.

Office: 520-621-3565
By Appointment. For advising schedule and appointments, see http://tinyurl.com/p4h3jzr
520-626-4631

Academic Year: 

Semester: 

Course ID and Name: 

Section Number: 

Course Syllabus

Course Prerequisites: 

There are no course prerequisites for this class. Students are expected to enter the course with basic technical proficiency on the computer system of their choice, either Windows or Mac. Students should be reasonably proficient at finding resources on the Web and performing routine tasks using word processors and spreadsheets. Students should feel comfortable with their current operating system and know how to create and organize files and folders, install and configure peripherals such as printers and other hardware devices, and do basic troubleshooting when problems occur.

Course Description: 

This course is designed to help students develop a broad understanding of modern database management systems. It covers theory, methods and techniques widely used today to design and develop a relational database system as well as ad hoc data analysis using database tools and methods. The course emphasizes the applications of fundamental database principles in a stand-alone database environment using Microsoft Access on the Windows platform. Remote database applications using MySQL on the Linux platform will also be discussed. The course takes a problem-based hands-on learning approach to prepare students for designing and using real-world database systems in a team or individual working environment.

Locations and Times

This is an asynchronous virtual online course managed through the Desire to Learn (D2L) Course Management System. Students are not required to meet as a class at any one particular time, but students must log in regularly several times each week to participate in online discussion, check assignments and notices and complete quizzes. In addition, students may be responsible for meeting regularly in small assigned groups to complete assigned group work and discussion.

Instructor Information

Bruce Fulton, MLS, PhD
School of Information
1515 E First Street
Faculty page: http://si.arizona.edu/users/bruce-fulton
Email: bfulton@email.arizona.edu
Direct Office Phone: 520-626-4631
Office hours for virtual courses are by appointment, and are available via Skype, telephone, face to face, or other means as mutually convenient.

Topical Schedule

The tentative schedule of topics and readings, not including quizzes and weekly assignments is as follows:
 

 

Friedreichsen

Pratt & Last

Other Readings

Other Topics / exercises

Project Deadlines

Week 1

 

Chap. 1: 1-17, 25-26

As Assigned

 

 

Week 2

Unit A: Getting Started

 

As Assigned

 

 

Week 3

Unit B: Queries

 

As Assigned

Data: Types, Sources and Internal Storage

 

Week 4

Unit C: Forms

 

As Assigned

External Data: Data clean-up and prep

Proposal

Week 5

Unit D: Reports

 

As Assigned

External Data: Import and Export

 

Week 6

Unit E: Modi-fying DB Structure

Chap. 2: Relational Algebra*

As Assigned

ODBC

 

Week 7

Unit F: Improving Queries

 

As Assigned

ERD and other forms of database documentation

Conceptual Design

Week 8

Unit G: Enhancing Forms*

Chap. 5: Normalization

As Assigned

 

 

Week 9

Unit H: Analyzing Data with Reports*

Chap. 6: Design Method

As Assigned

 

 

Week 10

 

Chap. 7: DBMS Functions

As Assigned

 

Logical Design

Week 11

 

Chap. 3: SQL

As Assigned

Linux/Mysql

Physical Design

Week 12

 

Chap. 4: Advanced Topics*

As Assigned

Linux/Mysql

 

Week 13

 

Chap. 8: DB Administration

As Assigned

 

Data

Week 14

 

Advanced Topics

As Assigned

Data Management Plans

 

Week 15

Project Wrap

 

 

 

Project Diary and Report (grad, undergrad), Peer Eval (grad)

* Optional but recommended

This outline is subject to change as the course progresses.  A current copy including dates applicable to the semester and a full schedule of assignment, project, discussion and quiz due dates will be maintained in D2L Content once the course begins.

 

Course Objective: 

On completion of this course, students will:

  • Understand common types of data including text, different kinds of numbers and binary objects;
  • Understand how data are stored and exchanged among different applications and imported/exported into/out of applications and database systems;
  • Understand the basic concepts, terminology, methods and issues related to database systems, database design, and database administration;
  • Be familiar and competent with Microsoft Access, currently the most popular database management software in the office environment;
  • Be familiar with MySQL, currently the most popular open-source database management system in small to middle-size enterprise business and research environments;
  • Use Access QBE and SQL to write database queries and generate database reports;
  • Perform database design analysis to address practical problems concerning the management of information resources.

This course serves students in several certificate and degree programs: the School of Information Master of Arts Degree in Library and Information Science, Master of Science Degree in Information, multiple graduate certificate programs, elective requirements in undergraduate degree programs, and students pursuing elective credit outside the School of information.

For students pursuing the Master's degree in Library and Information Science, the course especially addresses the following degree competencies:

  • A3) Students will demonstrate understanding of the use of information and communication technologies including social aspects of information in providing information resources and services in libraries and other information environments.
  • B4) Students will demonstrate knowledge of the principles of organization and representation of knowledge and their application to library and information collections and services in their areas of career interest.

Intended course outcomes may vary depending on the degree program the student is pursuing. Students wishing assistance in aligning degree requirements to learning outcomes and course objectives may wish to consult the instructor individually prior to registration to assure that the course meets educational objectives.

 

Required Course Materials: 

Required Texts:

Pratt and Last (2015). Concepts of Database Management, Eighth Edition. Cengage Learning. ISBN 978-1-285-42710-2 http://www.cengagebrain.com/shop/isbn/9781285427102 or available from the ASUA bookstore or other vendors.

Friedrichsen (2014). Microsoft Access 2013 – Introductory. Cengage Learning. ISBN 978-1-285-09328-4 See http://www.cengagebrain.com/shop/isbn/9781285093284 or available from the ASUA bookstore or other vendors.

Earlier editions are not acceptable; the publishers change examples and other content every edition. These texts may be available for rent. Electronic editions may be available; due to complex tables and graphs, consider them only on larger screen devices such as a PC.

Required Software:

Students must have access to Microsoft Office Professional 2013 on the PC platform to include the PC version of Excel 2013 and Access 2013. A free license for Microsoft Office Professional for students who have a PC is available from http://uabookstore.arizona.edu/technology/campuslicensing/default.asp.

Office Professional including Access 2013 for the PC is not available on the Apple Mac platform. Students whose personal computing platform is a Mac have two options for completing the course hands-on assignments:

1. Most computer labs on campus have PCs with the needed software as do many public libraries, or libraries in other communities for students completing the course via distance learning. Work may be stored and accessed on a flash drive.

2. Students can purchase Parallels or VMWare Fusion software and a full installation copy of Windows 8.1 (or Windows 10 if available), which will allow them to install Windows on the Macintosh and then install the student-licensed copy of Office Professional listed above on their personal Mac.

Required or Special Materials

No other materials besides the required texts and software are required. Other readings and software will be freely available on the web, available for download through the university library databases or will be provided in the Content folder area of D2L.

Technical Support

The University of Arizona provides 24/7 technology help desk assistance. Services include general assistance with applications including installation and operation of most computer programs, troubleshooting, virus removal, access to University computing resources (including D2L) and so on. Visit http://the247.arizona.edu or call (520) 626-TECH (8324).

Course Requirements: 

Course Format and Teaching Methods

This is a virtual course managed in the D2L Learning Management System. Online components managed within D2L include large and small group discussion, quizzes, course schedules and assignments, links to video and text lectures, and other online resources. Students may be assigned to smaller groups for projects and/or discussion. The course will include extensive use of hands-on assignments using database software students have or will install or access at a library or other location.

Students should be familiar with D2L before the course starts. Access D2L and the course at https://d2l.arizona.edu/. For help, login at that site with your NetID and password and visit http://help.d2l.arizona.edu/student/student-home

A brief video walkthrough of D2L is available at https://www.youtube.com/watch?v=oTVOfrLWEM8

Course Grading: 

The University policy regarding grades and grading systems is available at http://catalog.arizona.edu/2014-15/policies/grade.htm

Grade Distribution for this Course:                                 

A: 900 – 1,000 pts
B: 800 – 899 pts
C: 700 – 799 pts
D: 600 – 699 pts
E: < 600 pts

Graduate and undergraduate point schedules are as follows:

Graduate Grading Schedule

 

pts

Weekly Assignments, 15 @ 20 pts. ea.

 

300

Group Database Project

 

350

  proposal

50

 

  conceptual design

50

 

  logical design

50

 

  physical design

50

 

  data

50

 

  project diary and report

50

 

  peer review

50

 

Quizzes, 10 @ 20 pts. ea.

 

200

Class Discussion Assignments, 15 @ 10 pts. Ea.

 

150

               

 

Undergraduate Grading Schedule

 

pts

Weekly Assignments, 15 @ 20 pts. ea.

 

300

Individual Database Project

 

350

  conceptual design

70

 

  logical design

70

 

  physical design

70

 

  data

70

 

  project diary and report

70

 

Quizzes, 10 @ 20 pts. ea.

 

200

Class Discussion Assignments, 15 @ 10 pts. Ea.

 

150

Module Plans

Each week, a module plan will become available in D2L Content outlining the week's topics, readings, links to written or video lectures, assignments, discussion questions, quizzes and other work to be completed.

Weekly Assignments.

There are 15 sets of weekly hands-on and written assignments based on the readings and lectures. The module plan will specify which are to be submitted to the D2L dropbox. Weekly assignments are graded in the aggregate at 20 points per week.

Database Project.

There is a semester long database project, completed in phases. For undergraduates, the project is individual and assigned. For graduate students, the project is a group project and requires a proposal and peer evaluation. More details will be provided once the course begins.

Quizzes.

There are 10 quizzes on terminology and concepts spread throughout the semester, graded on the highest of three timely attempts.

Class Discussion Assignments.

There are weekly discussion questions requiring your attention in D2L. For full credit, each student must make at least one timely substantive “top post” (primary or first reply) to a discussion question and at least two timely substantive replies to other students’ posts. A substantive top post means a well-constructed, thoughtful independent comment of one full paragraph or more, typically at least 125 words. A substantive reply is a well-constructed thoughtful independent but shorter comment to the substantive comment of another discussant, typically at least 40 words. [Baker, D. (2011). Designing and orchestrating online discussions. Merlot Journal of Online Learning and Teaching 7(3), pp. 401-411]

Late Work Policy

Due dates accompany all work including assignments, projects, quizzes and discussion. Consult the Schedule posted in the D2L Content > Course Documents folder for specifics. Late work will be penalized 10% for up to five days past due and 20% more than five days past the deadline. Work is closed to submission after two weeks and will not be accepted for credit. In any event, the last day of class is the last day to submit any work for credit.

Course Policies: 

Policy on Incompletes and Withdrawals

Requests for incompletes (I) and withdrawal (W) must be made in accordance with university policies which are available at http://catalog.arizona.edu/2014-15/policies/grade.htm#I and http://catalog.arizona.edu/2014-15/policies/grade.htm#W respectively. Incompletes are not generally approved except under exceptional circumstances in advance consultation with the instructor. The grade of I may be awarded only at the end of a term, when all but a minor portion of the course work has been satisfactorily completed. The grade of I is not to be awarded in place of a failing grade or when the student is expected to repeat the course; in such a case, a grade other than I must be assigned. Students should make arrangements with the instructor to receive an incomplete grade before the end of the term. If the incomplete is not removed by the instructor within one year the “I” grade will revert to a failing grade.

Honors Credit

Students wishing to contract this course for Honors Credit should email me to set up an appointment to discuss the terms of the contact and to sign the Honors Course Contract Request Form.  The form is available at http://www.honors.arizona.edu/documents/students/ContractRequestFrom.pdf.

Attendance Policy

The UA’s policy concerning Class Attendance and Administrative Drops is available at: http://catalog.arizona.edu/2014-15/policies/classatten.htm

The UA policy regarding absences on and accommodation of religious holidays is available at http://deanofstudents.arizona.edu/policies-and-codes/accommodation-religious-observance-and-practice.

Absences pre-approved by the UA Dean of Students (or Dean designee) will be honored.  See:
http://uhap.web.arizona.edu/chapter_7#7.04.02

Attendance in an online course means logging in to the course regularly (several times per week) and reviewing/viewing all available and assigned resources such as lectures, readings and so on when available and assigned. This is tracked. Participating in course and attending lectures and other course events are vital to the learning process.  Students who fail to log in to the course and begin participation by the end of the first week of class may be administratively dropped. Thereafter, students who fail to log into the course regularly and complete discussion and assignments in a timely manner may be administratively dropped.  Students who fail to log in and participate due to illness or emergency are required to provide documentation from their healthcare provider or other relevant, professional third parties.  Failure to submit third-party documentation will result in unexcused absences.

Assignment/Testing Schedule/Due Dates

The course schedule and calendar of assignments, discussion, quizzes and exam due dates are posted in D2L Content in the folder Course Documents. Students are responsible for reading and meeting all due dates specified in those documents. Missed discussion, groupwork, assignments, quizzes and exams may not be made up per the Late Work Policy above.

Assignment Format

Each assignment is described in a separate document located in D2L Content in the folder Course Documents. The assignment particulars specify the required format for the assignment. Assignments that do not follow the required format may be penalized or refused.

Classroom and Community Behavior

The Arizona Board of Regents’ Student Code of Conduct, ABOR Policy 5-308, prohibits threats of physical harm to any member of the University community, including to one’s self.  See: http://policy.arizona.edu/threatening-behavior-students.

Netiquette is the etiquette of online interpersonal communication behavior including communication between individuals and among groups of individuals such as in small group and class online discussion. Online communication should remain courteous and respectful at all times.

All policies and codes of the University of Arizona apply to students in this course. See:  http://deanofstudents.arizona.edu/policies-codes for a list of policies.

Additionally, the School of Information has behavioral policies. In a class or in communicating with other students, faculty and staff it is acceptable to disagree with opinions expressed in the posts of your instructor or fellow students, but you are expected to demonstrate professionalism and respect at all times. Personal attacks, bullying, flames, or lack of respect will not be tolerated in email, discussion boards or in person. Repeated violations in the classroom or in the online community will result in the student being recommended for administrative drop. Repeated violations in the school community outside of the classroom or in the online community will be reviewed by the faculty and may result in a recommendation for expulsion from the school or other sanctions to correct the behavior. See http://sirls.arizona.edu/programs/graduatePolicies#Behavior%20Policy

Accessibility and Accommodations

It is the University’s goal that learning experiences be as accessible as possible.  If you anticipate or experience physical or academic barriers based on disability, please let me know immediately so that we can discuss options.  You are also welcome to contact Disability Resources (520-621-3268) to establish reasonable accommodations.  For additional information on Disability Resources and reasonable accommodations, please visit http://drc.arizona.edu/.

If you have reasonable accommodations, please plan to meet with me by appointment or during office hours to discuss accommodations and how my course requirements and activities may impact your ability to fully participate.

Student Code of Academic Integrity

Students are encouraged to share intellectual views and discuss freely the principles and applications of course materials. However, graded work/exercises must be the product of independent effort unless otherwise instructed. Students are expected to adhere to the UA Code of Academic Integrity as described in the UA General Catalog. See:  http://deanofstudents.arizona.edu/academic-integrity/students/academic-integrity.

The University Libraries have some excellent tips for avoiding plagiarism available at:  http://www.library.arizona.edu/help/tutorials/plagiarism/index.html.

Selling class notes and/or other course materials to other students or to a third party for resale is not permitted without the instructor’s express written consent.  Violations to this and other course rules are subject to the Code of Academic Integrity and may result in course sanctions.  Additionally, students who use D2L or UA email to sell or buy these copyrighted materials are subject to Code of Conduct Violations for misuse of student email addresses. This conduct may also constitute copyright infringement.

Additional Resources for Students

UA Non-discrimination and Anti-harassment policy: http://policy.arizona.edu/sites/default/files/Nondiscrimination.pdf

UA Academic policies and procedures are available at: http://catalog.arizona.edu/2014-15/policies/aaindex.html

Student Assistance and Advocacy information is available at: http://deanofstudents.arizona.edu/student-assistance/students/student-assistance

Confidentiality of Student Records

FERPA is the federal law that governs the rights of students and institutional responsibilities with respect to student records. For an explanation of these rights, please see http://www.registrar.arizona.edu/ferpa/default.htm

Subject to Change Statement

Information contained in the course syllabus, other than the grade and absence policy, may be subject to change with advance notice, as deemed appropriate by the instructor.

College of Social and Behavioral Sciences
 
 
iSchools