| Assignments | Link to retrieve |
|---|---|
| Assignments unless otherwise noted are do the week after they are posted! | |
| Assignments Week #1 Week of September 2nd |
Student survey - must be sent to me! You should take this time to get a copy of Oracle if you are working on a computer outside the labs. You can use 7.3, 8 or 8i. You can get a copy of the book with software that is optional for this course at: Book and software The name of the book is Enhanced Guide to Oracle 8i w/Oralce Developer Kit Software, 2e (see syllabus for more information). You need to install the Personal Oracle 8i. Please see Ernie Nicholson for a login password etc if you plan to use Oracle at BCC. To give you some time to get a copy of Oracle installed, we are going to deal with the theory of relational databases this week. If you are without access to Oracle, please let me know what your problem is so we can try to get you up and running! Please read information about third normal form and relational databases. I have put a variety of links to sources on the Web on the site and some below. Please read the handout on definitions: Normalization definitions Also view the slide presentation on normalization and a new one I added on additional information about relational databases: Normalization - information on third normal form Separate speaker notes for normalization presentation Relational database information - information on 1 to 1, 1 to M, and M to M Separate speaker notes for relational database information Other examples can be found at my web site under Notes and handouts for related topics. References: Lesson #1 in a series, be sure to go to lesson #2 Information about relational databases and normalization from Microsoft More information on normalization and design Links to information on relational databases Very complete and more advanced reference Taking it further Another source Assignment: Set up relational database for an oil company Note this should be done a design only - it should not be done using Oracle Note: Please note that I have put up additional notes that might help with this assignment - they are under Notes and handouts for related topics and I have also added a PowerPoint presentation (see above) or look under the first category of presentations. |
| Assignments Week #2 Week of September 9th |
Note: Please note that I added some examples and another PowerPoint presentation to
last weeks list of things to look at. They are things that might help in doing the
assignment. Read the notes and study the presentations for: Introduction to SQL in Oracle, Create a table in SQL, SQL Conditions and start reading Working with SQL. This information will carry over into next week! Notes: Introduction to SQL in Oracle Create a table in SQL SQL Conditions Working with SQL Presentations: Introduction to SQL in Oracle Separate speaker notes for Introduction to SQL in Oracle Create a table in SQL Separate speaker notes for Create a table in SQL SQL Conditions Separate speaker notes for SQL Conditions Working with SQL Separate speaker notes for Working with SQL Note the first few slides in Working with SQL show login procedures using scott and tiger. Assignment: Oracle assignment on introductory material |
| Assignments Week #3 Week of September 16th |
I suggest that you read chapter #1 in the text for more information about relational
databases since we will be returning to that topic - probably next week when we
set up multiple tables. I also suggest that you read chapter #2 in the text. If you are having problems with the installation, go to this site: Instructions for loading Oracle I have passwords for students who want to use BCC labs - if you were not in class on Friday, you need to send me an email asking for your userid and password. These are the notes that I will attempt to get through this week. I still have a little left last week, so I may not complete everything. More on maintaining an SQL table SQL functions More SQL functions Group SQL functions You should also look at the accompanying PowerPoint presentations: More on maintaining an SQL table Separate speaker notes for More on maintaining an SQL table SQL functions - part 1 character Separate speaker notes for SQL functions - part 1 characters SQL functions - part 2 numeric & date Separate speaker notes for SQL functions - part 2 numeric & date More SQL functions (includes DECODE, ways to edit SQL code and nested functions) Separate speaker notes for more SQL functions Group functions Separate speaker notes for group functions Assignments: Oracle quiz for in class day students, this will be started in class Oracle create, maintain and query assignment Information: Oracle sites are: Source for installation help - unofficial Another unofficial source of information For Windows ME users, the site addresses the common errors and issues and their workarounds. You can also go to the Oracle site for information on free downloads - in the past there has been some issues with the free version (saving was a problem with one of them). Anyway you might find 9i works better with XP - some students have downloaded 9i and seem to be satisfied. to download My modem burned out during the thunder storm so I have been off line for a couple of days. I received lots and lots of messages and I am working on getting caught up. |
| Assignments Week #4 Week of September 23th |
Please read the following information about relational databases in Oracle. Introduction to multiple tables (relational) - joins Relational database examples Look at the relational examples in these presentations: Relational database notes and examples Goes with notes Introduction to multiple tables (relational) - joins - uses donor, donations and drive tables Separate speaker notes for relational database presentation Normalization - information on third normal form Separate speaker notes for normalization presentation Relational database examples - order system Separate speaker notes for relational database examples - order system Student system relational database example Separate speaker notes for student system relational database example I am not sure how far we will get this week, so be sure to check back to find out if we moved beyond this! Assignments: Quiz #2 (if you are coming to class, we will start the quiz there) Implement your oil design |
| Assignments Week #5 Week of September 30th |
I am not sure whether we will make it through all of this information this week - if
we don't, we will pick up where we left off next week. Please read the following information about subroutines, maintenance etc. Subqueries More on subqueries Using input variables More on variables with Oracle's SQL*Plus Table maintenance revisited (again) Continuation of table maintenance revisited (again) Exporting an Oracle table You should also look at the presentation on these topics especially the one that accompanies More on subqueries. Subqueries Separate speaker notes for subqueries More on Subqueries Separate speaker notes for More on subqueries Using Input Variables Separate speaker notes for Using Input Variables More on variables with Oracle's SQL*Plus Separate speaker notes for More on variables with Oracle's SQL*Plus Table maintenance revisited (again) Separate speaker notes for Table maintenance revisted (again) Continuation of table maintenance revisited (again) Separate speaker notes for Continuation of table maintenance revisted (again) NOTE:I was overly ambitious - only made it through variables (in fact may not completely finish those handouts). The Table maintenance and forward will be dealt with next week! Assignments: Quiz #3 Will be started in class if you are an in class student - distance learning students obviously are on their own! Assignment (mostly on subqueries) |
| Assignments Week #6 Week of October 7th |
Note that I have added a new category on the home page for CIS50 called supplementary
instructor notes. Under this topic you will find some notes from Vijay Kukreja (the
night instructor) on dates and null. The dates problem is also covered in the
PowerPoint. As mentioned last week - I did not get to the file maintenance listed last week, so it will be covered this week. Please finish the information about table maintenance from last week and read the information on views and reports. Introduction to views Introduction to reports You should also look at the accompanying presentations: Introduction to views Separate speaker notes for Introduction to views Introduction to Reports Separate speaker notes for Introduction to reports I was able to look at the following on views: More on views You should also start looking at indexes, keys etc. We will cover them in more detail next week. Assignments: Assignment including views and reports |
| Assignments Week #7 Week of October 14th |
Please read the following: Indexes in Oracle - An introduction More on Primary and Foreign keys Notes on key questions Also please look at the accompanying presentations: Indexes in Oracle - An Introduction Separate speaker notes for Indexes in Oracle - An Introduction More on Primary and Foreign Keys also info from questions Separate speaker notes for More on Primary and Foreign Keys etc. Assignments: Assignment on keys |
| Assignments Week #8 Week of October 21st |
We will finish SQL this week so please read the rest of the notes and look at the
rest of the presentations. Start reading the introductory handout on PL/SQL and look at the PowerPoint presentation! Introduction to PL/SQL More examples of inner/outer procedures Introduction to PL/SQL Separate speaker notes for Introduction to PL/SQL Assignments: No assignments this week! Work off the web site, I will be away at a conference on Thursday the 24th of October and Friday the 25th of October so there will be no inclass classes those days. |
| Assignments Week #9 Week of October 28th |
Please read the following: Introduction to IF statements More on PL/SQL IF statements Introduction to loops Also please look at the accompany presentations: PL/SQL - Using IF statements Separate speaker notes for PL/SQL - Using IF statements More on PL/SQL IF statements Separate speaker notes for More on PL/SQL IF statements Introduction to loops Separate speaker notes for Introduction to loops As always, check back and see how far we actually got! Assignments: Assignment on constraints This is another one of the quizzes that can be discussed with other classmates. First PL/SQL Quiz |
| Assignments Week #10 Week of November 4th |
Please read the following notes and watch the slide presentations. Data manipulation in PL/SQL - introduction Record and table types Data manipulation in PL/SQL - introduction Separate speaker notes on Data manipulation in PL/SQL - introduction PL/SQL User Defined Types - record and table Separate speaker notes for PL/SQL User Defined Types - record and table This week we will finish dealing with types and introduce cursors. Introduction to Cursors We may go further with cursors so either check back or continue looking at the cursor information available on the web. Assignments: Assignment using loops and cursors |
| Assignments Week #11 Week of November 11th |
Because I was out sick Thursday, we have some catch up to do. We will look at the handout
on record and table types and continue looking at the handouts on cursors. Please note
that there is a Smartboard explanation of one of the cursor examples. Please read the following notes and watch the slide presentation. Example 1 using cursors Continuing example 1 using cursors Another set of cursor examples Covers: Cursors in PL/SQL, cursor example and continuation of first cursor example Separate speaker notes for Cursors in PL/SQL, cursor example and continuation of first cursor example Covers: Another set of cursor exampes Separate speaker notes for Another set of cursor examples No new assignments this week! |
| Assignments Week #12 Week of November 18th |
Please go over the cursor notes that I listed for last week!
The next topics are exceptions, procedures, and triggers. Please read the notes
and look at the PowerPoint presentations. We will spend the next couple of weeks
on this topic. Introduction to functions Internal procedures More on internal procedures and functions Still more on procedures and functions Introduction to triggers More on triggers Introduction to PL/SQL Functions Separate speaker notes for Introduction to PL/SQL Functions More on Procedures - Internal Procedures Separate speaker notes for More on Procedures - Internal Procedures Introduction to Triggers Separate speaker notes for Introduction to Triggers More and Still More on Procedures and Functions Separate speaker notes for More and Still More on Procedures and Functions More on Triggers Separate speaker notes for More on Triggers Assignments: Multiple cursor assignment Oracle Project - due the last day of classes Survey: Survey that needs to be returned to me |
| Assignments Week #13 Week of November 25th |
We will continue with the topics listed last week. No new assignments! |
| Assignments Week #14 Week of December 2nd |
We will continue with the topics listed two weeks ago - we are almost done! We will start looking at the notes on Developer. No assignments related to Developer! Quiz will be next week - I was out sick for a day. |
| Assignments Week #15 Week of December 9th |
Assignment:
Last quiz The final exam must be passed in by December 20th at 3:15. It must be accompanied by a status sheet. The final and status sheet should be emailed to me at the standard address you have used this semester and also to pgrocer@bristol.mass.edu. If you do not pass in the final by December 20th at 3:15, you must show up to take the final at that time. Note that the final is given using the honor system - you may not discuss the final with anyone but me - I trust you to do the right thing! Also note that the final and the status sheet have to be done by everyone - even if you plan to take an incomplete in the course. See schedule for when I will be on campus during break. |