Mojahed Ibrahim

Here is a nice reference reading on the differences between database queries and OLAP – http://homepage.cs.uri.edu/faculty/hamel/pubs/hamel-197-manuscript-final.pdf

Click here for instructions on the inclass exercise.

If you get an error message that you are not permitted to alter or delete or update a table in the SQL Assignment, following the following steps:

Close your My SQL Workbench. Open it again and before you open […]

Click here for a copy of the presentation slides. We’ll cover this in weeks 6-7.

In this lecture, we’ll discuss the concepts of analytical databases and data cubes, and learn how to create a data cube from […]

Consider a database (HRData) with the following tables:

Faculty(ID, FirstName, LastName, Title, DepartmentID, BuildingID, Phone, Email)

Department(DeptartmentID, DepartmentName)

Building(BuildingID, […]

Consider a database (HRData) with the following tables:

Faculty(ID, FirstName, LastName, Title, DepartmentID, BuildingID, Phone, Email, Awards)

Department(DeptartmentID, […]

Click here for class captures by date:

September 24, 2011

September 26, 2011

September 28, 2011

To access password protected posts, please check the blackboard for the password.

Using the moviedb database, answer the following questions:

1. List the actors who starred in the oldest movie?

2. Which movie has been rented the maximum number of times?

2a Also, list all customers who […]

Assignment: SQL #2 Putting Data Into a Database

Click here for a copy of the assignment. This is due on Wednesday – October 3, 2012. Please submit a printout of your answers at the beginning of class.

Click here for instructions on the inclass exercise. Please make sure to note your MySQL login and password from the gradebook before coming to the lab.

Pls note the following office hours for the SQL 1 assignment.

1. I have my office hours after class today from 3-4pm in Speakman 201 E

2. The TA will have office hours in Alter Hall 603 (Laptop Lab) tomorrow […]

Think for about 100 seconds what you learnt in class during week 5 and summarize your thought here.

Click here for class captures by date:

September 17, 2011

September 19, 2011

September 21, 2011

Think for about 100 seconds what you learnt in class during week 4 and summarize your thought here.

Click here for a copy of the presentation slides.  We’ll cover this in week 5.

In this lecture, we’ll discuss the use of Structured Query Language (SQL) to performs operations related to creating and deleting […]

Assignment: SQL (Getting Data out of the Database) – Due Date 9/26/2012

For this assignment, you will be working with the same movie rental database as your in-class exercise. The schema is also the same, so […]

Think for about 100 seconds what you learnt in class during week 4 and summarize your thought here.

Click here for instructions on the inclass exercise. Also, you can view the complete schema of the database here.

Of the two ERD in-class exercises, we could complete only one. To receive 0.5 pts bonus points, draw an ERD for the business scenario described in the other in-class exercise (click here for the link). Also […]