CSYS2643
Database Design (Online)
Summer 2016 Syllabus
Course number: | CSYS2643 | Instructor: | Noah Singer |
Call Number: | 32983 | Office Number: | MCG34 |
Meeting Days: | Office Hours: | See Website | |
Meeting Times: | 12:00 AM - 12:00 AM | Office Phone: | 918-595-7060 |
Room Number: | Online Course | Email Address: | professorsinger@suchnull.com |
Twitter: | @professorsinger | Web Site: | https://suchnull.com |
School of Business and Information Technology
Dean: | David Poth |
Office Number: | SE 4112 |
Phone Number: | 918-595-7639 |
Course Prerequisites
CSYS 1203 - Computer Concepts and Applications
Next Course in Sequence
None
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
Other Materials
None
Course Objectives
Upon completion of this course, a student should be able to do the following:
- Students should be able to describe the current database design methodology
- Students should be able to write mission statement and objectives
- Students should be able to develop correct lists of tables and fields
- Students should be able to determine candidate and primary keys
- Students should be able to construct proper field specifications
- Students should be able to distinguish relationships that exist between entities
- Students should be able to generate business rules and needed views for a database
- Students should be able to evaluate data integrity
- Students should be able to evaluate various aspects of database security
- Students should be able to generate a database using SQL
Teaching Methods
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
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
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
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
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
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
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:
- Require the student to redo an assignment or test, or require the student to complete a substitute assignment or test
- Record a "zero" for the assignment or test in question Recommend to the student that the student withdraw from the class, or administratively withdraw the student from the class
- Record a grade of "F" for the student at the end of the semester. Faculty may request that disciplinary action be taken against a student at the administrative level by submitting such a request to the Dean of Student Services.
Syllabus Changes
Occasionally, changes to the syllabus may be necessary. Students will be notified of any changes to the syllabus in writing.
Disability Resources
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
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
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
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
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
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
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.