Principles of Databases

list Preamble

• Course Title: Principles of Database Systems (cs 365)
• CRN: 43091
• Credits: 3
• Lab fee: Yes
• Prerequisites: cs 220P (Data Structures)
• Days: Mondays and Wednesdays
• Time: 9:55 – 11:10 am
• Room: Dana Hall 318 map map
• Dates: 28 August – 11 December 2023
• Professor: Roy Vanegas (pronounced “vuh-nay-gus”) sound_detection_loud_sound
• Email: vanegas at hartford dot edu
• Phone: 860.768.5925
• Office: Charles A Dana Hall, 310B
• Office hours: I meet students via video conference on the following day (click here for details). Other times by appt.
  • Tuesday: 11:00 am – 5:00 pm

info Description

This course provides students with a solid background in the theory, design, and programming of database systems, with an emphasis on relational databases. The course introduces database query languages, including an in-depth coverage of the Structured Query Language (sql). Document-oriented databases, such as xml and json, will also be covered. Other topics include storage and indexing techniques, transactions, and database management via the command line.

list Learning Outcomes

Upon successful completion of this course, students will understand...

• how to create and maintain relational databases;
• how to structure content as data models in json and xml;
• how to create, read, update, and delete data (crud) in a relational database using Mysql;
• how to index a database for increased performance;
• and, how to work with transactions in order to recover from failures.

file_download Software Requirements

All the software required for this course is free and listed below.

MySQL

Download Mysql from https://dev.mysql.com/downloads/mysql/. Pay special attention to the correct version of Mysql for your os.

GitHub Desktop

Git is the industry standard for revision controlling code. GitHub is a ui for Git and is the most popular graphical client for Git. Download the Linux, Windows, or macOS version from https://desktop.github.com/.

Text Editor

The code you write will require a text editor. Although there are many on the market, such as Sublime Text (nagware), for example, vs Code (open source) is the only editor supported in class. Download the Linux, Windows, or macOS version from https://code.visualstudio.com/.

EditorConfig

EditorConfig is a tool that enforces consistent coding styles for everyone who works on a codebase. In our case, that codebase consists of all the examples in class and all the assignments you’ll submit throughout the semester. EditorConfig consists of a configuration file (.editorconfig) that goes in your home — or project — folder, and an extension. Some editors and ides have EditorConfig built in. vs Code, unfortunately, is not one of them.

Download this .editorconfig file and place it in your home folder. Ensure the file name is exactly .editorconfig, starting with a dot and without an extension. Then install the EditorConfig for vs Code extension for vs Code, whose id is EditorConfig.EditorConfig.

Fonts (Optional)

You will need to set your text editor to a monospace/fixed-width font family in your editor’s settings, because code requires vertical alignment that only this family of fonts can provide. The options provided by your os are limited. Thus, in addition to the stock issue fonts included with your computer, here are a few more options to explore:

• IBM Plex
• Ubuntu Mono
• Fira Mono
• Anonymous Pro
• Inconsolata

menu_book Textbook

The textbook listed below is the only book used for this course. Ensure all the details match before making your purchase.

Textbook-related Info

Book Cover
Title	Database Systems: The Complete Book
Edition	2
Authors	Hector Garcia-Molina, Jeffrey D Ullman, Jennifer Widom
isbn-13 (ebook)	9780133002010
isbn-13 (print)	9780131873254
Publisher	Pearson

calendar_month Schedule

Any changes to this schedule will be announced the week before.

Important Notes

You should get accustomed to using your own laptop for computer science courses. Thus, you will need to bring your own laptops to class. We will use a portion of the first week of classes to install the software you need on your personal machines.

Notable Dates

⟫ First day of classes (Week 1): Monday, 28 August 2023

⟫ Labor Day — No class (Week 2): Monday, 4 September 2023

⟫ Last day to withdraw with a grade of “W” (Week 10): Friday, 3 November 2023

⟫ Thanksgiving recess — No class (Week 13): Monday, 20 November, and Wednesday, 22 November 2023

⟫ Last day of classes (Week 16): Monday, 11 December 2023

assignment Assignments

The workload for this course involves four programming assignments. (See the Grading section to learn what percentage of your final grade each is worth.) As noted in the instructions for each assignment, No late work is accepted.

• Assignment I
• Assignment II
• Assignment III
• Assignment IV

info Grading

Grading Formula

Your grade for this course is computed as follows:

1. Programming assignments (60%)
   • Assignment 1 — 15%
   • Assignment 2 — 15%
   • Assignment 3 — 15%
   • Assignment 4 — 15%
2. Midterm exam (20%)
3. Final exam (20%)

To calculate your final grade, convert the percentages listed above and your grades to decimal. For example, if you got an 80 on the first programming assignment, a 93 on the second, a 60 on the third, a 50 on the fourth, a 95 on your midterm, and, finally, a 100 on the final exam, then you’d calculate your final grade as follows:

(.80 × .15) + (.93 × .15) + (.60 × .15) + (.50 × .15) + (.95 × .20) + (1 × .20) = 80%

You can convert your percentage grade to a letter grade at http://vanegas.cs.hartford.edu/grading/.

I do not give grades; students earn them. The grade you earn is based strictly on the outlined formula clearly listed in this section.

This grading formula is unbending and will be adhered to strictly.

Important Note

Please do not try to negotiate a grade with me. By asking me to treat you favorably, you’re requesting that I put you above your classmates. Manage your time well; I do not accept late work.

balance Class Policies

• Masks. I don’t require students to wear masks in class, per university policy dictated in spring 2022: Effective immediately, masks are now optional in most University facilities and settings. They [masks] will continue to be required in the classroom or personal office spaces, unless otherwise specified by faculty members or staff. And, of course, you’re welcome to wear a mask in class, should you feel more comfortable doing so. You may read more about the policy regarding face coverings here.
• Consuming food in class. There is no eating inside our classroom, either during class or while on break. Eat before or after class. Drinks in covered containers, however, are allowed.
• Digital devices. Silence your mobile devices before class starts.

warning Academic Honesty

Cheating of any kind will not be tolerated in this course; make certain that all the work you submit is your own. Refresh your understanding of the college’s policy on academic honesty.

accessible Students with Disabilities

If you have a documented disability for which you are requesting accommodation, you are encouraged to contact Access-Ability Services as soon as possible by calling 860.768.4312, emailing tlopez@hartford.edu, or by stopping by the Access-Ability Services office in Auerbach Hall, Room 209. If your request for accommodations is approved, an accommodation letter will be emailed to your instructor(s) upon your request. Please discuss your accommodations with the instructor as soon as possible to make appropriate arrangements. Note: Student requests for accommodations must be filed each semester. Visit https://www.hartford.edu/academics/academic-support/accessibility-services/ and click the “Registering” link for more info and a link to a video to walk you through the process.

balance Title IX and Sexual Assault

Sexual violence and other forms of sexual misconduct and harassment, including stalking and intimate partner violence, are prohibited under Title ix, federal and state law, and University of Hartford policy. Information on the University’s policies against sexual violence can be found at https://www.hartford.edu/about/policies/title-ix/. Resources regarding sexual violence can be found at https://www.hartford.edu/about/policies/title-ix/on-off-campus-resources.aspx

Note: University of Hartford faculty, staff, and ras are required to report incidents of sexual misconduct to the Title ix Office (title9@hartford.edu). For further information on The University’s policies and resources, please contact Jason Martinez (860.768.5255; jamartine@hartford.edu) or Justin Bell (860.768.4880; jbell@hartford.edu).

psychology Mental Health and Well-Being

Mental Health is an important aspect of students’ well-being and integral to positive academic experiences and success. If, during the semester, you experience difficulties and would like support, consider contacting the University of Hartford’s caps, or Counseling and Psychological Services, which offers a range of short-term counseling services available to full-time undergraduate students at no additional cost, and to part-time undergraduate and graduate students for a small fee. caps is located in Gengras Student Union, Room 313 map, and can be reached by calling 860.768.4482 or emailing Liz Inkel at inkel@hartford.edu. Office hours are Monday – Friday, 8:30 AM – 4:30 PM.

info Advice on Succeeding in Class

Read over the following to understand procedures for maximizing your chance of succeeding in class.

• Advice for Succeeding in Class (in Markdown)
• Advice for Succeeding in Class (in pdf)

door_front Office Hours

• Office: Charles A Dana Hall, 310B
• Hours: I meet students via video conference on the following day (click here for details). Other times by appt.
  • Tuesday: 11:00 am – 5:00 pm

contact_mail Contact

Nowadays, I only use email for emergency situations, such as pet emergencies, personal tragedies, etc. For matters related to our course, you’re advised to see me before or after class, during my office hours, or by appointment. My contact info is listed in the Preamble.