Threesuns

Email

Contact

All Semesters

Semesters

All Courses

Courses

Database Design

CSYS2643

3 credits

Generic Course Syllabus

Syllabus

Details

Course number: CSYS2643
Call Number:

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.

Prerequisites

CSYS 1203 - Computer Concepts and Applications

Next Course

See Instructor

Resources

Textbooks

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

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

Materials

TBA

Objectives

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

  1. Students should be able to generate mission objectives and subjects for a data storage need
  2. Students should be able to develop correct lists of tables and fields based on objectives and subjects
  3. Students should be able to determine candidate and primary keys
  4. Students should be able to distinguish relationships that exist between entities
  5. Students should be able to generate business rules and needed views for a database
  6. Students should be able to evaluate data integrity
  7. Students should be able to evaluate various aspects of database security
  8. Students should be able to generate a database

Teaching Methods

Policy

This course will consist of lecture presentations and class discussion. Class participation is strongly encouraged. Hands-on computer laboratory exercises will be assigned to support and complement the material discussed in the classroom.

Attendance Policy

Policy

Attendance will be taken at the beginning of every class. Anyone who is not present when attendance is taken will be marked as being absent. Attendance is required. While no points are deducted for absences, you will miss the points for any quiz given or assignment you fail to turn in on a day you are absent. If you must be absent, check with me about any assignment that may be due on the day you return. If you miss a day when an assignment is to be turned in, it is your responsibility to turn it in ahead of time.

Grading System and Evaluation Technique

Policy

There will be 8 / 100 point programs assigned during the semester that will be used to determine your final grade. Additional tests and quizzes may be given at the instructor's discretion.

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

Make-up exams will be given ONLY when arrangements have been made PRIOR to the class period following the missed exam. No make-up quizzes are given. Assignments and programs will not be accepted after the due date.

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:

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.

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).

Syllabus Changes

Policy

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

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.

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.

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.

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.