This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
start [2019/12/17 09:59] admin320 [เนื้อหาวิชาและแผนการสอน] |
start [2019/12/17 10:11] admin320 [เนื้อหาวิชาและแผนการสอน] |
||
---|---|---|---|
Line 47: | Line 47: | ||
| 04 | The Relational Data Model and Relational Database Constraints \\ {{ :ch03_relationaldatamodel.pdf |Relational Data Model & Constraints}} {{ :assignment3.pdf |Assignment#3}} | **Project:** Present Project Proposal | | | 04 | The Relational Data Model and Relational Database Constraints \\ {{ :ch03_relationaldatamodel.pdf |Relational Data Model & Constraints}} {{ :assignment3.pdf |Assignment#3}} | **Project:** Present Project Proposal | | ||
| 05 | Data Modeling Using the Entity-Relationship (ER) Model \\ {{ :ch07_er_model.pdf |ER Model}} {{ :assignment4_1.pdf |Assignment#4-1}} {{ :assignment4_2.pdf |Assignment#4-2}} | Introducing ER Diagram Tool [[https://www.draw.io|Draw.io]] | | | 05 | Data Modeling Using the Entity-Relationship (ER) Model \\ {{ :ch07_er_model.pdf |ER Model}} {{ :assignment4_1.pdf |Assignment#4-1}} {{ :assignment4_2.pdf |Assignment#4-2}} | Introducing ER Diagram Tool [[https://www.draw.io|Draw.io]] | | ||
- | | 06 | The Enhanced Entity-Relationship (EER) Model \\ {{ :ch08_eer_model.pdf |EER Model}} {{ :assignment5.pdf |Assignment#5}} | - ER \\ - EER | | + | | 06 | The Enhanced Entity-Relationship (EER) Model \\ {{ :ch08_eer_model.pdf |EER Model}} {{ :assignment5.pdf |Assignment#5}} | ER- and EER-to-Relational Mapping \\ {{ :ch09_erandeertorelationalmapping.pdf |ER-and-EER Mapping}} {{ :assignment6.pdf |Assignment#6}} | |
- | | 07 | **วันรับพระราชทานปริญญาบัตร** | ER- and EER-to-Relational Mapping \\ {{ :ch09_erandeertorelationalmapping.pdf |ER-and-EER Mapping}} {{ :assignment6.pdf |Assignment#6}} | | + | | 07 | **วันรับพระราชทานปริญญาบัตร** | **Project:** ER/EER Discussion | |
- | | 08 | ER/EER-to-Relational Mapping | Progress Report: ER/EER Diagram | | + | | 08 | Basics of Functional Dependencies and \\ Normalization for Relational Databases | Database Management System [[https://www.pgadmin.org|PostgreSQL-pgAdmin]] | |
+ | | 09 | **วันหยุดชดเชยวันมาฆบูชา** | **Project:** Progress Report - Database Design | | ||
| **Midterm Period: February 27<sup>th</sup> – March 5<sup>th</sup> 2017 (Monday February 27<sup>th</sup>, 2017, 12:00-15:00)** ||| | | **Midterm Period: February 27<sup>th</sup> – March 5<sup>th</sup> 2017 (Monday February 27<sup>th</sup>, 2017, 12:00-15:00)** ||| | ||
- | | 09-10 | Basics of Functional Dependencies and Normalization \\ for Relational Databases {{:ch15_fd_normalization.pdf|Chapter 15}} | Normalization | | + | | 09-10 | | Normalization | |
- | | 11-12 | Implementing the Database Design: \\ - Basic SQL {{:ch04_basicsql.pdf|Chapter 4}} \\ - Advanced SQL (1) {{:ch05_moresql.pdf|Chapter 5}} | - Basic SQL \\ - Advanced SQL \\ {{:assignment7.pdf|}} {{:company_elmasri.rar|}} | | + | | 11-12 | Implementing the Database Design: \\ - Basic SQL {{:ch04_basicsql.pdf|Chapter 4}} \\ - Advanced SQL (1) {{:ch05_moresql.pdf|Chapter 5}} | - Basic SQL \\ - Advanced SQL \\ {{:company_elmasri.rar|}} | |
| 13 | Advanced SQL (2) | วันจักรี | | | 13 | Advanced SQL (2) | วันจักรี | | ||
| 14 | The Relational Algebra and Relational Calculus {{:ch06_relationalalgebracalculus.pdf|Chapter 6}} | วันสงกรานต์ | | | 14 | The Relational Algebra and Relational Calculus {{:ch06_relationalalgebracalculus.pdf|Chapter 6}} | วันสงกรานต์ | |