start
Differences
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:06] admin320 [เนื้อหาวิชาและแผนการสอน] |
start [2019/12/17 11:11] admin320 [เนื้อหาวิชาและแผนการสอน] |
||
|---|---|---|---|
| Line 41: | Line 41: | ||
| ===== เนื้อหาวิชาและแผนการสอน ===== | ===== เนื้อหาวิชาและแผนการสอน ===== | ||
| - | |< 10% 50% 50% >| | ||
| ^ Week ^ Lecture ^ Lab ^ | ^ Week ^ Lecture ^ Lab ^ | ||
| | 01 | - Course Syllabus {{ :204320_coursesyllabus.pdf |Course Syllabus}}\\ - Midterm Exam Appointment | - Standalone DBMS: Microsoft Access\\ - Assign Project {{ :projectproposal.pdf |Project Proposal}} | | | 01 | - Course Syllabus {{ :204320_coursesyllabus.pdf |Course Syllabus}}\\ - Midterm Exam Appointment | - Standalone DBMS: Microsoft Access\\ - Assign Project {{ :projectproposal.pdf |Project Proposal}} | | ||
| - | | 02 | Introduction {{ :ch01_introduction.pdf |Introduction}} {{ :assignment1.pdf |Assignment#1}} | Introducing ER Diagram Tool [[https://www.draw.io|Draw.io]] | | + | | 02 | Introduction {{ :ch01_introduction.pdf |Introduction}} {{ :assignment1.pdf |Assignment#1}} | Database System Concepts and Architecture \\ {{ :ch02_conceptsarchitectures.pdf |DB Concepts & Architecture}} {{ :assignment2.pdf |Assignment#2}} | |
| | 03 | **วันปีใหม่** || | | 03 | **วันปีใหม่** || | ||
| - | | 04 | Database System Concepts and Architecture \\ {{ :ch02_conceptsarchitectures.pdf |DB Concepts & Architecture}} {{ :assignment2.pdf |Assignment#2}} | **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 | The Relational Data Model and Relational Database Constraints \\ {{ :ch03_relationaldatamodel.pdf |Relational Data Model & Constraints}} {{ :assignment3.pdf |Assignment#3}} | 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}} | | + | | 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|Chapter 8}} {{:assignment4.pdf|Assignment#4}}\\ - | - 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 | วันหยุดชดเชยวันมาฆบูชา | Relational Database Design by \\ ER- and EER-to-Relational Mapping \\ {{:ch09_erandeertorelationalmapping.pdf|Chapter 9}} {{:assignment5.pdf|Assignment#5}} | | + | | 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 \\ {{ :ch15_fd_normalization.pdf |FD and Normalization}} {{ :assignment7.pdf |Assignment#7}} | Database Management System [[https://www.pgadmin.org|PostgreSQL-pgAdmin]] | |
| - | | **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 | **วันหยุดชดเชยวันมาฆบูชา** | **Project:** Progress Report - Database Design | |
| - | | 09-10 | Basics of Functional Dependencies and Normalization \\ for Relational Databases {{:ch15_fd_normalization.pdf|Chapter 15}} {{:assignment6.pdf|Assignment#6}} | Normalization | | + | | **Midterm Period: February 17<sup>th</sup> – 23<sup>th</sup> 2020 (Saturday February 22<sup>th</sup>, 2020, 12:00-15:00)** ||| |
| - | | 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|}} | | + | | 10 | Basic SQL {{ :ch04_basicsql.pdf |Basic SQL}}\\ {{:company_elmasri.rar|}} {{ :assignment8.pdf |Assignment#8}} | Basic SQL | |
| - | | 13 | Advanced SQL (2) | วันจักรี | | + | | 11 | Advanced SQL {{ :ch05_moresql.pdf |Advanced SQL}} {{ :assignment9.pdf |Assignment#9}} | Advanced SQL | |
| - | | 14 | The Relational Algebra and Relational Calculus {{:ch06_relationalalgebracalculus.pdf|Chapter 6}} | วันสงกรานต์ | | + | | 12 | Database Security and Authorization \\ {{ :ch24_databasesecurity.pdf |Database Security}} {{ :assignment10.pdf |Assignment#10}} | {{:ch13_sqlprogramming.pdf|Intro. to SQL Programming Techniques}} | |
| - | | 15 | วันหยุดชดเชยวันสงกรานต์ | Present Final Project and Submit Report | | + | | 13 | Control Concurrent Access | {{:ch14_programmingusingphp.pdf|Programming using PHP}} [[http://www.w3schools.com/php/php_mysql_intro.asp|PHP&MySQL]] | |
| - | | 16 | Database Security and Authorization {{:ch24_databasesecurity.pdf|Chapter 24}} | Wrap Up | | + | | 14 | Database Recovery | **Project:** Project Discussion | |
| - | | **Final Period: May 1<sup>st</sup> – 16<sup>th</sup> 2017 (Saturday May 6<sup>th</sup>, 2017, 08:00-11:00)** ||| | + | | 15 | Submit Final Report | **Project:** Present and Demo Final Project | |
| + | | 16 | **วันจักรี** | Wrap Up | | ||
| + | | 17 | **วันหยุดชดเชยวันสงกรานต์** | Wrap Up | | ||
| + | | **Final Period: April 20<sup>st</sup> – May 3<sup>rd</sup> 2020 (Friday April 24<sup>th</sup>, 2020, 08:00-11:00)** ||| | ||
| /** | /** | ||
start.txt · Last modified: 2020/05/10 14:20 by admin320
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
