User Tools

Site Tools


start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
start [2019/12/17 10:24]
admin320 [เนื้อหาวิชาและแผนการสอน]
start [2019/12/22 12:50]
admin320 [เนื้อหาวิชาและแผนการสอน]
Line 42: Line 42:
 ===== เนื้อหาวิชาและแผนการสอน ===== ===== เนื้อหาวิชาและแผนการสอน =====
 ^ 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 ​ | - DBMS: Microsoft Access ​{{ :​ch00-ms-access.pdf |PDF}}\\ - Assign Project {{ :​projectproposal.pdf |Project Proposal}} |
 |  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}} ​ | |  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  |  **วันปีใหม่** ​ ||
Line 51: Line 51:
 |  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]] ​ | |  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]] ​ |
 |  09  |  **วันหยุดชดเชยวันมาฆบูชา** ​ | **Project:​** Progress Report - Database Design ​ | |  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 ​17<​sup>​th</​sup>​ – 23<​sup>​th</​sup> ​2020 (Saturday ​February ​22<​sup>​th</​sup>, ​2020, 12:​00-15:​00)** ​ ||| 
-|  ​09-10  |    Normalization ​ | +|  10  | Basic SQL {{ :​ch04_basicsql.pdf ​|Basic SQL}}\\ {{:​company_elmasri.rar|}} {{ :​assignment8.pdf |Assignment#​8}} ​ | Basic SQL  | 
-|  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|}} |  +|  11  | Advanced ​SQL {{ :ch05_moresql.pdf |Advanced SQL}} {{ :assignment9.pdf |Assignment#​9}}  | Advanced SQL   | 
-|  13  ​| ​Advanced SQL (2)  ​วันจักรี ​ | +|  12  | Database Security and Authorization ​\\ {{ :ch24_databasesecurity.pdf |Database Security}} {{ :​assignment10.pdf ​|Assignment#​10}} ​ ​| ​{{:​ch13_sqlprogramming.pdf|Intro. to SQL Programming Techniques}} ​ | 
-|  ​14  ​| ​The Relational Algebra and Relational Calculus ​{{:ch06_relationalalgebracalculus.pdf|Chapter 6}} |  วันสงกรานต์ ​ | +|  ​13  | Control Concurrent Access ​ | {{:ch14_programmingusingphp.pdf|Programming using PHP}} [[http://​www.w3schools.com/​php/​php_mysql_intro.asp|PHP&​MySQL]] ​ |  
-|  ​15  ​| ​ วันหยุดชดเชยวันสงกรานต์  ​| Present Final Project and Submit Report ​ | +|  14  | Database Recovery ​ | **Project:​** Project Discussion ​ | 
-|  16  | Database Security and Authorization {{:​ch24_databasesecurity.pdf|Chapter 24}} | Wrap Up | +|  15  | Submit Final Report ​ | **Project:​** Present and Demo Final Project ​ | 
-|  **Final Period: ​May 1<​sup>​st</​sup>​ – 16<sup>th</​sup> ​2017 (Saturday May 6<​sup>​th</​sup>, ​2017, 08:​00-11:​00)** ​ |||+|  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