112-1 DataBase System

Lecture：Pecu(蔡芸琤老師)

Name：徐嫚謙

Department：TAHRD 114

---

Contents

• Notes
• Homework
• Project

---

Notes

Week1 - Course planning and description

Note：SQL vs NoSQL、ER Diagram of a Company、CRUD、How to Draw NoSQL、Fullstack

Week2 - CRUD in SQL DB

SQL Exercises、SQL Result

Learning Viseo：ERD Tutorial1、ERD Tutorial2、Converting ER Diagrams to Schemas

diagraming tool：diagrams、(ERD Notations)

Week4 - CRUD in Web APP

Week5 - CRUD in NoSQL

Week6 - Browse all learning paths and modules

Week7 - CRUD in SQL and NoSQL

Week8 - SQL or NoSQL Best Practices

Week9 - Azure Deploy

Wee10 ~ Week14

Project preparation

Homework

• HW01 Video：ERD design & create database & CRUD
• HW02 Video：CRUD in Web APP & Create Front-end
• HW03 Video：CRUD in NoSQL & Nodejs React with Mongodb
• HW04： Complete HW01-HW03
• HW05 Video： Deploy jobs to the cloud service (by azure)

Project - Management System For Travel Agency

• Proposal-1：Project ideas、ERD

• Proposal-2：Project extension ideas、Figma

• Proposal-3：Full Stack、CRUD

• Final Demo