Welcome to ecourse.org: the Information Infrastructure for Education in the information age! This system allows instructors from any school or college (including home schools and training programs) to teach either onsite or online courses . It allows students to manage all their ongoing school works and past academic records at one location.
Our mission is to redefine the model of learning and re-engineer its process by providing innovative administrative and instructional technologies. Click here for our beliefs.
What is your opinion?
Could another species someday replace us as Earth's dominant intelligent life and, if so, which species?
(641 Week 5 Outline) (by Liping Liu) 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 Week 3 Outline) (by Liping Liu) Review on Business Data Modeling:
How do you handle composite 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
Lecture 1: Advanced Entities and Relationships
1) What if relationships have data or attributes? (Chapter 3 of LIU)
Associative Entities or Gerunds: where to keep students grades, Where do you store data on whether a payment is late or not? Bank employees may set up or modify accounts... more >>
This system is designed and developed by Professor Liping Liu with financial support from Southern Illinois University at Carbondale. It evolved from a prior version called CourseWeb (for courses prior to Year 2000) and UXTEND.COM and www.e-course.org.
