| Assignments | Link to retrieve |
|---|---|
| Assignments unless otherwise noted are do the week after they are posted! | |
| Assignments Week #1 Week of January 20th |
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 January 27th |
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 February 3rd |
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 If you want a password to use the BCC labs for Oracle, you need to send me a request via email. They are available using scott/tiger but this will get you a personal login. 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 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. Go to the Oracle site for information on free downloads. 9i works better with XP. to download |
| Assignments Week #4 Week of February 10th |
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 Assignments: Quiz #2 Implement your oil design |
| Assignments Week #5 Week of February 17th |
Subqueries More on subqueries Using input variables More on variables with Oracle's SQL*Plus This material should be started, but will be continued next week: 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 This material should be started, but will be continued next week: 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) Assignments: Quiz #3 Assignment (mostly on subqueries) |
| Assignments Week #6 Week of February 24th |
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 March 3rd |
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 March 10th |
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 Start looking at the IF notes and presentations. Assignments: Assignment on indexes and constraints |
| Vacation Week of March 17th | Catch up time! |
| Assignments Week #9 Week of March 24th |
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: This is another one of the quizzes that can be discussed with other classmates. First PL/SQL Quiz |
| Assignments Week #10 Week of March 31st |
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 Continue looking at the cursor information available on the web. Assignments: Assignment using loops and cursors |
| Assignments Week #11 Week of April 7th |
Look at record and table types as well as cursors. 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 Assignments: Multiple cursor assignment |
| Assignments Week #12 Week of April 14th |
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: Oracle Project - due the last day of classes |
| Assignments Week #13 Week of April 21st |
We will continue with the topics listed last week. No new assignments! |
| Assignments Week #14 Week of April 28th |
Look at the notes on Developer. No Developer assignments! Assignment:Last quiz Final will be available at the end of the week! |
| Assignments Week #15 Week of May 5th |
The final exam must be passed in by May 15th. 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.
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 unless we have made other arrangements. Final Exam Required Status SheetMust be turned in by the final |