ITFN 1201 - Foundations of Database Design

http://kahuna.clayton.edu/byron/itfn1201

(Fall 2018: CRN 80403)

Printable Course Syllabus

Byron Jeff

E-mail: byronjeff@clayton.edu
Phone: 678-466-4411
Office: UC 324
Office hours:
    MW 2:00 - 3:15 PM and 6:15 - 7:00 PM , TR 11:15 AM - 12:30 PM, or open door

Note: the syllabus and schedule are subject to change.

Course Description (3-0-3)

Foundations of Database Design: This foundational course presents terminology, basic concepts, and applications of database processing including file organization and data structures. The course emphasizes database design using various modeling techniques; database implementation using the relational model, normalization, and SQL. Students will design, create and process a database to demonstrate competency in the course content.

Prerequisite(s): [WBIT 1100 (C) or ITFN 1101 (C)], MATH 1101 (C), ENGL 1101 (C), CRIT 1101 (C).

Course Learning Objectives:

The BIT curriculum is built on nine core program outcomes. Successful completion of this course will contribute to the following subset of these nine outcomes. Graduates will demonstrate a Developing level of mastery for the following outcomes:

1) Use and apply current IT discipline-related concepts and practices.

2) Identify and analyze problems or opportunities in the IT realm and define requirements for addressing them when an IT Solution is appropriate.

3) Design and develop effective, IT-based solutions and integrate them into the user environment.

7) Collaborate in teams to accomplish common goals.

BIT Program Outcomes:

The BIT curriculum is built on nine core program outcomes. Successful completion of this course will contribute to the following subset of these nine outcomes. Graduates will demonstrate a Developing level of mastery for the following outcomes:

1) Use and apply current IT discipline-related concepts and practices.

2) Identify and analyze problems or opportunities in the IT realm and define requirements for addressing them when an IT Solution is appropriate.

3) Design and develop effective, IT-based solutions and integrate them into the user environment.

7) Collaborate in teams to accomplish common goals.

Prerequisites

The University Description for the course details the prerequisite information for the course. Below is a summary.
ITFN 1101 with a minimum US grade of C
MATH 1101 (or higher) with a minimum US grade of C
ENGL 1101 with a minimum US grade of C

Meeting Times

Day of weekTimesCRNLocation
MW 3:35-4:50 PM 80403UC 331

Class Email:

itfn1201-1fall18@groups.clayton.edu (80403 MW afternoon class)

Textbook

Database Concepts, 8

David Kroenke, David Auer, Pearson/Prentice Hall 2017

Companion Website: Note that an online version of the book is already loaded into D2L. You have the opportunity to opt out of the use of that book during the first week of class. Options for a printed copy are also available. Check with the bookstore for further details.

Assessment

You will have numerous opportunities to practice and demonstrate mastery of the materials covered in this course. It is up to you to keep current on all readings and assignments (including in-class announcements). *If you fall behind, you will most assuredly fail this course!*

Grading will be based upon the following scale:

GradeRange
A >= 90%
B 80% - 89%
C 70% - 79%
D 60% - 69%
F < 60%

Assignment weights are as follows:

AssignmentPortion of Grade
Final 30%
Three Monthly Tests 39% (13% for each of 3 tests given approximately once a month)
Review Quizzes 16%
Project Portfolio (see details below) 15%

The final for this class is comprehensive. In addition the grade on the final can be used to redeem one *(and only one)* monthly test grade. So if your grade on the final is higher than your lowest monthly test grade, then that monthly test grade will be replaced with the grade from the final. This policy is designed to give a student the chance to improve one poor monthly test showing.

Partial credit may be given.

Course Topics

The list of course topics below will be presented in the order listed below. The listed exams are inserted following the likely coverage of the material that the exam will cover. Be aware that in class adjustments of both the material and the exam coverage may be made. Any in class adjustments superceeds the outline listed here. Exact test dates will be announced a minimum of one week before the actual exam.

Project Portfolio

Please read carefully!

A comprehensive student generated project portfolio must be submitted by each student on the specified date near the end of the semester. The portfolio consists of a number of required project elements coupled with additional project elements selected by the student. The portfolio will serve as the single grading instrument for the project portion of the course. The portfolio will be graded on the following elements:

Each element of the project portfolio will have a milestone/feedback deadline during the semester. Project elements that are substantively complete and correct (i.e. not perfect but mostly done) and turned in by the milestone/feedback deadline will receive feedback that the student may use to improve their project for the portfolio. However, any project element that is not submitted for feedback by the given deadline, or is not substantively complete/correct at that deadline will not receive credit for meeting the milestone/feedback deadline nor feedback incorporation element for that project element.

Active Feedback System

Soliciting and incorporating feedback is an essential element for success in the learning and development of technological systems. In order to encourage active student participation in the feedback process, this course implements an active feedback points system. The system is governed by the following rules:

Attendance Policy

Your active participation in class is expected. Class attendance is expected because it's much easier to learn if you're coming to class and asking questions in lecture about things that confuse you.

Late Work Policy

Late work delays both the learning process and the feedback process. Project elements needs to be turned in a timely fashion. D2L assignment submissions for project elements will be closed 24 hours after the feedback deadline.

The instructor may waive late penalties if techical problems to homework submission occurs. In the event of technical difficulties:

Words of Wisdom (TAKE THIS PART SERIOUSLY!)

Academic Misconduct

Any student is found obtaining or granting inappropriate help in this course on any in-class graded assignment (test, quiz, exam) will subject to acadmic discipline. The offense will go on permanent record with the university. If this is not the student's first academic misconduct offense at CSU, he will be recommended for expulsion from the university. This is in full accord with CSU's policy, and we encourage you to read and review the university's policy in your student handbook.

So it is permissible to do group work or work with a tutor or other instructors on outside work in this course that is to be turned in for a grade. However, remember that the objective is to gain understanding of the problem solving process and apply that understanding. Note that the majority of the course grade is done via an in-class assessment, which each student must do on their own work without assistance.

Academic discipline can range from a zero for the in-class assessment in question to expulusion from the University depending on the circumstances.

All alleged instances of acadmic misconduct will be referred to the Office of Student Affairs.

CAS / Operation Study

Come to the CAS @ CSU

Throughout the fall, spring, and summer semesters, the Center for Academic Success (CAS) provides personalized one-on-one peer and professional staff tutoring in over 100 core subjects. We are located in Edgewater Hall Suite 276. The CAS also offers moderated study groups, informal study sessions, a comfortable study environment, a student study lounge, and it's all free! Come see us if you need help, come BE a tutor if you don't. Don't wait until it's too late. At the CAS, your academic success is right around the corner! For more information you can e-mail us at thecas@clayton.edu

Hardship Withdrawal

Students who experience an unexpected event or circumstance beyond their control that directly interferes with their ability to continue to make satisfactory progress in classes, such as serious illnesses or unexpected major life events, may petition the Dean of their major for a hardship withdrawal from all classes. In order to be considered for a hardship withdrawal, the student must have been passing all courses at the time that the emergency or other hardship arose and notify his or her instructors or other University officials about the hardship situation as soon as possible after it arose (per University and BOR policy, ―passing is defined as a grade of ―D or above). Hardship requests that are not filed in a timely manner are subject to denial even if the student was passing and the hardship was legitimate. Students who attend any classes through the end of a term and complete all course requirements (i.e. final project or exam) are not eligible for hardship withdrawal. If you have taken a final exam in any of your courses, you may not request a hardship withdrawal. For more information go to: http://www.clayton.edu/registrar/Withdrawal

ITP Choice Information

Beginning Fall Semester 2001, all students at CCSU are required to state that they have on-demand access to a notebook computer that meets the recommended hardware/software specifications that have been established by Clayton State faculty. Academic penalties may be incurred for not meeting this requirement. See http://www.clayton.edu/hub/itpchoice/notebookcomputerpolicy for more information.

Computer Skill Prerequisites

Students in this course must have the following prerequisite skills:

Disruption of the Learning Environment

Behavior which disrupts the teaching-learning process during class activities will not be tolerated. While a variety of behaviors can be disruptive in a classroom setting, more serious examples include belligerent, abusive, profane, and/or threatening behavior toward the instructor and/or other students in the class. A student who fails to respond to reasonable faculty direction regarding classroom behavior and/or behavior while participating in classroom activities may be dismissed from the class. A student who is dismissed from the class is entitled to due process and will be afforded such rights as soon as possible following dismissal, in collaboration with the Office of Community Standards. If found in violation, a student may be administratively withdrawn and may receive a grade of WF. More detailed examples of disruptive behavior are provided in the Code of Conduct and Disciplinary Procedures sections of the Clayton State University Academic Catalog and Student Handbook.

Weapons on Campus

Clayton State University is committed to providing a safe environment for our students, faculty, staff, and visitors. Information on laws and policies regulating weapons on campus are available at http://www.clayton.edu/public-safety/Safety-Security/Weapons

Disability Services

Students with disabilities who require reasonable accommodations need to register with Disability Services (DS) in order to obtain their accommodations. You can contact them at 678-466-5445 or E-mail at disabilityservices@clayton.edu .