CSC 210: Database: 3 hours

Description

Goals for CSC 210 are:

1. Learn to write complex sql statements
   
2. Learn to being to design tables
   
3. Learn about ethical and cyber security issues associated with databases

Course outcomes for CSC 210 are:

• Upon completion of CSC 210, students will understand:
  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. (Computing student learning outcome 1)
2. Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. (Computing student learning outcome 2)
   
3. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles. (Computing student learning outcome 4)
   
4. Learn new areas of technology. (Computing student learning outcome 6)
   
5. Use technology to help bring Christ to the world and apply Christian principles to their work. (Computing student learning outcome 7)
   
6. Understand and use appropriate cloud technologies in specified areas (Computing student learning outcome 8)
7. Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science student learning outcome 1)
8. Support the delivery, use, and management of information systems within an information systems environment. (Computing and Information Systems student learning outcome 1)
9. Apply security principles and practices to maintain operations in the presence of risks and threats. (Cyber Security student learning outcome 1)

Integration

1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
3. Professionalism at the introductory level by
   • having students learn about the need for high quality work for table design
   • having students learn to respect the knowledge of the domain expert when designing tables.
   • not accepting any document/work that does not have a name on it
4. Security at the introductory level by
   • having students learn about only storing the data needed and nothing more
   • having students learn about SQL injections.
   • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

Campus Integrity Policy

1. A student found guilty of plagiarism or cheating will receive an “F”(zero) for that particular paper, assignment or exam. Should this occur, the professor will have an interview with the student and will submit a written report of the incident to the academic dean.
2. If a second offense should occur, the student will be asked to appear before the professor, the academic dean and the vice president for student development.
   
   

The student should realize that at this point continuation in a course and even his/her academic career may be in jeopardy. In the event of a recommendation for dismissal, the matter shall be referred to the Student Development Committee.”

AI Use Policy

It is expected that any coursework (including, but not limited to, essays, papers, exams, projects, and lab reports) submitted by a student will be a product of their own creation, demonstrating their achievement of the learning outcomes related to the assigned task. With this in mind, note that submitting work that includes unauthorized or undocumented use of Artificial Intelligence (AI) may be considered as cheating or plagiarism. If you are unsure about appropriate use of AI on a given assignment, talk with your professor.

Services

Education Majors:

Standards

CSC 210: Database: 3 hours

Description

Goals for CSC 210 are:

1. Learn to write complex sql statements
   
2. Learn to being to design tables
   
3. Learn about ethical and cyber security issues associated with databases

Course outcomes for CSC 210 are:

• Upon completion of CSC 210, students will understand:
  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. (Computing student learning outcome 1)
2. Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. (Computing student learning outcome 2)
   
3. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles. (Computing student learning outcome 4)
   
4. Learn new areas of technology. (Computing student learning outcome 6)
   
5. Use technology to help bring Christ to the world and apply Christian principles to their work. (Computing student learning outcome 7)
   
6. Understand and use appropriate cloud technologies in specified areas (Computing student learning outcome 8)
7. Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science student learning outcome 1)
8. Support the delivery, use, and management of information systems within an information systems environment. (Computing and Information Systems student learning outcome 1)
9. Apply security principles and practices to maintain operations in the presence of risks and threats. (Cyber Security student learning outcome 1)

Integration

1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
3. Professionalism at the introductory level by
   • having students learn about the need for high quality work for table design
   • having students learn to respect the knowledge of the domain expert when designing tables.
   • not accepting any document/work that does not have a name on it
4. Security at the introductory level by
   • having students learn about only storing the data needed and nothing more
   • having students learn about SQL injections.
   • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

Grades

Your grades are made up of:

• Grade scale
  • 93% <= average <= 100% -> A

CSC 210: Database: 3 hours

Description

Goals for CSC 210 are:

1. Learn to write complex sql statements
   
2. Learn to being to design tables
   
3. Learn about ethical and cyber security issues associated with databases

Course outcomes for CSC 210 are:

• Upon completion of CSC 210, students will understand:
  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. (Computing student learning outcome 1)
2. Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. (Computing student learning outcome 2)
   
3. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles. (Computing student learning outcome 4)
   
4. Learn new areas of technology. (Computing student learning outcome 6)
   
5. Use technology to help bring Christ to the world and apply Christian principles to their work. (Computing student learning outcome 7)
   
6. Understand and use appropriate cloud technologies in specified areas (Computing student learning outcome 8)
7. Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science student learning outcome 1)
8. Support the delivery, use, and management of information systems within an information systems environment. (Computing and Information Systems student learning outcome 1)
9. Apply security principles and practices to maintain operations in the presence of risks and threats. (Cyber Security student learning outcome 1)

Integration

1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
3. Professionalism at the introductory level by
   • having students learn about the need for high quality work for table design
   • having students learn to respect the knowledge of the domain expert when designing tables.
   • not accepting any document/work that does not have a name on it
4. Security at the introductory level by
   • having students learn about only storing the data needed and nothing more
   • having students learn about SQL injections.
   • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

Other Assignments

Extra credit

• Extra credit will only be made available based on the entire class needs. Such as an exam that most people did poorly on despite a good effort.

Grades

CSC 210: Database: 3 hours

Description

Goals for CSC 210 are:

1. Learn to write complex sql statements
   
2. Learn to being to design tables
   
3. Learn about ethical and cyber security issues associated with databases

Course outcomes for CSC 210 are:

• Upon completion of CSC 210, students will understand:
  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. (Computing student learning outcome 1)
2. Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. (Computing student learning outcome 2)
   
3. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles. (Computing student learning outcome 4)
   
4. Learn new areas of technology. (Computing student learning outcome 6)
   
5. Use technology to help bring Christ to the world and apply Christian principles to their work. (Computing student learning outcome 7)
   
6. Understand and use appropriate cloud technologies in specified areas (Computing student learning outcome 8)
7. Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science student learning outcome 1)
8. Support the delivery, use, and management of information systems within an information systems environment. (Computing and Information Systems student learning outcome 1)
9. Apply security principles and practices to maintain operations in the presence of risks and threats. (Cyber Security student learning outcome 1)

Integration

1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
3. Professionalism at the introductory level by
   • having students learn about the need for high quality work for table design
   • having students learn to respect the knowledge of the domain expert when designing tables.
   • not accepting any document/work that does not have a name on it
4. Security at the introductory level by
   • having students learn about only storing the data needed and nothing more
   • having students learn about SQL injections.
   • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

CSC 210: Database: 3 hours

Description

Goals for CSC 210 are:

1. Learn to write complex sql statements
   
2. Learn to being to design tables
   
3. Learn about ethical and cyber security issues associated with databases

Course outcomes for CSC 210 are:

• Upon completion of CSC 210, students will understand:
  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. (Computing student learning outcome 1)
2. Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. (Computing student learning outcome 2)
   
3. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles. (Computing student learning outcome 4)
   
4. Learn new areas of technology. (Computing student learning outcome 6)
   
5. Use technology to help bring Christ to the world and apply Christian principles to their work. (Computing student learning outcome 7)
   
6. Understand and use appropriate cloud technologies in specified areas (Computing student learning outcome 8)
7. Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science student learning outcome 1)
8. Support the delivery, use, and management of information systems within an information systems environment. (Computing and Information Systems student learning outcome 1)
9. Apply security principles and practices to maintain operations in the presence of risks and threats. (Cyber Security student learning outcome 1)

Integration

1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
3. Professionalism at the introductory level by
   • having students learn about the need for high quality work for table design
   • having students learn to respect the knowledge of the domain expert when designing tables.
   • not accepting any document/work that does not have a name on it
4. Security at the introductory level by
   • having students learn about only storing the data needed and nothing more
   • having students learn about SQL injections.
   • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

CSC 210: Database: 3 hours

Description

Goals for CSC 210 are:

1. Learn to write complex sql statements
   
2. Learn to being to design tables
   
3. Learn about ethical and cyber security issues associated with databases

Course outcomes for CSC 210 are:

• Upon completion of CSC 210, students will understand:
  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. (Computing student learning outcome 1)
2. Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. (Computing student learning outcome 2)
   
3. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles. (Computing student learning outcome 4)
   
4. Learn new areas of technology. (Computing student learning outcome 6)
   
5. Use technology to help bring Christ to the world and apply Christian principles to their work. (Computing student learning outcome 7)
   
6. Understand and use appropriate cloud technologies in specified areas (Computing student learning outcome 8)
7. Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science student learning outcome 1)
8. Support the delivery, use, and management of information systems within an information systems environment. (Computing and Information Systems student learning outcome 1)
9. Apply security principles and practices to maintain operations in the presence of risks and threats. (Cyber Security student learning outcome 1)

Integration

1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
3. Professionalism at the introductory level by
   • having students learn about the need for high quality work for table design
   • having students learn to respect the knowledge of the domain expert when designing tables.
   • not accepting any document/work that does not have a name on it
4. Security at the introductory level by
   • having students learn about only storing the data needed and nothing more
   • having students learn about SQL injections.
   • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

Assignments

Homeworks

1. Single Table SQL
2. Aggregation and Joins SQL
3. Nested and Advanced SQL

CSC 210: Database: 3 hours

Description

Goals for CSC 210 are:

1. Learn to write complex sql statements
   
2. Learn to being to design tables
   
3. Learn about ethical and cyber security issues associated with databases

Course outcomes for CSC 210 are:

• Upon completion of CSC 210, students will understand:
  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. (Computing student learning outcome 1)
2. Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. (Computing student learning outcome 2)
   
3. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles. (Computing student learning outcome 4)
   
4. Learn new areas of technology. (Computing student learning outcome 6)
   
5. Use technology to help bring Christ to the world and apply Christian principles to their work. (Computing student learning outcome 7)
   
6. Understand and use appropriate cloud technologies in specified areas (Computing student learning outcome 8)
7. Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science student learning outcome 1)
8. Support the delivery, use, and management of information systems within an information systems environment. (Computing and Information Systems student learning outcome 1)
9. Apply security principles and practices to maintain operations in the presence of risks and threats. (Cyber Security student learning outcome 1)

Integration

1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
3. Professionalism at the introductory level by
   • having students learn about the need for high quality work for table design
   • having students learn to respect the knowledge of the domain expert when designing tables.
   • not accepting any document/work that does not have a name on it
4. Security at the introductory level by
   • having students learn about only storing the data needed and nothing more
   • having students learn about SQL injections.
   • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

• LatePolicy
• SoftwareStandards

Assignments

Homeworks

CSC 210: Database: 3 hours

Description

Goals for CSC 210 are:

1. Learn to write complex sql statements
   
2. Learn to being to design tables
   
3. Learn about ethical and cyber security issues associated with databases

Course outcomes for CSC 210 are:

• Upon completion of CSC 210, students will understand:
  • how to write complex SQL queries
  • how to design and implement quality databases
  • security issues associated with database technologies
  • ethical issues associated with database technologies
  • improved testing techniques

Program outcomes for CSC 210 are:

1. Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. (Computing student learning outcome 1)
2. Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. (Computing student learning outcome 2)
   
3. Recognize professional responsibilities and make informed judgments in computing practice based on legal, ethical, and moral principles. (Computing student learning outcome 4)
   
4. Learn new areas of technology. (Computing student learning outcome 6)
   
5. Use technology to help bring Christ to the world and apply Christian principles to their work. (Computing student learning outcome 7)
   
6. Understand and use appropriate cloud technologies in specified areas (Computing student learning outcome 8)
7. Apply computer science theory and software development fundamentals to produce computing-based solutions. (Computer Science student learning outcome 1)
8. Support the delivery, use, and management of information systems within an information systems environment. (Computing and Information Systems student learning outcome 1)
9. Apply security principles and practices to maintain operations in the presence of risks and threats. (Cyber Security student learning outcome 1)

Integration

1. Self-learning at the introductory level by having the students learn a few sql functions on their own but having them part of the assignments. This could include formatting associated with dates, string functions, and dealing with nulls.
2. Note taking at the introductory level by requiring students take class notes and listen and record given guidelines (that may or may not be on slides) for sql and ER diagramming.
3. Professionalism at the introductory level by
   • having students learn about the need for high quality work for table design
   • having students learn to respect the knowledge of the domain expert when designing tables.
   • not accepting any document/work that does not have a name on it
4. Security at the introductory level by
   • having students learn about only storing the data needed and nothing more
   • having students learn about SQL injections.
   • having students learn how to secure data via views, constraints, and permissions, and the weaknesses of each.
5. Ethics at the introductory level by discussing the responsibilities that come from having access to a lot of data.

• Textbook: Student membership in ACM. Resources from ACM Learning Center that will be used include:
  1. Relational Database Design and Implementation, Fourth Edition by Jan L. Harrington. ISBN: 9780128043998
  2. Fundamentals of Database Management Systems, Second Edition by Gilleson. ISBN: 9780470624708

1. 1. SQL Primer: An Accelerated Introduction to SQL Basics by Rahul Batra. ISBN: 9781484235751

1. 1. SQL: A Beginner's Guide, Fourth Edition by Andrew Oppel

Course Content

Policies

• Integrity
• LatePolicy
• SoftwareStandards

Assignments

Homeworks

1. Single Table SQL
2. Aggregation and Joins SQL
3. Nested and Advanced SQL

Tentative Schedule (needs fixing)

Campus Integrity Policy

1. A student found guilty of plagiarism or cheating will receive an “F”(zero) for that particular paper, assignment or exam. Should this occur, the professor will have an interview with the student and will submit a written report of the incident to the academic dean.
2. If a second offense should occur, the student will be asked to appear before the professor, the academic dean and the vice president for student development.
   
   

The student should realize that at this point continuation in a course and even his/her academic career may be in jeopardy. In the event of a recommendation for dismissal, the matter shall be referred to the Student Development Committee.”

AI Use Policy

It is expected that any coursework (including, but not limited to, essays, papers, exams, projects, and lab reports) submitted by a student will be a product of their own creation, demonstrating their achievement of the learning outcomes related to the assigned task. With this in mind, note that submitting work that includes unauthorized or undocumented use of Artificial Intelligence (AI) may be considered as cheating or plagiarism. If you are unsure about appropriate use of AI on a given assignment, talk with your professor.

Services

Education Majors:

Standards