SQL Database Design and Programming

CTS 2433 Section 3452

SQL Database Design and Programming

August 15 – October 7, 2016

Section:3182

Class Time:Online 24/7

Class Location:Virtual Campus

Instructor

Dawn Ellis

Email:Use MyCourses messaging

Phone:727-614-7025

Office Hours:TBD

Office Location:CL ES213B

Instructor Web Page:

Students should anticipate a response to email within two school days. Grading is normally complete within five school days.

Course Information

Course Description

The objective of this course is to provide a comprehensive introduction to the SQL language. This course not only covers the syntax of SQL, but also shows how it can be used in Oracle Database 11g Express to create and maintain a database and retrieve information from it. It also provides an introduction to relational database concepts in addition to explaining concepts, the course uses a variety of assignments and exercises to reinforce the material in each chapter.

Course Content

The course is broken down into 8 weekly segments designed to provide the student with an overview of SQL database design and programming.

Basic knowledge assimilation occurs through reading the prescribed text and a number of important assignments. Knowledge is tested by quizzes designed to verify reading comprehension of the material presented in the assignments. A number of questions will relate directly to the specific reading assignments.

This course uses weekly sessions to enrich the course and promote interaction as a vital skill in improved idea creation, analysis, and decision making.

Grading Policy

90 – 100% / A
Assignments / 50% / 80 – 89.9% / B
Quizzes / 50% / 70 – 79.9% / C
Total / 100% / 60 – 69.9% / D
0 – 59.9% / F

Students must submit all of the assignments for each week by the deadline or they will not receive credit for the week. Exceptions of the deadlines and partial credit for late submissions are solely at the discretion of your instructor.

Each week the dropbox assignments will contain detailed format and submission instructions. Ensure that you review these instructions prior to submitting attached documents. Submissions are part of your grade and proof of attendance. Failure to post to the drop box weekly will count as an absence. If you do not post each week during the first two weeks of class you may be dropped for non-attendance.

In the “business world”, if you are late with your bid, you will not get the contract. Please note that computer problems, sickness, travel, and lack of planning do not constitute an excuse for not making a deadline. This may mean you will have to use computers on campus or somewhere other than your home, or submit the assignments to the instructor’s college e-mail account if MyCourses is down, should the need arise. Again, exceptions to this rule are at the sole discretion of your instructor, so be sure to view all of the contents and expectations under weeks 1-7 to confirm you can meet them for proper completion of this course.

If you have any questions about your scores, come talk to me no more than one week after the grade is posted. There will be no extra-credit work, outside papers, etc. If you miss the next highest grade by one point you will have my sympathy – but I will not change your grade!

Collaboration Rule

Students may work with other students on programming assignments, but submitted programs must be entirely the work of the submitting student. Please do not refer to course materials from previous terms.

In the MyCourses dropbox for each assignment, list:

• All collaborators, including SPC tutors.
• All written sources that you consulted, other than the text and course handouts from this term.
• If you had no collaborators and consulted no written sources, then write, “I worked alone.”

Homework without a collaboration statement will not be graded. Collaboration on quizzes and tests is not allowed. If you somehow violate the collaboration policy, your best option is to tell us before we notice. Mistakes you confess are forgivable.

Computer Requirements

Students must have regular access to a computer that is connected to the Internet. It is strongly recommended that students have a broadband (high-speed) internet connection such as DSL or a cable modem. When taking online quizzes and exams (or viewing online video), students should have an internet connection that is stable and will not drop their connection. You will need access to Microsoft Word, PowerPoint, and Excel for this class. All SPC campus libraries have these programs loaded on their computers.

Students without a stable high-speed internet connection should consider making arrangements to take online quizzes and exams at one of the St. Petersburg College libraries (or a similar facility) where a stable high-speed internet connection is available.

Required Textbook and Other Resources

Official curriculum must be purchased from the SPC bookstore on or before the first day of class. The required textbook isPratt & Last, A Guide to SQL, Ninth Edition, Cengage Learning, 2015, ISBN978-1-111-52727-3

Book Store:

Student Responsibilities and Assistance

Time Commitment

This is a 3-credit course conducted over 8 weeks. On average, students should expect to spend approximately 12 hours per week on course activities and assignments. Spending less time would be insufficient for success in this course. Some important information is provided in the Assignments and Due Dates section.

Attendance

Class participation is expected and encouraged. Participation is defined as reading and preparing for class, completing and submitting assignments on time, and taking part in all course activities. The Assignments and Due Dates section has assignments and final project due dates listed.

Attendance for this class will only count weeks where the student attends class and has completed work representing more than 50% of the available points for that specific week. See SPC policies on the web.

• If a student does not participate in class and complete the Week 1 assignments by the due date, he/she will be marked absent in MySPC for the first week and the student may be withdrawn, with a W, from the course.
• If a student does not participate in class and complete the Week 2 assignments by the due date, he/she will be marked absent in MySPC for the second week and the student may be withdrawn, with a W, from the course.
• If a student is absent for the first two weeks, i.e., misses the due dates for Week 1 and Week 2, he/she will be withdrawn, with a W, from the course in MySPC. In addition, student will be deleted from the MyCourses course.
• If a student has not participated in class each week and submitted at least 50% of the coursework at the 60% , the student may be withdrawn, with a WF. If the student is withdrawn with a WF, then he/she will be deleted from the MyCourses course.

NOTE: Not achieving attendance leads to a WF (Withdrawn and Failed) implying serious financial and GPA consequences.

Active participation means that:

• You will have read the materials and completed any assignments by the posted due dates.
• You will engage with and respond to your peers during online or in class discussions or posts; you will listen attentively to every speaker and respond respectfully to the ideas of others both in class and in the virtual venue.
• You will exhibit a deliberate effort to apply, extend, and challenge concepts that we generate in class and in the virtual venue.
• You will demonstrate your curiosity and willingness to ask questions, advance comparisons, and make observations.

Academic Honesty

Academic honesty and plagiarism will not be tolerated. Note that any form of copying or repeating input from other sources without proper APA citations would be a transgression. See the SPC policies on the web.

Student Survey of Instruction

The student survey of instruction is administered in courses each semester. It is designed to improve the quality of instruction at St. Petersburg College. All student responses are confidential and anonymous and will be used solely for the purpose of performance improvement.

SPC Information & Policies

SPC policies and information are no longer managed from the syllabus document. They may be found at the Syllabus Addendum on the general SPC website.

Support Services and Resources

Student HelpDesk / (727) 341-4357

SPC Library /
College of Computer & Information Technology /
College Calendar /
Career Development Services /
International Student Services /
Learning Support Centers /
New Initiative Center (NIP) /
Syllabus Addendum /

Assignments and Due Dates

All weeks’ assignments will open at 1:00 AM on Saturday morning and close the following week on Sunday at 11:55 PM, with the exception of week 8. In week 8, the final due date is 11:55 PM on Wednesday for all week 8 assignments. After each week, the week’s folders and dropboxes will be disabled and further assignments cannot be submitted.

See the Assignment Checklist in MyCourses for details on due dates.

ACCESSIBILITY

This course is designed to be welcoming to, accessible to, and usable by everyone, including students who are English-language learners, have a variety of learning styles, have disabilities, or are new to online learning. Be sure to let me know immediately if you encounter a required element or resource in the course that is not accessible to you. Also, let me know of changes I can make to the course so that it is more welcoming to, accessible to, or usable by students who take this course in the future.

If you have documentation of a disability or feel you may have a disability:

St. Petersburg College recognizes the importance of equal access to learning opportunities for all students. Accessibility Services (AS) is the campus office that works with students who have disabilities to provide and/or arrange reasonable accommodations. Students registered with AS, who are requesting accommodations, are encouraged to contact their instructor by the first week of the semester. Students who have, or think they may have, a disability (e.g. learning disability, ADD/ADHD, psychiatric, medical/orthopedic, vision, and/or hearing), are invited to contact the Accessibility Coordinator (AC) that serves your campus for a confidential discussion. To find your AC for your specific campus, please go to the college-wide Accessibility Services website:

ESSENTIAL SKILLS AND TECHNICAL STANDARDS

The field of computers and information technology is intellectually and at times physically challenging. The Americans with Disabilities Act (ADA) and Section 504 of the Rehabilitation Act of 1973 ensure that qualified applicants have the ability to pursue program admission. However, all students must meet the essential skills and technical standards required of the St. PetersburgCollege of Computer and Information Technology Programs with or without reasonable accommodations for admission and completion of the program to prepare for the profession of study.Each student will be held to the same standards with or without reasonable accommodations. Our focus is the student and to best prepare him or her for the profession. Our goal is for them to enter and complete the program without barriers.

The essential functions described in this document are based on the knowledge and skills as prescribed by the Florida State Department of Education’s Curriculum Framework for each AS degree in the College of Computer and Information Technology. Students who graduate from the following AS Programs are required to meet the expectations of the program’s essential functions, and the functions list assists students in determining whether they can meet the performance expectations of the program, with or without accommodations.

SPC CCIT Computer and Programming Analysis AS: Essential Functions

COMPETENCY / ESSENTIAL FUNCTION / EXAMPLES OF REQUIRED FUNCTIONS
(not all inclusive)
Interpersonal Communication / Customer service, human relations and communication skills sufficient for effective interaction with others, whether in verbal or oral formats. /

• Communicate effectively with clients and team members by displaying excellent verbal/oral, written and listening skills.
• Ability to demonstrate appropriate positive social skills to interact with clients, team members and colleagues.

Critical Thinking / Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems. /

• Demonstrate ability to conceptualize, analyze, synthesize, and evaluate a problem and propose an adequate solution.
• Analyze and evaluate problems to determine if given data and information will produce required outputs.

Complex Problem Solving / Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions. /

• Capacity to solve novel, ill-defined problems in a complex, real-world setting.
• Ability to reduce a complex problem to a series of ordered steps.
• Identify both positive and negative factors that could impact the solution to a problem and prepare measures to manage those factors.

Computation / Applying the knowledge of mathematics to solve problems. /

• Identify mathematical and statistical analysis procedures needed to develop a solution.
• Ability to apply similar problem solving techniques utilized in mathematics to solve logical computing and technology problems.

Programming and Analysis / An understanding of writing computer programs by describing the process, procedure and the algorithm. /

• Articulate a series of actions or steps to achieve an end in a certain order.
• Evaluate an ordered set of steps to solve a problem.
• Determine the precision and accuracy required for a task.

Professional / Broad understanding of the industry and demonstrated programming and technical skills /

• Maintain knowledge of the tools, techniques and resources to remain current in the IT field.
• Ability to complete an internship in the IT field.
• Develop the skills needed to take the aligned industry certification(s).

If a student cannot demonstrate the abilities above, it is the responsibility of the student to request an appropriate accommodation with Accessibility Services. Please contact the Accessibility Coordinator on your campus or visit of a reasonable accommodation will be made on an individual basis and the accommodation cannot fundamentally alter the nature of the program offered, impose an undue hardship, or jeopardize safety.