Information Retrieval Concepts (COP-4703)

Professor: Alex Roque
E-mail: aleroque@fiu.edu
Office Hours: By Request

NOTE: If a request needs to be made to meet before class, please let me know at least a day in advance. If a request is sent to meet on the day of the request, I will only be able to meet after the class session for a limited time.

Syllabus: (DOCX)(PDF)

Important Dates

8/21 First Day of Class
8/28 NO CLASS
9/4 Labor Day
10/4 Project Work Day NO CLASS
10/9 Group Project Phase 1 Due
10/11 Quiz 2 - Chapt3, Chapt4, Chapt 5
10/16 Midterm
10/18 NO Class: Project 2 Time
11/1 ONLINE LECTURE
11/6 Quiz 3- Chapt 5, Chpt 6
11/15 ONLINE LECTURE
11/20 Quiz 4- Chapt7, Chapt 8, Chapt 9
11/22 Thanksgiving Online Lecture-NO CLASS
11/27 Project Presentations
11/29 NO CLASS: Project Due Electronically
12/4 Final

Lectures

Lecture 1 Intro to DB Management (PPT)(PDF) / Lecture 2 Relational Model, QBR, Relational Algebra (PPT)(PDF)
Lecture 3 The Relational Model 2: SQL (PPT)(PDF)
Lecture 4 The Relational Model 3: Advanced Topics (PPT)(PDF)
Lecture 5 Database Design 1: Normalization (PPT)(PDF)
(Midterm Review)
Lecture 6 Database Design 2: Design Methodology (PPT)(PDF)
Lecture 7 DBMS Functions (PPT)(PDF)
Online Lecture: Mimic a Lock With Transactions.pdf (PDF)
Online Lecture: SQL Server- The Transaction Log.pdf (PDF)
Online Lecture: The ROLE OF A DBA (PDF)
Lecture 8 Database Administration (PPT)(PDF)
Database Health Monitoring (PDF)
Lecture 9 DB Management Approaches (PPT)(PDF)
Class Presentations / Lecture: Review for Final Exam here

Topics/Sample Scripts

Chpt. 2 SQL Script Example (Chapt2.sql)
Create and Modify Your Own data. (DOC)
Create Table Example (CreateTableExample.sql)
Grouping Example (GroupingExample.sql)
Join Query Example (JoinQueryExample.sql)
Lecture 3 SQL Practice Script (Chapt3.sql)
Lecture 4 SQL Practice Script (Chapt4.sql)
Relational Algebra Examples (RelationalAlgebra.sql)
SQL User Defined Functions.(DOC)
Stored Procedure Example (StoredProcedure.sql)
Stored Procedure Assignment (procedure.sql)
Trigger Example (Trigger.sql)
Normalization Example (NormalizationExampleChpt5.docx)
Normalization Example 2(NormalizationExample2.docx)
Example of a SQL Transaction and a lock being acquired by the database.(Lock1.sql)(Lock2.sql)

Tools

We will be using Microsoft SQL server technologies throughout the course. Download the free version of SQL Server, SQL Server Express which is its free limited database with tools.

SQL Server Express 2016

I've created a documented detailing the installation of SQL Server Express 2016 with screenshots. Please review the document if you are having problems.
Loading Data Into Sql Server
Running Scripts

Installation Videos

Database Install
SQL Tools Install
Create DB and Test
Connect to Azure DB (Optional)

If you are having problems with the installation of 2016, try to install the 2014 version. Sql Server Express 2014

The SQL Express you want to download is the one described as Express with Tools (SQLEXPRWT). If you see a file list, choose the one for computer's architecture (x86/64) and find the SQLEXPRWT file name.

SQL Server Express with Tools (with LocalDB, Includes the database engine and SQL Server Management Studio Express)

After installing SQL Server Express, create your first database. Here is a video to help.

All SQL examples performed in class will be mostly standard SQL, but keep in mind Oracle and MySQL have slight differences in some syntax.

ER Diagrams: You can use Dia for your ER Modeling or better yet ,if you have an educational license, you can use Visio.

SQL Scripts for Database example used in Book and Lectures

Practice Work

Extra Credit

HW 0. Self-Introduction, worth 5 points. Due 3rd week on Monday, printed at the beginning of class.
DOCX

Group Project

Group Project Phase 1 DOCX
Group Project Phase 2 DOCX

Group

M2 Data Wolfpack
Group Pelaez
Group Nolasco
Database(d) Gods
Unicorn
Group Hidalgo
Group DLG