CSC 2212Database Systems

Spring 2022


Roger Shore

Class Schedule:

Office Location:

Congdon Hall 153

MW 12:05-1:35PM CSC-2212



MWF 7:50AM-9:00AM CSC-2342

Office Hours:

MWF 2:00-3:00PM

TTh 1:35-3:15PM CSC-4210

TTh 8-9:30AM


Web site:

Description: This course covers database design and the use of databases in web, mobile and cloud applications. It includes extensive coverage of the relational model, relational algebra, and SQL as well as NoSQL designs. The course also features database design and relational design principles based on dependencies and normal forms. There will be a programming project, which explores database design and management in web applications by utilizing appropriate features of SQL.

Prerequisite: CSC-1720

Text: Coronel and Morris, Database System – Design, Implementation, and Management(978-1-337-62790-0),

13th Ed., Cengage

Course Objectives:

  1. Apply entity-relationship techniques in designing a relational data model or a "NoSQL" persistence model.

  2. Master the use of Structured Query Language (SQL) and NoSQL at the command line and within applications to create tables, modify their contents, and execute queries.

  3. Design and implement databases based on normalization principles for relational databases, including the various normal forms.

  4. Understand underlying file structures used to implement databases, and their performance implications.

  5. Demonstrate how to perform backups and crash recoveries.

  6. Demonstrate an understanding of multi-user database concerns such as concurrency control, security, and integrity.

  7. Describe database sharding and scalability.

  8. Implement various applications of database systems with the relationship to the web and cloud computing.

Class Preparation: It is assumed that you will read the assigned chapters. Although the material may be summarized, lectures will be used mainly to further demonstrate other approaches to problem solving and to answer specific questions.

Assessment: The course objectives will be assessed through major tests, the final exam and problem set assignments. The final grade will be determined as follows:

Assignments/Quizzes: 20%

2-3 Major Tests: 60%

Cumulative Final Exam: 20%

Total: 100%



























You must score at least the minimum of a category to be given the associated grade, i.e. an average of 80 is a B- not a C+.

Major tests and Final Exam: All tests and final exam will consist primarily of problem solving type questions similar to the homework assignments and quizzes. No make up test will be given unless prior arrangements have been made with excusable reasons. If you miss a test your final grade will be used in place of the missed grade. This means the percentage of the final exam will increase. If you miss the final exam, a 0 will be placed in all missing tests.

Quizzes, class worksheets and assignments: In addition to the major tests and final exam, students will participate in series of problem sets to further develop skills and understanding of discrete mathematical structures found in computer science. Each assignment will focus on a collection of problems that target each learning objective individually or a combination of learning objectives. Successful completion of the assignments will prepare the student for major tests and final exam. There will be at least 12. There is no makeup for these items. For this reason, two will be dropped to accommodate an occasional absence.

Attendance: High Point University recognizes and honors the value of the face-to-face classroom experience for enhancing student engagement and academic outcomes. Attendance will be taken daily at the beginning of class. As such, you are expected to be present in every class meeting with the exception of an illness that requires quarantine or other reasons pre-approved by the instructor. In those cases online accommodations will be provided. If absent from class, you are responsible for all lectures, in-class exercises, assignments, and handouts. Caution: Being absent from class does not change the due date of assignments. Before a student is dropped for non-attendance, I will give a notification as a warning to a student that he/she is in danger of violating the attendance requirements.

Honor Code: All students are expected to follow the University Honor Code, Full details of the High Point University Honor Code are found here: All academic work should be completed with the highest level of honesty and integrity.

Professionalism: The Mission Statement of the Webb School of Engineering is: To provide an extraordinary engineering education through the delivery of a hands-on, practical education that prepares graduates for a rewarding career or admission into graduate school. The School of Engineering is committed to:

Please treat this class as if it were a company or organization for which you are working. You can exhibit professionalism by attending consistently, arriving on time, communicating your full or partial absence in a timely fashion, completing assignments on time, maintaining engagement, and respecting your peers and the professor.

Classroom etiquette:

Lab etiquette:

Students with Disabilities: High Point University is committed to ensuring all students have equal access to all services and benefits at High Point University. If you are a student with a disability and require academic accommodations due to a diagnosed disability, you must register with the Office of Accessibility Resources and Services (OARS) and submit the appropriate documentation. Requests for accommodations should be made at the beginning of a course. Accommodations are not retroactive. Contact us at or by telephone at 336-841-9026, for additional information. The Office of Accessibility Resource and Services is located on the 4th Floor of Smith. Library.

Face covering: Wearing a face mask reduces the risk of COVID-19 transmission and is a step we can all take to care for the members of our HPU family. This class will abide by the guidelines that are set forth by the University. Please note this may change as the semester progresses.

Tentative Schedule of Topic Coverage

Week 1: Introduction to databases/Data Models – CH-1

Week 2: Data Modeling/Abstraction – CH-2

Week 3: Relational Model/Algebra – CH-3

Week 4: Entity-Relationship ModelCH-4/5

Week 5: Normalization of a Database – CH-6

Week 6: Test #1 and Database Design - CH-9

Week 7: Database design – CH-9

Week 8-10: Structured Query Language (SQL) – CH7

Week 11: Advanced SQL - CH8

Week 12: Practice and Test #2

Week 13: Advanced Database concepts - CH10

Week 14: Database connectivity and Web Technologies - CH15

Week 15: Project Presentations

Cumulative Final Exam – All learning objectives