In-class Examples List
CS 325 - Database Design
Section 10 - CRN 41088 - M 9:00am-10:20am
Fall 2021
Last modified: Monday, January 10, 2022
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, Labs, December 10, 2021 - Project Demonstrations/Presentations
(remember, noted in class that these would be recorded,
but that these recordings would not be posted)
- Week 15 Asynchronous Material
- As discussed during Week 15, Lecture 1, the asynchronous material
for Week 15 consists of three sets of
auto-graded short-answer questions, now available on
the course
Canvas site, under
Modules,
in the Class Recordings section.
- These questions are worth 2 points each, and your scores on these
will be added to your semester clicker grade.
- Set 1: Final Exam Review clicker questions
not reached during Week 15 Lecture 1's Final Exam Review
- Set 2: Questions on locking approaches to concurrency control,
to give you an idea of how I might
ask questions about them on the Final Exam.
- Set 3: Questions on the timestamping approach to concurrency control
that we discussed, likewise
to give you an idea of how I might
ask questions about this on the Final Exam.
- Week 15, Lecture 1, December 6, 2021 -
a few words, and some discussion, on databases, society, and ethics;
review for Final Exam
- Week 14, Labs, December 3, 2021 - announcements, followed by a
lab exercise
- Week 14 Asynchronous Material
- (Zoom recordings available on course Canvas site,
under Modules, in Class Recordings section)
- Continuing transaction
management and concurrency control, part 2
- Demos of some useful SQL date- and time- and string-related
functions, to help create attractive reports
- Week 14, Lecture 1, November 29, 2021 - starting Transaction
management and concurrency control - part 2
- Week 13, Labs, November 19, 2021 - announcements, followed by a
lab exercise
- Week 13 Asynchronous Material
- (Zoom recordings available on course Canvas site,
under Modules, in Class Recordings section)
- Part 1 - Intro to transaction
management and concurrency control, part 1
- Part 2 - Demos of some useful SQL*Plus features for modifying some
of SQL*Plus' default settings, to help create attractive reports
- Week 13, Lecture 1, November 15, 2021 - Exam 2
- Week 12, Labs, November 12, 2021 - optional, for asking questions
about Homework 9 (since Week 12 Asynchronous Material was not
posted)
- (Was not able to record and post Week 12 Asynchronous
Material - sorry!)
- Week 12, Lecture 1, November 8, 2021 - Exam 2 Review
- Week 11, Labs, November 5, 2021 - announcements, followed by a
lab exercise
- Week 11 Asynchronous Material - continuing converting an ER model
to a database schema/design, part 2: association entity classes,
weak entity classes, recursive relationships, multiple relationships
between two entity classes; also SQL ANSI join notation/syntax,
example of a three-table join, intro to SQL views
- Week 11, Lecture 1, November 1, 2021 - started Basics of Database
Design - Part 2 - converting supertype/subtype entity classes
into appropriate tables
- Week 10, Labs, October 29, 2021 - announcements, followed by a
lab exercise
- Week 10 Asynchronous Material - continuing converting an ER model
to a database schema/design, part 1; also more SQL set-theoretic
operations, intro to SQL
update and delete
statements
- Week 10, Lecture 1, October 25, 2021 - converting an ER model to
a database schema/design, part 1
- Week 9, Labs, October 22, 2021 - announcements, followed by a
lab exercise
- Week 9 Asynchronous Material - continuing intro to
normalization; also more SQL
select statement
clauses: order by, group by, and
having
- Week 9, Lecture 1, October 18, 2021 -
started intro to Normalization
- Week 8, Labs, October 15, 2021 - announcements, followed by a
lab exercise
- Week 8 Asynchronous Material - intro to
the
union operator; also database
security, part 2: & and interactive input,
and intro to SQL injection
- Week 8, Lecture 1, October 11, 2021 - Exam 1
- Week 7, Labs, October 8, 2021 - no class, instructor
at conference - study for Exam 1, work on Homework 5 and project scenario
selection milestone
- Week 7 Asynchronous Material - intro to SQL
nested selects/sub-selects; also intro to projecting
literals, and concatenating columns and literals;
also intro to
exists
and not exists predicates (and correlation conditions)
- Week 7, Lecture 1, October 4, 2021 - Exam 1 Review
- Week 6, Labs, October 1, 2021 - announcements, followed by a
lab exercise
- Week 6 Asynchronous Material - continuing intro to the
Entity-Relationship Model (E-R Model), part 2;
also demos of SQL computed columns, column aliases,
table aliases, and aggregate functions
- Week 6, Lecture 1, September 27, 2021 -
Introduction to the Entity-Relationship Model (E-R Model),
part 2
- Week 5, Labs, September 24, 2021 - announcements, followed by a
lab exercise
- Week 5 Asynchronous Material - continuing intro to the
Entity-Relationship Model (E-R Model), part 1:
identifiers and relationships;
discussion of maximum cardinalities and minimum cardinalities.
Also discussion of SQL
select statement
basic syntax and semantics, more where-clause options,
examples combining several relational operations in a single
select statement, and more
- Week 5, Lecture 1, September 20, 2021 -
introduction to the Entity-Relationship Model (E-R Model),
part 1: basic ideas, intro to entities and attributes
- Week 4, Labs, September 17, 2021 - announcements, followed by a
lab exercise
- Week 4 Asynchronous Material - continuing intro to the relational
model, including intro to the most important relational
operations; also quick demos of using SQL
select statements
for doing those most-important relational operations
- Week 4, Lecture 1, September 13, 2021 - started intro to the
relational model
- Week 3, Labs, September 10, 2021 - announcements, followed by a
lab exercise
- Week 3 Asynchronous Material - more database fundamentals,
and also discussion of DDL/DML/DCL that a DBMS should provide
- (No class Week 3 Lecture 1, September 6, 2021 - Labor Day
Holiday)
- Week 2, Labs, September 3, 2021 - announcements, followed by a
lab exercise
- Week 2 Asynchronous Material -
continuing intro of basics of Oracle SQL and SQL*Plus
- Week 2, Lecture 1, August 30, 2021 - intro to database
processing and development
-
Week 2 Lecture 1 projected notes
- files from small file-processing-based-approach vs.
database-processing-approach example
- files with different categories of restaurants
-
cheap-restaurants.txt - a plain-text file
listing restaurants with inexpensive entrees, and
what city they are in
-
have-burgers.docx - a Word-docx file
listing restaurants that serve burgers,
what city they are in, and their phone numbers
-
pizza-available.ods - a Open-Document-Spreadsheet
file
listing restaurants that have pizza available,
what city they are in, and their street address
-
sandwich-shops.odt - a Open-Document
file
listing restaurants that have sandwiches available,
their phone number, and info about their open hours
- SQL scripts creating a little restaurants table
and inserting some initial restaurants
(and a fave menu items table, but not populated)
and showing how to ask some example questions about those
restaurants
-
DB Reading Packet 1 - Database processing and development
(in tagged PDF)
- Week 1, Labs, August 27, 2021 - lab exercise
logging into nrs-projects,
trying out the course submission tool
~st10/325submit,
and accessing Oracle and writing a first SQL script
- Week 1 Asynchronous Material -
a little about databases, DBMSs, and application programs;
intro to basics of Oracle SQL and SQL*Plus
- Week 1, Lecture 1, August 23, 2021 - intro to course
Back to Course Home Page