| Assignments | Link to retrieve |
|---|---|
| If you can manage to get ahead of the posted weeks, you will have more time at the end of the summer to work on the project and the final! | |
| Assignments Week #1 Week ending January 27th |
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. A site to download is: Oracle downloads 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 see Ernie Nicholson for a login password etc if you plan to use Oracle at BCC. If you plan to install Oracle at home, get in touch with me if there are problems. 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. Oracle assignment on introductory material |
| Assignments Week #2 Week ending February 1st |
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. Please read the handout on definitions: Normalization definitions Also view the slide presentation on normalization: Normalization - information on third normal form Separate speaker notes for normalization presentation For futher information look at the design aspects of the following presentations - we will deal with the Oracle code later. 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 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 Set up relational database for an oil company |
| Assignments Week #3 Week ending February 8th |
I am having trouble with my email - be sure to keep a copy of everything you
send me and check back if you do not hear from me! We will continue with the design of a relational database. I have decided to delay the implementation of the relational database until next week and cover functions now! Please read the following information about tables and functions. SQL functions More SQL functions Group SQL functions You should also watch the presentations on these topics: 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 Oracle quiz - must be passed in late next week There are two assignments in week #4 - you might start the first one this week! I did no a little rearranging to give more time on the oil design - hopefully the topics for week #3 and week #4 can be finished by the beginning of week #5! |
| Assignments Week #4 Week ending February 15th |
We will finish functions and then start the multiple tables - the goal is to finish by the end of
the week but it could still go over into week #5! Assignment: Oracle create, query and maintain assignment with functions 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 the presentations from last week. Read the following information about maintaining a table and view the accompanying presentation. More on maintaining an SQL table More on maintaining an SQL table Separate speaker notes for More on maintaining an SQL table Do the following assignment: Implementing your oil design |
| Assignments Week #5 Week ending February 22nd |
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) Assignment: Oracle assignment on subqueries and variables. Quiz: Second quiz |
| Assignments Week #6 Week ending March 1st |
I was overly optimistic last week - I did not get through the maintenance revisited or
the continuation of it, so... 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 Assignment on views and reports If we do not finish views and reports, this assignment will be the first of next week! |
| Assignments Week #7 Week ending March 8th |
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. No assignment this week! |
| Assignments Week #8 Week ending March 15th |
We will finish SQL this week so please read the rest of the notes and look at the
rest of the presentations. Assignment on constraints 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 Week #9 Week ending March 29th |
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 PL/SQL IF statements and LOOPS Looking ahead to the notes on data manipulation might help with the extra credit. |
| Assignments Week #10 Week ending April 5th |
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 Introductory assignment on cursors and type table This is another one of the quizzes that can be discussed with other classmates. First PL/SQL Quiz (also quiz #3) |
| Assignments Week #11 Week ending April 12th |
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 Multiple cursor assignment Check back! |
| Assigments Week #12 Week ending April 19th |
Please read the notes and view the presentations on procedures, functions and triggers. 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 Project: Final project due the last day of classes! For those that actually get it in on time there is extra credit! I hope this clarifies any misreading! |
| Assignment Week #13 Week ending April 26th |
We will start looking at the notes
on Developer. No assignments related to Developer! Continue working on project! Note, if you use a set of tables that already has constraints, indexes, keys etc. then you are going to loose some points for not creating them - the goal is to do this a second time and make sure you are comfortable with it! You can add some others constraints and add some other tables to cover this! Let me clarify - everyone must do a project and it is due the last day of classes. Those who meet this due date will get extra credit! Check back for date final will be posted. Please note that I had a very serious problems with my email today (4/24). I think I finally got everything, but if you sent me something today and I do not get it back to you sometime next week, please send me an email asking if I got it. |
| Assignment Week #14 Week ending May 3rd |
Continue looking at the notes on Developer and working on the project! |
| Assignment Week #15 Week ending May 10th |
Continue working on the project! |
| Final Exam - Due May 14th 4:00 | The final exam must be passed in by May 14th at 4:00. 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 May 14th at 4:00, 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. Final Exam Status Sheet - Required |