Threesuns

Email the Instructor

Contact

All Semesters

Semesters

All Courses

Courses

2015Summer

06.01.15 - 07.26.15

Database Design (Online)

CSYS2643

Online
12:00 AM - 12:00 AM

Syllabus

Details

Course number: CSYS2643
Call Number: 32983
Course Type: Online
Room Number: Online Course

Description

Course covers the design and creation of relational databases using the Structured Query Language including performing analysis of data needs, establishing table structures, defining and working with keys, defining field specifications, establishing and working with table relationships, defining business rules, creating views, and managing data integrity.

Instructor

Instructor: Noah Singer
Office Number: MCG34
Office Hours: See Website
Office Phone: 918-595-7060
Email Address: professorsinger@threesuns.org
Twitter: @professorsinger
Web Site: https://threesuns.org

Business and Information Technology

School

Dean: David Poth
Office Number: SE 4112
Phone Number: 918-595-7639

Prerequisites

CSYS 1203 - Computer Concepts and Applications

Next Course

None

Resources

Textbooks

Required text: Database Design for Mere Mortals 3rd Edition , by: Michael J. Hernandez, Addison-Wesley, ISBN: 0321884493

Optional text: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL , by: John Viescas and Michael J. Hernandez, Addison-Wesley Professional, ISBN: 0321992474

Materials

None

Objectives

Upon completion of this course, a student should be able to do the following:

  1. Students should be able to describe the current database design methodology
  2. Students should be able to write mission statement and objectives
  3. Students should be able to develop correct lists of tables and fields
  4. Students should be able to determine candidate and primary keys
  5. Students should be able to construct proper field specifications
  6. Students should be able to distinguish relationships that exist between entities
  7. Students should be able to generate business rules and needed views for a database
  8. Students should be able to evaluate data integrity
  9. Students should be able to evaluate various aspects of database security
  10. Students should be able to generate a database using SQL

Teaching Methods

Policy

In each module of this course a project will be presented that will need to be completed, each project will mirror the steps a similar project would require in the workplace. Materials from the course textbook and other online materials as well other content will be available that will allow the student to learn the skills that are needed to be able to compete the projects.

In addition to the class projects there will also be learning checkpoint assignments to complete as the class progresses to supplement the skills practiced in the projects.

Your instructor will be available for questions via email at the address given at the top of the syllabus. Any questions you have regarding the course, projects, assignments, or questions about materials should be addressed in this way.

Grading System and Evaluation Techniques

Policy

There will be 8 / 100 point projects assigned during the semester as well as additional checkpoint exercises worth 10 points each, both together that will be used to determine your final grade.

Your grade will be calculated on a point accumulation basis. If you earn 90% of the possible points, you will get an A. Earning 80% gets you a B, 70% is a C, 60% is a D, and below 60% is an F.

Class attendance and participation may be used to determine borderline grades.

Late Assignments and Makeup Exam Policy

Policy

Due dates are posted for all exercises and projects and both must be turned in on or before midnight, central standard time, of the posted date. Late work is not accepted and will not be graded. It is important to your ability to successfully complete the course that all work be completed on schedule.

Extra Credit

Policy

Due to the class schedule with assignments scheduled for every week of the semester, time taken for extra credit would reduce the amount of time available for the normal semester work, therefor no extra credit work will be made available. Instead, spend your time making sure that all regular semester work is completed on time and to the highest standards.

Grading Schedule

Policy

I will do my best to ensure a quick turnaround time for grades on submitted materials. My goal is to always complete grading of materials on the next work data after the item's due date. While it is not always possible for me to accomplish this please know that it is always my goal.

Attendance Policy

Policy

In this online course students are expected to login to blackboard regularly to retrieve and submit their assignments. Other than this participation no other attendance is expected.

Academic Dishonesty

Policy

Students are not allowed to share code with other students, past or present, and are not allowed to use code that is found online. The only sources of code that are acceptable to be turn on as your own is code that you created and wrote yourself or code that was given to you by the instructor.

All parties (those who are copying and those who are copied from) who are found to have submitted work that is deemed by the instructor to be too similar to other students work or code that is available online will be seen as having been academically dishonest. TCC's Academic Dishonesty policy follows:

Academic dishonesty (cheating) is defined as the deception of others about one's own work or about the work of another. Academic dishonesty or misconduct is not condoned or tolerated at campuses within the Tulsa Community College system. Tulsa Community College adopts a policy delegating certain forms of authority for disciplinary action to the faculty. Such disciplinary actions delegated to the faculty include, but are not limited to, the dismissal of disrespectful or disorderly students from classes. In the case of academic dishonesty a faculty member may:

Syllabus Changes

Policy

Occasionally, changes to the syllabus may be necessary. Students will be notified of any changes to the syllabus in writing.

Disability Resources

Policy

It is the policy and practice of Tulsa Community College to create inclusive learning environments. Accommodations for qualifying students in compliance with the Americans with Disabilities Act (ADA) and Section 504 of the Rehabilitation Act are available. To request accommodations, contact the Education Access Center (EAC) at eac@tulsacc.edu or call (918) 595-7115 (Voice). Deaf and hard of hearing students may text (918) 809-1864.

Institutional Statement

Policy

Each student is responsible for being aware of the information contained in the TCC Catalog, TCC Student Handbook, Student Code of Conduct Policy Handbook, and semester information listed in the class schedule. All information may be viewed on the TCC website: www.tulsacc.edu

General Education Goals

Policy

General Education courses at TCC ensure that our graduates gain skills, knowledge, and abilities that comprise a common foundation for their higher education and a backdrop for their work and personal lives. TCC's General Education goals are: Critical Thinking, Effective Communication, Engaged Learning, and Technological Proficiency.

Communications

Policy

Email: All TCC students receive a designated 'MyTCC' email address (ex: jane.doe@tulsacc.edu). All communications to you about TCC and course assignments will be sent to your MyTCC email address; and you must use MyTCC email to receive email from the instructor regarding this course.

Inclement Weather: TCC rarely closes. If extreme weather conditions or emergency situations arise, TCC always gives cancellation notices to radio and television stations. This information is also posted on the TCC website (www.tulsacc.edu).

Classroom Etiquette

Policy

Open and mutually respectful communication of varied opinions, beliefs, and perspectives during classroom or online discussion encourages the free exchange of ideas that is essential to higher learning and to the ability to learn from each other. Use of any electronic device is at the discretion of the instructor.

Tobacco Free College

Policy

Tulsa Community College is a Tobacco Free college in accordance with the Governor's Executive Order 2012-01 and Title 63 of the Oklahoma Statutes, Section 1-1523 which prohibits smoking or the use of any tobacco products in all public places, in any indoor workplace, and all vehicles owned by the State of Oklahoma and all of its agencies and instrumentalities. This Order includes property leased, rented, or owned by TCC including, but not limited to, all grounds, buildings, facilities, and parking lots. Tulsa Community College's policy includes a tobacco free environment on all campus and off-campus locations conducting TCC credit or non-credit classes. The TCC Campus Police is responsible for ensuring compliance with the Tobacco-Free Environment Policy. Violations of the policy may be addressed through issuance of campus or state citations.

Withdrawal Policy

Policy

The deadline to withdraw from a course shall not exceed 3/4 the duration of any class. Contact the Counseling Office at any TCC campus to initiate withdrawal from a course ('W' grade) or to change from Credit to Audit. Check the TCC Academic Calendar for deadlines. Students who stop participating in the course and fail to withdraw may receive a course grade of 'F', which may have financial aid consequences for the student.

Students who miss two (2) consecutive labs in classes where lab projects are assigned or two (2) class meetings in classes without lab projects will have a grade of WN (withdraw for non-attendance) assigned.

As a courtesy to the class, if you carry a cell phone for professional or personal purposes please set it to vibrate or a soft ring. If you need to respond to calls or pages please leave the classroom to complete your business. Thank You.