Introduction, Data Modeling (ongoing)

Wrap up week1 databases lecture & tutorial

This lecture aims to understand the knowledge of conceptual data modelling, and develop database design, and explain how to communicate about the db design.
I've learned database at my bachelor's degree in computer science in Korea.
What I've learned in previous lectures are totally different. In this unit, we use CSDP (Conceptual schema Design Precedure) which I've never heard before.

Basic concept of data, information system, information, database

What is the difference between Database and DBMS(Database Management Systems)

Data modelling

Universe of Discourse (UoD)

Database Architecture

• External Level
• Conceptual Level: the logical level
• Internal Level

What is the Conceptual Schema

• Conceptual schema is a consistent collection of sentences expressing the necessary propositions that hold for a UoD
  (e.g., Employee works in Department, each Student is enrolled in on Course.
• It is a high-level description of a business's informational needs.
• The thress components are
  1. Basic fact types of entities (e.g., employee, student)
  2. Relationships (e.g., works in, enrolled in)
  3. Constraints (validation/integrity rules) and derivations (rules/functions that allow new facts to be inferred)
  * sources from QUT

Conceptual Schema Design Procedure

STEP1.
Transform familiar examples into elementary facts, and apply quality checks.