| 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 >>
|
|
641 Week 4 Outline
Posted on 9/13/2026) by Liping Liu
(641 Week 4 Outline) Review of Forward Engineering Rules
Where do you create foreign keys for 1:m relationships? Are FK values required?
Where do you create foreign keys for m:m relationships? Are FK values required?
Where do you create foreign keys for 1:1 relationships? Are FK values required?
How do you transform weak entities and associative entities?
Lecture 1: Grammatical Analysis for Business Data Modeling: nouns for objects or attributes and verbs for relationships
Modeling Exercise 1: Insure-A-Person Inc... more >>
|
|
324 Week 4 Outline
Posted on 9/13/2026) by Liping Liu
(324 Week 4 Outline) Review Questions:
How to handle multi-valued attributes in data modeling
How to handle data on relationships in data modeling
Course and Sections (why splits), Course and Prerequisites (Two entities or one?), Grade (where to store it), how do you handle minimum grade required for prerequisites?
Lecture 1: Advanced Data Modeling (Continue)
4) What about entities that are different but similar? (Chapter 3 of LIU)
Super and sub type entities: How to handle different types of entities that have many attributes in common, e... more >>
|
| Post |
