4.08 > PHP-MySQL Interface & 3rd Task

4.08 > DBMS lectures & practices

1st task /feb-mar/ > ~done

  • wordpress impl&demo? > description?
  • wp actuality? > published? presented?

2nd task /mar-apr/ > ~ done?

  • Acquaintance with SQL, MySQL, PHP, phpMyAdmin, etc.?
    • 10 actual SQL queries demo with PHPMyAdmin? published?
    • SQL test? /colloquium~+/
  • PHP elements demo? published? published >  > 3.18 lectures & practices
  • PHP-MySQL junction demo? published? description? > 3.18 lectures & practices
  • PHP-MySQL interface demo? published? description?  > 3.18 lectures & practices

NEW > 3d task /apr-may/

  • Actual DB Theme selection (what online Database you would like to create?),
  • Facts finding (establishing database needs),
  • > Database planning (DB requirements, req. analysis, conceptual model, relational model),
  • Database realization, demo, publishing results and workflow description.

DBMS theory /for the 3rd Task realisation/

  • Fact finding /slides/ > here > for 4.15
  • E-R modeling /slides/ > here > for 4.22
  • DB normalisation /slides/ > here > for 4.29
  • Other sources > Db. Sol. [pdf, ppt] > Db. Sys. [pdf]

4.08 > Database plan creation /step by step example/

  1. Database theme? (what Database you would like to create?)
  2. DB requirements
    1. Example I. The lecturer decided to make a simple (one table) database of Erasmus students. In the database should be stored student’s name and first name. It is important to be aware of where the student came from (country, University). 
    2. Example II. A database needed in which students data (name, second name), students university data (name, country) and main data about selected subjects (name, credits) could be stored.
    3. etc.
  3. DB requirements analysis
    1. Objects (Entities) /really > sets of objects/
    2. Attributes /~/
    3. Relations (between Entities)
  4. DB conceptual model
  5. DB Relational model

IMPORTANT > conversion rules /CM  to RM/

  1. Conversion Rules /from conceptual to relational model/
    • Objects > turn into Tables
    • Object Attributes > turn into Fields of relevant Tables
    • Relations between Objects > turn into Relations between Fields of Tables [depending on the type of relation < IMPORTANT]
      • 1-1 > this relation in Relational model turns into
        • relation between Primary Keys of Tables
      • 1-* > this relation turns into Relational model during these two phases
        • in  * Table additional field (foreign Key) should be created.
        • then Relation between Primary and Foreign Keys should be established.
      • *-* > this relation turns into Relational model during these two phases
        • additional 3rd Table should be created
        • foreign keys should be created in this 3rd table
        • relations between relevant Primary and Foreign Keys should be created.

Terms & Questions

==================================================================

  • Table /properties/
    • name_1 / column-field / row-record / cell / primary_key / foreign_key / data_type /
    • usually Database has several related Tables
  • Main Relationships /examples?/
    • one to one /1-1/
    • one to many /1-*; *-1/
    • many to many /*-*/

========= About published results & colloquium results analysis ===================~

  • published results /being processed/
  • 1st colloquium test results /being processed/