Presentation

<figure class="highlight"><pre><code class="language-text" data-lang="text">name: inverse
layout: true
class: center, middle, inverse
.indexlink[[](#) [](#index) <a href="#" class="color"></a>]

---

name: top
layout: true
class: top, left
.indexlink[[](#) [](#index) <a href="#" class="color"></a>]

---

name: normal
layout: true
class: left, middle
.indexlink[[](#) [](#index) <a href="#" class="color"></a>]

---

name: presentation
template:inverse

# Course Presentation
## ESIN 
Gonçalo Gonçalves  
[gflcg@fe.up.pt](mailto:gflcg@fe.up.pt)

---
template: top

<!--
 # Learning Outcomes

After completing this course you should be able to:

* Design a **relational database**
* Make **SQL** queries to relational databases
* Create and validate **HTML 5** documents
* Layout HTML 5 documents using **CSS**
* Create an **information system** implemented as a dynamic **web application** using PHP and relational databases
* Use **Git** to manage source code versions and work efficiently in a team
* Deploy your web application using **Docker**
-->

# Course Content

* UML conceptual model
    * Information systems modelling
    * Classes, Associations and Attributes
* Relational model
    * Conversion from the UML conceptual model to the relational model
    * Relations and constraints
* The SQL language
    * Database definition, querying and manipulation
* The SQLite Database management system
* Web information systems
* Client-side Web languages
      * Web page structure using HTML
      * Web page design using CSS
* Server-side Web language: PHP
* Basic features of the Docker container management system

---

# Evaluation

To obtain a passing grade, you must:
* Complete and present the **Project**, obtaining a minimum final grade of 8 (out of 20)
* Get a minimum grade of 8 (out of 20) on the written **Exam**

Calculation of the final grade: 0.5 \* **Project** + 0.5 \* **Exam**

---

# Project

Implementation of a website using SQL, HTML, CSS and PHP.
 
<table style="margin: 0 auto;border: none; border-collapse:collapse">
 <thead>
 <th>Stage</th>
 <th>Evaluation</th>
 </thead>
 <tr>
 <td>1. Group Formation</td>
 <td style="text-align: center">-</td>
 </tr>
 <tr>
 <td>2. Topic Choice</td>
 <td style="text-align: center">-</td>
 </tr>
 <tr>
 <td>3. First Delivery</td>
 <td style="text-align: center">30%</td>
 </tr>
 <tr>
 <td>4. Second Delivery</td>
 <td rowspan=2 style="text-align: center">70%</td>
 </tr>
 <tr>
 <td>5. Presentation</td>
 </tr>
</table>

---

# Project

---

# Bibliography

## Main
* Michal Zalewski; *The tangled Web*. ISBN: 978-1-59327-388-0

* Jakob Nielsen; *Designing web usability*. ISBN: 1-56205-810-X

* Jeffrey D. Ullman, Jennifer Widom; *A First Course in Database Systems*. ISBN: 0-13-8687647-9

* Provided Slides

## Complementary
* Adrian Mouat; *Using Docker: Developing and Deploying Software with Containers*. ISBN: 978-1-49191-576-9

* Lots of Web resources and tutorials!</code></pre></figure>