-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Consider a database (HRData) with the following tables:
Faculty(ID, FirstName, LastName, Title, DepartmentID, BuildingID, Phone, Email, Awards)
Department(DeptartmentID, […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
To access password protected posts, please check the blackboard for the password.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
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 […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
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.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
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.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
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 […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Think for about 100 seconds what you learnt in class during week 5 and summarize your thought here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Click here for class captures by date:
September 17, 2011
September 19, 2011
September 21, 2011
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Think for about 100 seconds what you learnt in class during week 4 and summarize your thought here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
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 […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
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 […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Think for about 100 seconds what you learnt in class during week 4 and summarize your thought here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Click here for instructions on the inclass exercise. Also, you can view the complete schema of the database here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
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 […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
We’ll be using the MySQL Workbench utility (client) to connect and interact with a MySQL server database. The MySQL workbench is available on the classroom netbooks.
This document explains:
How to set up […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Due Date : September 19: note that the syllabus mentions the due date of September 17.
Assignment: ER Modeling
Create an ER model for the following two scenarios. Make sure that you read the description […] -
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Go to community.mis.temple.edu/gradebook – click here
Login using your Accessnet username and password
If the gradebook does not show any grades
Confirm with your professor that a grade has been entered […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
- Load More