Interaction Design III
		Next

Interaction Design III

Niels Müller Larsen

This work is licensed under the Creative Commons Attribution 3.0 License. To view a copy of this license, visit http://creativecommons.org/licenses/by/3.0/ or send a letter to Creative Commons, 559 Nathan Abbott Way, Stanford, California 94305, USA.

2011-10-29

Table of Contents

Preface Niels Müller Larsen

Interaction?
Literature
3rd Semester Interaction Outline (Databases on the Web)
Who Am I
Introduction to the course

1. Data Modelling - ER

References for this lesson
High Level Design Criteria
Entity Relationship Modelling
Assignments/Exercises

2. Databases and PHP Practicum 1

References for this lesson
PHP Refresher
Reading from the Database
Assignments

3. ER modelling - cont.

References for this lesson
Cardinality
Participation
Key Concepts og Concepts of Keys
Weak Entities
N-ary Relationships
N-ary? Is that what we really want?
Opgaver

4. Databases and PHP Practicum

References
Working on the CMS
Reading the Database, Again
Assignments

5. Enhanced ER modelling

References for this lesson
EER Specialization and Generalization
Assignments

6. Databases and PHP Practicum - III

References
What Kind of Help? FAQ/OSS
Select-declaration and order
Select and numbers
Select from more than one table
Assignments

7. EER cont.

References for this lesson
EER Relationships of a Higher Order
Aggregations
Assignments

8. Databases and PHP Practicum - IV

References for this lesson
Today: INSERT
Assignments
Assignment 8.2 a more thorough hint

9. The Relational Model

References for this lesson
Introduction
Structure and Essential Definitions
Integrity, Constraints
Manipulation, Operators
Relational algebra
Assignments
Assignments

10. Database and PHP Practicum - 5

References
Model solutions

11. SQL Schema and Data Types

References
Datatypes
Create table
Changes and Control
SELECT
Assignments

12. Databases and PHP Practicum - 6

References
Transformation

13. SQL Data

References
Today we shall have a look at the SQL Data declarations
Insert
Select
Update
Delete
Assignments

14. Databaser og PHP i praksis

Pensum
Først info om eksamen og prøveeksamen

15. Normalisation

References
Design Theory
Functional dependencies
1NF - 1st Normal Form
2NF - 2nd Normal Form
3NF - 3. Normal Form
BCNF - Boyce-Codd Normalform
Assignments

16. Databases and PHP Practicum - 8

Pensum
Next on SQL Data - Indlejrede selects
Final words (for now) on SQL Data - Views
Assignments

17. Teori Afrunding

Pensum
Recap af 3 semestre, 1 - 2
Recap af 3 semestre, 2
Recap af 3 semestre, 1 - 2
Recap af 3 semestre, 3

18. Transforming our ER model into Relational Model Database

Pensum
A 9 Step Algorithm
Trin 1: Behandling af alle ordinære entiteter
Trin 2: Behandling af alle svage entiteter
Trin 3: Binære 1:1-relationer
Trin 4: Binære 1:N-relationer
Trin 5: Binære N:M-relationer
Trin 6: Flerværdiattributter
Trin 7: N-ære relationer
Trin 8: Specialiseringer/Generaliseringer
Trin 9: Aggregeringer

A. The Client/Server Model

Architechture
What Happens Where?
WWW som client/server
Technology in three tiers

B. Setting Up 3 Tier Client Server Environment

Apache, MySQL, PHP

Literature

List of Figures

1. Example of an ER Model
2. Example of a CMS Page
3. Assignment 0.0 - Solution
4. Assignment 0.1
1.1. A simple ER diagram
1.2. Degrees of Relationships
1.3. Attributes
3.1. Cardinalities in an ER diagram
3.2. Diagrams with participatory constraints
3.3. Diagram with weak entity
3.4. Multivalued attribute replaced by weak entity.
3.5. Relationships of a higher order
3.6. Examples of ternary relationskhips from an educational establishment.
5.1. The Entities in Question
5.2. The Generalization
5.3. Super/sub in More Layers
7.1. The Illegal ER Model
7.2. Solving the ternary problem
7.3. The "Legal" ER Solution
9.1. Schematical Overview
11.1. A simple ER-diagram as a model
18.1. Input til første skridt
18.2. Input til andet skridt
18.3. Input til tredje skridt - Bjørns metode
18.4. Input til tredje skridt - fremmednøglemetoden
18.5. Input til fjerde skridt - Alternativt design
18.6. Input til fjerde skridt - Bjørns metode
18.7. Input til femte skridt
18.8. Input til syvende skridt
18.9. Input til ottende skridt
18.10. Input til niende skridt
A.1. Client/Server Model Illustrated
B.1. Windows environment setup
B.2. Path edit
B.3. Creation of One of the Databases
B.4. After the creation

List of Tables

1.

List of Examples

1. A CMS Display Program. File: index.php
2. Local Params, Specific for Database. File: myDbParms.inc.php
3. General Functions, General. File: myDbFuncs.inc.php