| Post |
|
ISM 324 Syllabus — 2027 Revision
Posted on 10/31/2026) by Liping Liu
(ISM 324 Syllabus — 2027 Revision) Course Information
Database Management for Information Systems · ISM 324-001 (3 credits) · The University of Akron · Undergraduate · In person · Fall 2027
Meetings: Mondays and Wednesdays, 3:30–4:45 PM, CBA 176 (computer lab)... more >>
|
|
641 Week 10 Outline
Posted on 10/26/2026) by Liping Liu
(641 Week 10 Outline) Review:
1. Find employees who make more than all managers
2. Find the maximum average salaries of all departments
3. Find the number of columns in EMP table
4... more >>
|
|
ISM 602 Week 7 Outline
Posted on 10/10/2026) by Liping Liu
(ISM 602 Week 7 Outline) Review
Gamma regression from last week: positive, right-skewed response; log link; constant dispersion; exp(b) - 1 as a percentage effect
The three unifying features of generalized linear models (slides): a linear predictor, a random component from the exponential family, and a link function
Deviance, residual deviance, and deviance residuals carry over unchanged; only the family and the link change this week
Discuss the gamma regression multiple-choice questions
Box-Cox Transformation and smearing factors
Required Packages and Data: ROCR, default... more >>
|
|
ISM 602 Week 6 Outline
Posted on 10/6/2026) by Liping Liu
(ISM 602 Week 6 Outline)
Review
assumptions of linear regression
how to interpret regression results of summary() and plot
Required Packages and Data: MASS, caret, homes.csv
Three Unifying Features of Generalized Linear Models (slides)
Which model works for predicting which business variables (slides)
Assumptions of gamma regression: gamma response, independent cases, constant dispersion, and no collinearity
Comparisons of OLS and MLE
Concept of MLE:
computing likelihood and log likelihood of gamma variable observations y = c(10, 15, 3, 19) or y = homes$totalvalue
comparing which model parameters improve the likelihood alpha=1, beta=1, alpha=1, beta = 2, ... more >>
|
|
641 Week 7 Outline
Posted on 10/4/2026) by Liping Liu
(641 Week 7 Outline) Lecture 1: Basic SQL DML Statements
Preparation: Creating sample Oracle tables using scripts from script loader on ecourse.org and Lookup tables using dictionaries (user_tables, user_constraints, user_cons_columns)
Running an Oracle Script... more >>
|
|
641 Week 6 Outline
Posted on 9/27/2026) by Liping Liu
(641 Week 6 Outline) Homework Review:
1) HW3-4 Review
2) Identify the functional dependencies in the following tables and then states whether each one is in 1st normal form and 2nd normal form or not... more >>
|
|
641 Week 5 Outline
Posted on 9/18/2026) by Liping Liu
(641 Week 5 Outline) Lecture 1: Normalization (Chapter 11 of LIU)
Criteria for a good database design
Issues with data redundancies
The concept of normalization
Functional dependency: Tables 1 and 2
First Normal Form: Tables 3
Second Normal Form: Tables 1 and 5
Third Normal Form: Author Editor Example and Job Class Example
Lecture 2: Normal Forms
Third Normal Form: Table 6
Boyce-Codd Normal Form
Additional Examples:
Assume a customer can make several loans, with or without other partners... more >>
|
|
324: Review I for Database Midterm on 9-23-26
Posted on 9/16/2026) by Liping Liu
(324: Review I for Database Midterm on 9-23-26) Concepts:
Databases
DBMS
Logical Data Models
Hierarchical Models
Network Models
Relational Models
Primary key
Foreign Key
Referential Integrity Rules
Entities
Relationships
Mapping Cardinality
Optionality
Attributes
Composite Attributes
Multi-valued Attributes
Relations
Relational Models
Recursive Relationships
Weak Entities
Super and Sub Entities
Gerund
SQL
Constraints
Oracle Meta Tables
Oracle Data Types
Skills and Techniques:
Conceptual Data Modeling (Entity-Relationship Diagramming) from the understanding of business objects and their relationships or from forms, reports, tables, and other data carrier to understand data requirements... more >>
|
| Post |
