weinberg

A few people have emailed me about question 7 in the lab and have indicated that they have received a parent key error.  We discussed this in class a few times including last Tuesday and Thursday.  If you note, the last question on the lab is VERY similar. We will discuss for a few moments […]

As we discussed in lab, for lab 2 you should write your insert statements and then run at the SQL prompt.  Then runs your describe command at the SQL prompt.  Copy your command and the output into the appropriate space on the word document.  For the last 2 questions you are only answering the question […]

As we discussed in class on Thursday, exam 1 has been rescheduled to 10/7.  Please see the calendar on blackboard.  We will be starting lab 3 on Thursday

I am considering pushing exam 1 back 1 week.  We’ll vote in class today

As I said last week and the prior week,  for the Describe section, in SQL plus run the describe command for each table and run it.  Copy it and paste into the word document.  I can tell you created the tables, added the attributes, and set the null/not null from the command. For the alter, […]

After we work on Santa’s workshop we may have time to start the singer DB.  Please bring this with you to class.

If you are trying to install Oracle on Windows 7 and your SQL plus dialog disappears after you enter your login, try loading the SQL developer toolkit as described in my directions.  I have been able to access oracle successfully through the SQL Developer Toolkit even though the SQL plus application is not functional.

I have received confirmation that the Oracle client is in the Tech Center. Please log on with your access net username and password (you don’t need your MIS account).  It is supposed to be available on all the PCs. You can find the program listed under instructor software and foxes

Hey Class, Here are the list of MIS 2502 Tutors from AMIS: Please note that you HAVE to be an AMIS member in order to receive free tutoring. This is a service offered to our valued AMIS members. In order to become a member please e-mail: Eric Enders (eric.enders@temple.edu) or visit an AMIS meeting on Wednesdays, 12-12:50PM at […]

Intro to SQL

Since we did not review the alter commands and constraints, I have extended the due date. As I said in class on Thursday, we will discuss these briefly next Thursday and you should have some time to work on your lab. Please see the calendar on bb. Please do read the book prior to next […]

Final Exam Study Guide

Exam 2 study guide

Exam 1 study guide spring 2010

Please note I have added a new link to blackboard for the class captures.  They will appear automatically shortly after class is completed.

Please look at the gradebook on blackboard to verify you have been assigned an oracle username and password and an MIS username and password.

Instructor Information Cindy Marselis cindy.joy.marselis@temple.edu Office Hours T 11:15 – 12:15 Speakman Hall 209 Section  003 CRN:  047514 Lecture Alter 032 Lab A602 & A603 T, R 12:30 – 1:50 PM Book Database Design and Development Simplified.  Second Edition  Marselis Available only through the publisher online.  Order through the following website: http://tumis2502.cengagesites.com […]