Database Management (Spring 2020 – CIS 4365)

ANNOUNCEMENTS

This class is transitioning to a full online course for the rest of the semester. Our class sessions will be conducted via Blackboard Collaborate. Attendance will now become part of your grade.

To learn how to use Blackboard Collaborate check the following video, you can find it under the tools section:

Please note that for full features it is recommended to take these sessions in a laptop or desktop, and not on a mobile device as some screen sharing features may not work properly. Also note that Blackboard recommends using Google Chrome as your web browser.

COURSE DESCRIPTION

The course introduces students to issues related to database and database management systems (DBMS). Students gain technical backgrounds in planning, analysis, logical design, physical design, implementation, and maintenance of a database. Students are provided hands-on training in data base design, development, and implementation using a relational DBMS software. Emphasis is placed on the problems and issues of managing in a data base environment.

Syllabus

Spring 2020
CRN 21474
Contact: igris@utep.edu
Meeting Times: MW 10:30 AM -11:50 AM ~~BUSN 304~~ ONLINE
Office Hours: By appointment only
Book: Modern Database Management
Recommended software: XAMPP

Grading

Evaluation	Grade
Midterm	20%
Final	20%
Project 1 (Entity Relationship)	10%
Project 2 (MySQL)	10%
Project 3 (Data Management)	10%
Project 4 (PHP)	30%
Portfolio	+5%

Class Schedule

Week	Topic	Notes
1	Introduction	Course goals and content; Localhost setup
2	Databases	Relational DBMS
3	Entity Relationship	Entities and attributes
4	Intro to SQL	Create, alter, insert, update, delete
5	Data Collection	Data collection and organization
6	Advanced SQL	Joins, primary and foreign keys
7	SQL Functions	Min, max, avg, mode, and frequency
8	Midterm and Review	April 8th (Blackboard)
9	PHP MySQL Connection	Connect to database with PHP
10	Data Management	Data bias, statistics, risk assessment
11	Web Technologies	Client side vs. server side
12	Database Administration	Sanitation, security, best practices
13	Final Review	May the 4th be with you
14	Final Exam	May 15th (Blackboard) 10:00 am – 1:00 pm

Important Dates

January 20th – Dr. Martin Luther King, Jr. Holiday – University Closed
February 12th – Project 1 (Entity Relationship) Due
February 26th – Project 2 (MySQL) Due
March 16th and 20th – Spring Break
March 27th – Cesar Chavez Holiday – No Class
April 3rd – Spring Drop/Withdrawal Deadline
April 6th – Midterm Review
April 8th – Midterm
April 15th – Project 3 (Data Management) Due
May 2nd – Final review
May 8th – Project 4 (PHP) Due
May 8th – Portfolio due date
May 8th – Dead Day
May 15th – Final Exam (Blackboard) 10:00 am – 1:00 pm

Readings

Week 1 (Syllabus)
Week 2 (1 – 16)
Week 3 (36 – 42)
Week 4 (65 – 84)
Week 5 (245 – 263)
Week 6 (292 – 315)
Week 7 (264 – 283)
Week 12 (466 – 486)

Homework

Class CODE & SLIDES

Introduction (Week 1 Slides)
Databases (Week 2 Slides)
Entity Relationship Diagrams (Week 3 Slides)
Intro to MySQL (Week 4 Slides)
Data Collection Techniques (Week 5 Slides)
Advanced MySQL Joins (Week 6 Web Reference)
MySQL Aggregate Functions (Week 7 Web Reference)
Midterm Review (Week 8)
PHP and MySQL Connection (Week 9 Code)
Data Management (Week 10 Slides)
Web Technologies (Week 11)
Data Analytics (Week 12)
Database Administration (Week 13)
Final Review (Week 16)

Projects

Links lead to the project rubric and description. They should all be submitted through Blackboard in their appropriate sections.

EXAM Policy

The midterm will be on March 25th, the final exam will be Friday May 15th at 10:00 am.
Exam will be in Blackboard. 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.
All topics in the course schedule will be covered.
~~You will get 2 minutes to read the exam. You should only read for those few minutes, and NOT answer any questions yet.~~
~~You will get another 3 minutes to discuss the exam with your classmates. You can talk, move around, ask questions, but you should NOT answer any questions yet.~~
After this 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.
There will be reviews. As usual, you will have to bring your own questions. A short review may also be provided to you during class for practice.

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:

A professional looking picture. Don’t spend on this, use your career services department, or take one with your phone.
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)
A link to an updated LinkedIn profile.
A short paragraph describing your career goals (i.e. pursue a master’s degree, work for X or Y firm or company).
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.

Class Guidelines

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.
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 quite a few of our “morning questions”, in-class coding exercises, and homework assignments.
Homework will not be graded. Versions of this problems, whether verbatim or with slight variants will appear on your exams.
Projects will be graded, each containing its own rubric materials. Read the rubric!
Projects will only be graded if they are submitted through Blackboard within the given time-frame.

Contact and Office Hours

Email: Send them to my UTEP email with the exact header CIS4365-FirstName-LastName. Emails are automatically filtered, not adhering to this syntax may cause your email to be lost in my inbox.

Office hours: I do not have an office at UTEP, which makes scheduling somewhat complicated. You are welcome to schedule an appointment and visit me at the Boost Human office downtown (500 W Overland, Ste 230). Please do not drop by unannounced as I may not be there or available.

Individual 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. If 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. The sign in sheet will appear as we approach the end of the semester.

Class Feedback

Please remember to give feedback about the course. As we approach the end of the semester, you will receive an online survey from UTEP about this class, make sure you respond!

During the first week of class please answer the following survey to get a sense on where the class stands. Survey link.

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.

XAMPP Troubleshooting

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/