Netside where knowledge is shared, ideas are spread.

[Notes] CSCI 585 DB Relational Modeling

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

outline

  • That the relational database model offers a logical view of data
  • About the relational model’s basic component: relations
  • That relations are logical constructs composed of rows (tuples) and columns (attributes)
  • That relations are implemented as tables in a relational DBMS
  • About relational database operators, the data dictionary, and the system catalog
  • How data redundancy is handled in the relational database model
  • Why indexing is important

[Notes] CSCI 585 DB Entity Relationship (ER) Modeling

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

Online

  • The main characteristics of entity relationship components
  • How relationships between entities are defined, refined, and incorporated into the database design process
  • How ERD components affect database design and implementation
  • That real-world database design often requires the reconciliation of conflicting goals

[Notes] CSCI 567 ML lec1 KNN and ML system

Credit to: Prof. Yan Liu, CSCI567, Spring 2020

Outline

  • Course Overview
  • ML overview
  • General setup for multi-class classification
  • Nearest Neighbor Classifier (NNC)
  • Some theory NNC

[Notes] CSCI 585 DB Data modeling

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

Outline

  • Data modeling and importance
  • Basic data-modeling building blocks
  • Business rules and the influence towards database design
  • Evolution of major data models
  • Emerging alternative data models and the need they fulfill
  • models classified by their level of abstraction

[Notes] CSCI 585 DB Introduction

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

Outline

  • Data V.S. Information
  • Database, types of databases, and why they are valuable assets for decision making
  • Importance of database design
  • How modern data bases evoled from file systems
  • Flows in file system data menagement
  • DB system components
  • DBMS main functions