In-class Examples List
CS 325 - Database Design
Fall 2016
Last modified: Monday, December 12, 2016
Important Notes:
- This is merely a selection of files and examples, most of which were
mentioned or used in the class (lectures and labs). It is not a
comprehensive
list, nor are all lectures and labs included. Formatting is generally
minimal.
- Week 15, Lecture 2, December 8, 2016 - Final Exam Review
- Week 15, Labs, December 7, 2016 - Project Demonstrations/Presentations
- Week 15, Lecture 1, December 6, 2016 - discussion about
tomorrow's project demonstrations/presentations;
a few words (and some discussion) on databases, society, and ethics
- Week 14, Lecture 2, December 1, 2016 - a few words on
optimistic methods for concurrency control; intro to
PL/SQL and PL/SQL triggers
- Week 14, Labs, November 30, 2016 - a selection of SQL*Plus
time- and date- and string-related functions (nice
for query and report use)
- Week 14, Lecture 1, November 29, 2016 - Intro to transaction
management and concurrency control, part 2, continued
- Week 13, Lecture 2, November 17, 2016 - Intro to transaction
management and concurrency control, part 2; discussion of
bonus opportunity (see projected notes)
-
Reading packet - Transactions and concurrency management, part 2
(in tagged PDF)
Week 13, Labs, November 16, 2016 - SQL*Plus
commands for simple reports/modifying SQL*Plus'
default settings
-
set-up-ex-tbls.sql - script setting up some of the
example tables used in 325lab13-1.sql and 325lab13-2.sql
- In-lab projections for 11:00-12:50 lab
- In-lab projections for 3:00-4:50 lab
-
cleanup.sql - SQL script to restore
various SQL*Plus settings that a script creating
an ASCII report might muck with (as suggested by
T. Koyuncu)
-
SQL Reading Packet 8 - simple reports - part 2
(in tagged PDF)
Week 13, Lecture 1, November 15, 2016 - Intro to transaction
management and concurrency control, part 1, continued
Week 12, Lecture 2, November 10, 2016 - Intro to transaction
management and concurrency control, part 1
Week 12, Labs, November 9, 2016 -
reminder of SQL update and delete;
a few words on the alter command;
intro to sequences; intro to views
(including how views and the grant command
can help enhance database security)
Week 11, Lecture 2, November 3, 2016 - Exam 2 Review
Week 11, Labs, November 2, 2016 - set-theoretic operations
union, intersect, and minus
Week 11, Lecture 1, November 1, 2016 - Basics of Database Design -
Part 2 - converting supertype/subtype entity classes into relations
Week 10, Lecture 2, October 27, 2016 - converting an ER model to
a database schema/design, part 1, continued
Week 10, Labs, October 28, 2016 - more SQL select statement
clauses: order by, group by, and
having
Week 10, Lecture 1, October 25, 2016 - converting an ER model to
a database schema/design, part 1
Week 9, Lecture 2, October 22, 2015 - intro to Normalization,
continued
Week 9 Labs, October 19, 2016 - projecting literals;
concatenating columns and literals; and
more on nested selects/sub-selects, including intro to
exists
and not exists
Week 9, Lecture 1, October 18, 2016 - intro to Normalization
Week 8, Lecture 2, October 13, 2016 - database
security, part 2: & and interactive input,
and intro to SQL injection; also more nested select
examples, and some discussion of how many questions
can be answered more than one way using SQL!
Week 8 Labs, October 12, 2016 - intro to SQL
nested selects/sub-selects (and one example of a 3-table join)
Week 7, Labs, October 5, 2016 - in-lab reviews
of project model sub-milestone 2
Week 7, Lecture 1, October 4, 2016 - Exam 1 Review
Week 6, Lecture 2, September 29, 2016 -
Introduction to the Entity-Relationship Model (E-R Model),
part 2; brief in-class reviews of
of project model sub-milestone 1
Week 6, Labs, September 28, 2016 -
More where-clause options, column and table aliases,
computed columns, aggregate functions, and more
Week 6, Lecture 1, September 27, 2016 -
Introduction to the Entity-Relationship Model (E-R Model),
part 1,
continued: maximum and minimum cardinalities;
also some discussion of course semester projecct
Week 5, Lecture 2, September 22, 2016 -
Introduction to the Entity-Relationship Model (E-R Model),
part 1,
continued: attributes, identifying attributes,
relationships
Week 5, Labs, September 21, 2016 -
Writing relational operations using the SQL
select statement
Week 5, Lecture 1, September 20, 2016 -
a few more words about joins, and
introduction to the Entity-Relationship Model (E-R Model),
part 1: basic ideas, and intro to entities and entity
classes
Week 4, Lecture 2, September 15, 2016 - Intro to the relational
model continued - including intro to the most important
relational operations
Week 4, Labs, September 14, 2016 - playing with the SQL
grant and revoke statements;
giving some examples of how Oracle supports different kinds
of integrity; examples of simple versions of the SQL
update and delete statements
Week 4, Lecture 1, September 13, 2016 - Intro to the
relational model
Week 3, Lecture 2, September 8, 2016 - more database fundamentals,
continued
Week 3 Labs, September 7, 2016 - intro to SQL and SQL*Plus,
continued, including adding some more domain constraints
Week 3, Lecture 1, September 6, 2016 - more database fundamentals
Week 2, Lecture 2, September 1, 2016 - intro to database
processing and development, continued - AND more
intro to SQL and SQL*Plus
Week 2 Labs, August 31, 2016 - practice logging into nrs-projects,
practice using the course submission tool
~st10/325submit,
and accessing Oracle
Week 2, Lecture 1, August 30, 2016 - intro to database
processing and development
Week 1, Lecture 2, August 25, 2016 - demo'd public course web site
and course Moodle site; brainstormed some course project
scenarios; started introducing basics of SQL
(Structured Query Language)
Week 1, Labs, August 24, 2016 - intro to UNIX needed for
this course (since nrs-projects not yet ready for this
semester)
Week 1, Lecture 1, August 23, 2016 - intro to course
Back to Course Home Page
Please send questions to:
sharon.tuttle@humboldt.edu
