Proposed Syllabus for ISM 420: Artificial Intelligence for Business Posted on 10/27/2024) by Liping Liu
(Proposed Syllabus for ISM 420: Artificial Intelligence for Business) Instructor: Dr. Liping Liu, 360 CBA Building, +5947, liping@uakron.edu
Credits: 3 hours
Text Books:
Stuart Russel and Peter Norvig, Artificial Intelligence - A Modern Approach, Pearson; 4th edition (May 13, 2021)
Liping Liu, Lecture Notes on Artificial Intelligence
Time and Location: Mondays and Wednesdays: 3:30-4:45 PM; August 26-December 10, 2025... more >>
Proposed Syllabus for ISM 427: Deep Learning from Business Data Posted on 10/27/2024) by Liping Liu
(Proposed Syllabus for ISM 427: Deep Learning from Business Data) Instructor: Dr. Liping Liu, 360 CBA Building, +5947, liping@uakron.edu
Credits: 3 hours
Text Books:
Manel Martínez-Ramón, Meenu Ajith, and Aswathy Rajendra Kurup, Deep Learning--A Practical Introduction, John Wiley & Sons, 2024... more >>
641 Week 7 Outline Posted on 10/12/2024) by Liping Liu
(641 Week 7 Outline) Warm-Up Queries:
Find the employment year of each employee
Find the departments in Dallas
Find the salesmen who were hired after 1980
--Find menagers whose name ends with M
select enamefrom empwhere job = 'MANAGER' and ename like '%M';
--Give salesman 100 commission
update empset comm = comm + 100where job = 'SALESMAN';
--handle missing values
upate empset comm = 0where comm is null;
select 12*sal + commfrom empgroup by empno;
--use nvl(comm, 0)
update empset comm = nvl(comm, 0) + 100where job = 'SALESMAN';
Lecture 1: Intermediate SQL Programming: Join
implicit join (outer and inner), Explicit Join: inner join, left join, right join, full outer join (or cross join)
Find all the employees located in Dallas
Find all employees and their associated departments
Find all departments and their associated employees
Explicit Joins
Just like + operation in arithmetics to combine two tables, may be used in parentheses for nested combination of more than two tables
Syntax: TableA join TableB on (criterion to join)
three explicit Join types: left, right, inner
Equivalent to implicit joins (e... more >>
324: Review I for Database Management Posted on 9/16/2024) by Liping Liu
(324: Review I for Database Management) 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/15/2024) 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: nouns for objects or attributes and verbs for relationships
Modeling Exercise 1: Insure-A-Person Inc... more >>
Proposed Syllabus for ISM 250: Introduction to Information Systems and Artificial Intelligence Posted on 9/10/2024) by Liping Liu
(Proposed Syllabus for ISM 250: Introduction to Information Systems and Artificial Intelligence) Assumptions for the proposed Syllabus:
Course Number is ISM 250, indicating the course may be taken in parallel to ACCT 250
Since we are going to get rid of 420, and so I add two weeks on data networking and security to this course... more >>
324 Week 4 Outline Posted on 9/9/2024) by Liping Liu
(324 Week 4 Outline) Review Questions:
How to handle multi-valued attributes
How to handle data on relationships
Memorize ERD ==> RM Rules
Course and Sections (why splits), Course and Prerequisites (Two entities or one?), Grade (where to store it), minimum grade required for prerequisites
Lecture 1: SQL
Programming Languages: non=procedural and 4th generation
SQL consists of:
DDL (Data Definition Language) -- used to create, modify, and delete database objects such as tables, views, accounts, indices, triggers, stored procedures and functions, etc... more >>
Intall ROracle Package for Windows and Mac OS Posted on 9/8/2024) by Liping Liu
(Intall ROracle Package for Windows and Mac OS) Since ROracle package comes as a source code, its installation requires compilation. The installation is further complicated due to requiring Oracle client. Also, for Mac OS, fix_oralib... more >>
641 Week 2 Outline Posted on 9/7/2024) by Liping Liu
(641 Week 2 Outline)
Review:
Homework Question to Review
Database Concepts:
A record is an array of observations on one entity: Entity (ERD) <—> Record (RM)
Attributes are properties or dimensions of entities (business objects) to be observed, but attributes must be relevant, singled valued, and non-foreign... more >>
324 Week 2 Outline Posted on 9/7/2024) by Liping Liu
(324 Week 2 Outline) Review:
Homework Question to Review
Database Concepts:
A record is an array of observations on one entity: Entity (ERD) <—> Record (RM)
Attributes are properties or dimensions of entities (business objects) to be observed, but attributes must be relevant, singled valued, and non-foreign... more >>
324 Week 3 Outline Posted on 9/7/2024) by Liping Liu
(324 Week 3 Outline) Review on Business Data Modeling:
How do you handle composite attributes?
How do you handle multi-valued attributes?
Verb describing relationships and Need to Track Related Records
data on actions may be recorded and so to turn action verbs into objects
Customer buys products
Student reserve books
Orders contains products, direct or indirect relationships?
Employees balance inventories, direct or indirect relationships?
Employee manage accounts
Doctors prescribe tests
Professors teach students
Customers wish-list products
Customers rate Products
Professors advise Students
Patrons checkout Books
Additional Advanced Entities and Relationships: 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 >>
641 Week 3 Outline Posted on 9/6/2024) by Liping Liu
(641 Week 3 Outline) Review: Course and Sections (why splits), Course and Prerequisites (Two entities or one?), Grade (where to store it), minimum grade required for prerequisites
Lecture: 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 >>