CSC 210: Database Summer 2021

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

Details for Fall 2020A

• Professor: Dr. Cathy Bareiss
• Office SB 027
• Class Time: online
• Class Location: Online
• Textbook: resources found in ACM Learning Center (accessible via student membership in ACM). These include:
  • O'Reilly Resources
    1. Fundamentals of Database Management Systems, Second Edition by MARK L. GILLENSON: Publisher: Wiley: Release Date: December 2011: ISBN: 9780470624708
    2. Concepts of Database Management System by Shefali Naik: Publisher: Pearson India: Release Date: April 2013: ISBN: 9789332537422
    3. Advanced Data Management by Lena Wiese: Publisher: De Gruyter: Release Date: October 2015: ISBN: 9783110433074
    4. Database Administration by Craig S. Mullins: Publisher: Addison-Wesley: ISBN 0-321-82294-3
  • Skillsoft Learning Courses
    1. Introduction to SQL
    2. Introduction to SQL: Multiple Tables and Advanced Queries
    3. Introduction to SQL: Managing Table Design
    4. Introduction to SQL: Views, Transactions, and SQL Security Architecture

Course Content

Policies

• Integrity
• Late work

Homework Assignments

1. Simple SQL
2. Aggregation and joins
3. Nested and advanced SQL

Lab Assignments

1. Simple SQL
2. Aggregation and joins
3. Nested and advanced SQL
   1. additional (optional) Advanced SQL
4. ER Diagramming

Grades

• Homework and quizzes
• Programs
• Exams

• 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

=Services= ADA Statement for Syllabi: 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.

COVID-19 Adjustments

• SEATING – After choosing your seat for this class, please consistently sit in the same seat all semester.
• FACECOVERINGS - All students must wear face coverings in all classes. You have been provided face coverings for this purpose. If you forget your face covering, and can’t retrieve it and be back in the classroom quickly, you will need to find a private space to synchronously livestream this class or be counted absent.
• LIVESTREAMING - This class is being livestreamed and stored in Canvas for watching only by a student enrolled in this class. The purpose of the livestreaming/recorded lecture is to accommodate a student who is being quarantined or isolated due to COVID-19. Abusing this feature by letting other students not enrolled in this class view the recording or privately videotaping the recording will be considered a violation of the Campus Lifestyle Covenant. However, when you are ill or participating in a campus sponsored event (like a sport team) you are encouraged to view the recording at a later time.