Post |
|
Reading: The Rise of the Relational Model
Posted on 8/13/2025) by Liping Liu
(Reading: The Rise of the Relational Model) The Rise of Relational Databases by National Science Foundation
Large-scale computer applications require rapid access to large amounts of data. A computerized checkout system in a supermarket must track the entire product line of the market... more >>
|
|
Syllabus for ISM 602: Programming for Data Analytics
Posted on 8/13/2025) by Liping Liu
(Syllabus for ISM 602: Programming for Data Analytics) Instructor: Dr. Liping Liu, College of Business Administration Building 360, 330-972-5947, liping@uakron.edu
Text Books:
Tilman M. Davies, The Book of R: A First Course in Programming and Statistics, No Starch Press, 2016... more >>
|
|
641 Week 2 Outline
Posted on 8/13/2025) 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 >>
|
|
641 Week 1 Outline
Posted on 8/13/2025) by Liping Liu
(641 Week 1 Outline) Concept of Database:
Database is a set of records well organized using a particular logical data model
Records: A records is an array of observed characteristics (or attributes) on one object (entity)
Well Organized: 1) related records are connected; 2) no unnecessary redundancy
Logical Data Models: Hierarchical, Network, Relational
Database Development Process
Data Modeling: Entity, Attribute, relationships
Database Implementation: DBMS
CASE Tool: Oracle Data Modeler
Terminology Confusion: logical model = conceptual model, relational model = logical model
How to draw entities, create attributes, and refine relationships using Oracle Data Modeler
Data Modeling: Identify Objects, Attributes, and Relationships
Identify Objects: (1) objects can be tangible such as a customer or intangible such as an account or meeting; (2) objects must be observable at an instant in time; (3) objects must have multiple attributes (or dimensions) to be observed... more >>
|
|
324 Week 1 Outline
Posted on 8/13/2025) by Liping Liu
(324 Week 1 Outline) Concept of Database:
Data, Information, and Knowledge
Database is a set of records well organized using a particular logical data model
Records: A records is an array of observed characteristics (or attributes) on one object (entity)
Well Organized: 1) related records are connected; 2) no unnecessary redundancy
Logical Data Models: Hierarchical, Network, Relational
Database Development Process
Data Modeling: Entity, Attribute, relationships
Database Implementation: DBMS
Data Modeling (Bank Example: Customers, Accounts, and Transactions): Identify Objects, Attributes, and Relationships
Identify Objects (entities): (1) objects can be tangible such as a customer or intangible such as an account or meeting; (2) objects must be observable at an instant in time; (3) objects must have multiple attributes (or dimensions) to be observed... more >>
|
|
Syllabus for ISM 641: Database Management
Posted on 8/13/2025) by Liping Liu
(Syllabus for ISM 641: Database Management) Instructor: Dr. Liping Liu, College of Business Administration Building 360, 330-972-5947, liping@uakron.edu
Textbooks:
Thomas M. Connolly and Carolyn E... more >>
|
|
Syllabus for ISM 324: Data Management
Posted on 8/13/2025) by Liping Liu
(Syllabus for ISM 324: Data Management) Instructor: Dr. Liping Liu, 360 CBA Building, +5947, liping@uakron.edu
Credits: 3 hours
Text Books:
John L. Viescas. SQL Queries for Mere Mortals, 4th Edition, Addison-Wesley Professional, 2018... more >>
|
|
Get Started with Database Management
Posted on 8/13/2025) by Liping Liu
(Get Started with Database Management) Welcome to the Data Management course! Due to its hands-on nature, this course will be be delivered in in-person mode with occasional online access.
Here is a list of necessities you need to complete before your first class:
1) UA Zip ID, via which you can access campus resources such as downloading licensed software (e... more >>
|
|
Get Started with Application Development
Posted on 8/13/2025) by Liping Liu
(Get Started with Application Development) Welcome to the all-new world of Computer Programming and Applications Development.
To get started, here is a list of basic necessities:
UA Zip ID, via which you can access campus resources such as downloading licensed software (e... more >>
|
|
Syllabus for ISM 315: Applications Development
Posted on 8/13/2025) by Liping Liu
(Syllabus for ISM 315: Applications Development)
Instructor: Dr. Liping Liu, CBA 360, 972-5947
Time and Location: 1:00 – 3:15 PM on Mondays and Wednesdays, August 25 – December 7, 2025... more >>
|
|
324 Week 2 (Labor Day Week) Outline
Posted on 8/13/2025) by Liping Liu
(324 Week 2 (Labor Day Week) 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 >>
|
|
Get Started with R Programming for Data Analytics
Posted on 8/13/2025) by Liping Liu
(Get Started with R Programming for Data Analytics) Welcome to Data Analytics with R! Due to its hands-on nature, this course will be delivered in in-person mode with occasional online lessons.
To get started, here is a list of basic necessities:
1) UA Zip ID, via which you can access campus resources such as downloading licensed software (e... more >>
|
|
Where Is China Heading?
Posted on 7/5/2025) by Liping Liu
(Where Is China Heading?) This essay is transcribed and translated from "中国向何处去?" authored by Professor Liu Meixun at Chinese Tsinghua University (清华大学教授 刘美珣) with sections restructured and section titles added... more >>
|
Post |