CSC 2212 – Database Systems

Spring 2022

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),

13^th 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%

Range	93-100	90-93	87-90	83-87	80-83	77-80	73-77	70-73	67-70	63-67	60-63	0-60
Grade	A	A-	B+	B	B-	C+	C	C-	D+	D	D-	F

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: http://www.highpoint.edu/studentconduct/university-honor-code 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:

• Providing an environment that encourages curiosity.

• Developing technical competence within a Liberal Arts framework.

• Fostering independent thought and critical thinking to solve modern engineering and computing problems in an ethical, socially-responsible, and sustainable manner.

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:

• Cell phone usage during class is prohibited. Turn off cell phones (or place on vibrate). Please do not interrupt any aspect of the class due to your cell phone. This includes voice, text, video, data or any other current or future transmission technology.

• Do not listen to your digital media during class or lab time.

• Profanity will not be tolerated. Lewd remarks printed on your clothing are also not tolerated.

• Hats are not to be worn during class.

• Laptops are allowed during class and can only be used for class related instruction. Inappropriate use of a laptop, desktop or other electronic computing device during class will result in you being asked to leave the room.

Lab etiquette:

• The labs were created with student input. Please help respect and maintain the lab.

• Do not eat while sitting at a workstation. If you must eat while in the lab, sit a the larger table where no equipment may be damaged except your own. Clean up the area after you finish eating.

• Clean up your area before you leave the lab. Unless you are planning to return in a few minutes, please take all books, paper, etc with you.

• DO NOT lock your workstation when you leave!

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 oars@highpoint.edu or by telephone at 336-841-9026, for additional information. The Office of Accessibility Resource and Services is located on the 4^th 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

• Data vs Information

• Database systems

Week 2: Data Modeling/Abstraction – CH-2

Week 3: Relational Model/Algebra – CH-3

• Modeling Data

• Relational Algebra

• Relationship to Relational Database

• Relationship to programming languages

• Data Redundancy

Week 4: Entity-Relationship Model – CH-4/5

• Modeling Data with an ER diagram

• Extended ER Model

Week 5: Normalization of a Database – CH-6

• Need for Normalization

• The process of Normalization – normal forms

• Higher levels of Normalization

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

• Major Test #1 – Learning objectives 1, 3, and 4.

• System Development Life Cycle

Week 7: Database design – CH-9

• System Development Life Cycle

• Database Life Cycle

• Creating a Database - Data Definition Commands - CH-8

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

• Intro to SQL

• Join Operations

• Aggregation

• Subqueries

• Function and Set Operators

• Major Test #2 – Learning objectives 1, 2, 3, and 4.

Week 11: Advanced SQL - CH8

• SQL Practice

• Data Manipulation Commands

• Adding/Modifying Tables

• Inserting/Deleting/Modifying Records

Week 12: Practice and Test #2

• SQL Practice

• Major Test #3 – Learning objectives 1, 2, 3, and 4.

Week 13: Advanced Database concepts - CH10

• Concurrency

• Transactions

• Database performance

Week 14: Database connectivity and Web Technologies - CH15

• SQL injections

• Integrity

• Backups and Crash Recovery

Week 15: Project Presentations

Cumulative Final Exam – All learning objectives