Database Management (Fall 2019 – CIS 4365)

Syllabus

CRN 12422
Fall 2019

Room: BUSN 320
Contact: ivan@boost-human.com
Meeting Times:  MW 9:00 AM -10:20 AM  BUSN 321
Office Hours: By appointment only
Book: Modern Database Management
Recommended software: XAMPP

Grading

Midterm 25%
Final exam 40%
Individual project(s) 35%
Portfolio +10%

Class Schedule

Week Topic Items Due/Comments
1 Introduction Familiarize yourself with the course goals and contents. Localhost setup.
2 Database Environment Relational DBMS
3 Data Modeling Data collection and organization
4 Introduction to SQL Access, create, and update data stored in a database.
5 Entity Relationship Diagrams Tables and views
6 Advanced SQL Perform more complex queries
7 SQL Functions Aggregate functions for data operations
8 MIDTERM Wednesday, October 16th
9 PHP MySQL Connection Login to your database through PHP
10 Data Collection Collect data through a website
11 Data Manipulation Manipulate and query data
12 Big Data and Analytics Statistics and other uses
13 Database Administration Sanitation, best data practices
14 Review Revisit earlier topics as needed
15 Final Project Presentations Final comments and evaluations
16 FINAL EXAM Final (December 11th, 10:00 am)

Important Dates

  • September 2nd – Labor Day, UTEP closed
  • September 24th – Individual Project 1
  • October 17th – Midterm
  • November 1st – Drop deadline
  • November 25th and 27th – One-on-one meetings
  • November 28th and 29th – Thanksgiving, UTEP closed
  • December 2nd – Final review
  • December 4th – Class cancelled
  • December 6th – Dead day
  • December 6th – Second project due date
  • December 6th – Portfolio due date
  • December 11th (10:00 am – 12:45 am) – Final exam

Homework

Slides

Readings

Week 3: p.31 – p.42
Week 4: p.249 – p.283

Group Project

  • Cancelled. Individual project #2 will replace it. Grading was adjusted accordingly.

Individual Projects

Final Exam and Review

  • The final exam will be Wednesday December 11th, 10:00 am – 12:45 pm in our regular classroom.
  • The final exam will be in Blackboard, and you are expected to write code, analyze and describe code, write what the expected output would be of a code given a specific input, and explain certain concepts.
  • The topics covered will include creating and altering tables, ER diagrams, primary and foreign keys, select and insert, php code connection, statistics in MySQL, and data analytics case-study questions.
  • You will get 5 minutes to read the exam. You should only read for those few minutes, and NOT answer any questions yet.
  • You will get another 5 minutes to discuss the exam with your classmates. You can talk, move around, ask questions, but you should NOT answer any questions yet.
  • At 10:10 you can go back to your computer and begin the test. You can use notes, the internet, books, and any materials you’d like. The only rule is DO NOT communicate with anybody, in person or online, during the test after this point.
  • The review will be Monday December 2nd. As usual, you will have to bring your own questions. A short review will also be provided to you during class for practice.
  • Review

Portfolio

Students are encouraged to create an online portfolio to highlight their work, knowledge, and achievements. Your web portfolio must consist of a website (you can use WordPress, Wix, Drupal, or other free web building tools and templates). This will award you 10% extra credit at the end of the semester. To receive full credit, your portfolio should contain the following:

  1. A professional looking picture. Don’t spend on this, use your career services department, or take one with your phone.
  2. A professional looking URL. The domain is free with some web building tools but it has a few restrictions (e.g. you can have a free domain that looks like this: firstnamelastname .wordpress.com)
  3. A link to an updated LinkedIn profile.
  4. A short paragraph describing your career goals (i.e. pursue a master’s degree, work for X or Y firm or company).
  5. A section or a list with the projects you are most proud of. These should be full projects, and can and should contain those which are done as part of your academic coursework, whether it is for this class or others

If there are any personal reasons or privacy concerns for which you would prefer not to create your online portfolio come talk to me and an alternative extra credit will be assigned. If you are taking another class with me, the same portfolio provides extra credit for all classes, provided information about the projects performed in that class is included.

Additional Guidelines

  1. No late assignments will be accepted. Please turn in assignments as-is before the deadlines to prevent a cascading effect where you are never able to catch up. Any grade is better than zero grade.
  2. The midterm and final exams are open book, open notes, and you can use the internet to search for information, however, you cannot communicate with your classmates or anyone else in any way online or otherwise. The tests will require coding and will contain quit a few of our “morning questions”, in-class coding exercises, and homework assignments.
  3. Homework will be assigned, however, it will not be graded. You will be able to receive feedback by using some automated tools. Remember, versions of this problems, whether verbatim or with slight variants will appear on your exams.

One-on-One Meetings

Schedule a time to meet with me to wrap up the semester. Slots are first-come-first-serve. I want to hear from you, ask you questions about your work for this class and assignments, and give you the chance to ask one-on-one questions. We will also discuss your grades. This will be during class time, in the classroom (for the most part). Due to the limited time there will be no rescheduling or make up appointments. Time is very limited so be punctual. This is not mandatory, but it is in your best interest. f you have to schedule after class, we will meet at the tables next to the small cafeteria inside the third floor of the business building, where the doors face the library. Sign in here.

Survey

Accessibility

If you feel you may require special accommodations for any reason, please contact the Center for Accommodations and Support Services (CASS) at 747-5148, go to Union Bldg., East, Room 106, or e-mail cass@utep.edu.

Troubleshooting XAMPP

You may run into additional issues after installing it. Here is how to fix them:

On a Mac: When opening XAMPP, go to the Volumes tab, click on mount, then explore. This will open your folders, go to etc/extras and find the file named http-.conf. Open the file with a text editor. Find the line that says “Require local” and switch it to “Require all  granted”.

On Mac: When MySQL doesn’t start: http://www.areyoucodingenough.com/programming/solution-mysql-database-doesnt-start-xampp-mac-os-x/

On Mac or Windows, when a port is unavailable: https://stackoverflow.com/questions/11294812/how-to-change-xampp-apache-server-port

On Mac: MySQL quits unexpectedly: https://stackoverflow.com/questions/18022809/xampp-mysql-shutdown-unexpectedly

Mac Permission for htdocs: https://www.axfon.com/how-to-xampp-vm-htdocs-directory-permission-on-mac-os/ (Thanks Enrique!)