CSC 210: Database: 3 hours

Description

A course introducing the student to the principles and practices of data base management and database design. Topics will include relational database design, normalization, SQL queries, reports and other interfaces to database data, and documentation, as well as ethical and privacy issues associated with database systems. Prerequisite: CSC 102, CSC 121, ITSC 121, or permission of the instructor.

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\x92s 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.

Details

• Professor: Dr. Cathy Bareiss
• Office SB 031
• Class Time: MW 9:00-9:50
• Class Location: S 025 or zoom
• Textbook:
  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
  3. Oracle SQL: A Beginner's Tutorial, Second Edition by Djoni Darmawikarta. ISBN: 9781771970303
  4. SQL Primer: An Accelerated Introduction to SQL Basics by Rahul Batra. ISBN: 9781484235751
  5. Practical SQL: A Beginner's Guide to Storytelling with Data by Anthony DeBarros. ISBN: 9781593278274
  6. SQL: A Beginner's Guide, Fourth Edition by Andrew Oppel
  7. Introduction to SQL and PL/SQL by Sharad Maheshwari. ISBN: 9780071842594
• Resources: All the Oracle Database 12c - Introduction to SQL courses found on SkillSoft of the learning center of ACM
  1. First one: Oracle Database 12c - Introduction to SQL: SQL*Plus and SELECT statement

Course Content

Policies

• Integrity
• Late Work

Assignments

Homework Assignments

1. Simple SQL
2. Aggregation and joins
3. Nested and advanced SQL
4. SQLGuidelinesWorksheet.rtf: Form the the SQL reference sheet. See canvas for the due dates!
5. ER Homework 1
6. ER Homework 2
7. Normalization homework. From Chapter 7 of the "Fundamentals" textbook: Questions 5 (a-c), 7, 8, 9, 12, 15. Exercise 2, and Minicase 2 → just create the tables using our functional dependency rules
8. Concurrency, etc. homework. From Chapter 11 of the "Fundamentals" textbook: Questions 11, 16, 18, 19, and 20. Exercise 3a and b.

Lab Assignments

1. Simple SQL
2. Aggregation and joins
3. Nested and advanced SQL
4. ER Lab 1
5. ER Lab 2

Grades

• Homework, etc. is worth 20% of the final grade
• Programs are worth 40% of the final grade
• Exams are worth 40% of the final grade with the cumulative final being worth twice a normal exam
• Grade scale
  • 93% <= average <= 100% → A
  • 90% <= average < 93% → A-
  • 87% <= average < 90% → B+
  • 83% <= average < 87% → B
  • 80% <= average < 83% → B-
  • 77% <= average < 80% → C+
  • 73% <= average < 77% → C
  • 70% <= average < 73% → C-
  • 67% <= average < 70% → D+
  • 63% <= average < 67% → D
  • 60% <= average < 63% → D-
  • 0% <= average < 60% → F

Tentative Schedule

Monday	Wednesday	Friday
Apr 11: Transaction processing	Apr. 13: Transaction processing	Apr. 15: Easter Break
Apr 18: Indexes	Apr. 20: NoSQL	Apr. 22: review for exam
Apr 25:	Apr. 27: Exam 4	Apr. 29: review for final
Apr 4: Exam 3	Apr. 6: Normalization	Apr. 8: Transaction processing
Feb 14: SQL reports Lab 2 due	Feb 16: Security	Feb. 18: Privacy Homework 3 due
Feb 21: SQL	Feb 23: Current topic	Feb. 25: Lab 3 due
Jan 31: in class work	Feb 2: Snow Day	Feb. 4: Review and nested queries
Feb 7: Exam 1 Homework 2 due	Feb 9: nested queries	Feb. 11: nested queries and sets
Jan 10:	Jan 12:	Jan. 14: Introduction to Database
Jan 17: Introduction to SQL	Jan 19: Introduction to SQL	Jan. 21: Database and in class work
Jan 24: Joins Homework 1 due	Jan 26: Joins	Jan. 28: Joins Lab 1 due
Mar 14: ER Diagrams	Mar 16: ER Diagrams	Mar. 18: ER Diagrams
Mar 21: ER Diagrams Homework 4 due	Mar 23: Constraints	Mar. 25: Views, etc.
Feb 28:	Mar 2: Exam 2	Mar. 4: Class cancelled SIGCSE
Mar 28: In class work	Mar 30: Normalization Lab 4 (ER lab) Due	Apr. 1: Normalization
Mar 7: Spring Break	Mar 9: Spring Break	Mar. 11: Spring Break
May 2: Final Exam at 8:00am	May 4: finals week	May 6:

Campus Integrity Policy

The student handbook (p. 156) states: “Any act of deceit, falsehood or stealing by unethically copying or using someone else’s work in an academic situation is strictly prohibited.

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

Covid Policy

Everyone should follow the current Bethel University covid policy. See: https://www.betheluniversity.edu/intheknow for details

Services

The Americans with Disabilities Act (ADA) is a law which provides civil rights protection for people with disabilities. Bethel University, in compliance with equal access laws, requests that students with disabilities seeking to acquire accommodations make an appointment with the Center for Academic Success—Disability Services. It is located in the Miller-Moore Academic Center, 033. You may also phone 574-807-7460 or email rachel.kennedy@betheluniversity.com.edu for an appointment.

DEI Statement

During this particularly difficult time, this statement momentarily underscores and deepens what is expressed in the Lifestyle Covenant regarding the dignity of all humans. The statement will remain in all Bethel Faculty syllabi until spring 2023 and then be remanded back to the Faculty. Bethel University respects the dignity of all God’s image-bearers, and stands against racism, prejudice, and discrimination. Because Christ calls us to love our neighbor as ourselves, Christian discipleship includes pursuing the good of those who suffer injustice due to their color, race, or ethnicity. Therefore, we aim to continually transform our classrooms into safe and hospitable spaces where we listen to one another with mercy, learn from and value each other with tenacity, and commit to pursuing justice for the most vulnerable in our community.

Education Majors:

Please use the link below to review all appropriate standards. Standards

• SQLGuidelinesWorksheet.rtf: Form the the SQL reference sheet