| 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 of June 3rd |
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). 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: Normalization - information on third normal form Separate speaker notes for normalization presentation 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 |
| Assignments Week #2 Week of June 10th |
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. Continuing with relational databases, 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 Assignment: Oracle assignment on introductory material |
| Assignments Week #3 Week of June 17th |
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 Look at the presentations suggested last week with more emphasis on the Oracle code: 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 Try to make sure you have a firm understanding of the concepts of a relational database design, normalization etc. Start to look at the notes and presentations on functions - the topic for next week. Assignment: Implementing your oil design |
| Assignments Week #4 Week of June 24th |
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 Assignment: Oracle quiz - must be passed in next week Oracle create, query and maintain assignment with functions |
| Assignments Week #5 Week of July 1st |
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) Assignment: Oracle assignment on subqueries and variables. Quiz: Second quiz |
| Assignments Week #6 Week of July 8th |
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 Please start to read the information on indexes and keys and the other information about SQL. Next week we will do more with keys and indexes and we will start PL/SQL. Assignment: Assignment on views and reports |
| Assignments Week #7 Week of July 15th |
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. Assignment: Assignment on keys |
| Assignments Week #8 Week of July 22nd |
It is hard to cover all of the material in the summer - especially since Monday
was a late start. Please try to stay with me as we keep pushing along! Please read the following: Introduction to PL/SQL More examples of inner/outer procedures Introduction to IF statements More on PL/SQL IF statements Introduction to loops Also please look at the accompany presentations: Introduction to PL/SQL Separate speaker notes for Introduction to PL/SQL 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 Assignment: Indexs, Constraints and PL/SQL IF statements and LOOPS Looking ahead to the notes on data manipulation might help with the extra credit. |
| Assignments Week #9 Week of July 29th |
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 Assignment: 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 #10 Week of August 5th |
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 Assignment: Multiple cursor assignment |
| Assignments Week #11 Week of August 12th |
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 Required Project: Final project |
| Assignments Week #12 Week of August 19th |
Please start looking at the notes
on Developer. No assignments related to Developer! Continue working on project! The pace in the summer moves faster, so... the project can be passed in a few days after the final if you clear it with me! Check back final will be posted this week! |
| Assignments Week #13 Week of August 26th |
The final must be passed in 4:00 on Monday, August 26th. All students must take the
final whether or not they will complete the course on time. The final is given on
the honor system and I trust you to respect that - the only person you can discuss
the final with is me! If you have not passed in the final by 4:00 on Monday, August 26th, points will be subtracted. The status sheet is a requirement of the course - it is also your insurance to make sure that you and I have the same information - I will contact you if there is a problem! Please send me the final using the usual email address and also send a copy to me at pgrocer@bristol.mass.edu. Final Exam Status Sheet - required If you need a little extra time to complete the work, let me know. The summer involves the same amount of work with less time so I will be as flexible as I can. However, if something is going to be late, we must have agreed via email or penalty points will be taken from your grade. |