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 11:06] admin320 [เนื้อหาวิชาและแผนการสอน] |
start [2019/12/22 15:45] admin320 [หลักเกณฑ์การให้คะแนน] |
||
---|---|---|---|
Line 14: | Line 14: | ||
===== หลักเกณฑ์การให้คะแนน ===== | ===== หลักเกณฑ์การให้คะแนน ===== | ||
- | |คะแนนเข้าชั้นเรียน | 5%| | + | |คะแนนเข้าชั้นเรียน | [[https://drive.google.com/open?id=1bqrR7YscQ52BqGhvNqXlG7BP0kyQnEeaeGQzqBP3SJY|Attendance Check List]] 5%| |
|สอบปฏิบัติการ (SQL) | 10%| | |สอบปฏิบัติการ (SQL) | 10%| | ||
|สอบกลางภาค | 30%| | |สอบกลางภาค | 30%| | ||
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)** ||| |
| 10 | Basic SQL {{ :ch04_basicsql.pdf |Basic SQL}}\\ {{:company_elmasri.rar|}} {{ :assignment8.pdf |Assignment#8}} | Basic SQL | | | 10 | Basic SQL {{ :ch04_basicsql.pdf |Basic SQL}}\\ {{:company_elmasri.rar|}} {{ :assignment8.pdf |Assignment#8}} | Basic SQL | | ||
| 11 | Advanced SQL {{ :ch05_moresql.pdf |Advanced SQL}} {{ :assignment9.pdf |Assignment#9}} | Advanced SQL | | | 11 | Advanced SQL {{ :ch05_moresql.pdf |Advanced SQL}} {{ :assignment9.pdf |Assignment#9}} | Advanced SQL | | ||
- | | 12 | Database Security and Authorization \\ {{ :ch24_databasesecurity.pdf |Database Security}} {{ :assignment10.pdf |Assignment#10}} | Database Security | | + | | 12 | Database Security and Authorization \\ {{ :ch24_databasesecurity.pdf |Database Security}} {{ :assignment10.pdf |Assignment#10}} | {{:ch13_sqlprogramming.pdf|Intro. to SQL Programming Techniques}} | |
- | | 13 | Control Concurrent Access | {{:ch13_sqlprogramming.pdf|Intro. to SQL Programming Techniques}} | | + | | 13 | Control Concurrent Access | {{:ch14_programmingusingphp.pdf|Programming using PHP}} [[http://www.w3schools.com/php/php_mysql_intro.asp|PHP&MySQL]] | |
- | | 14 | Database Recovery | {{:ch14_programmingusingphp.pdf|Programming using PHP}} [[http://www.w3schools.com/php/php_mysql_intro.asp|PHP&MySQL]] | | + | | 14 | Database Recovery | **Project:** Project Discussion | |
| 15 | Submit Final Report | **Project:** Present and Demo Final Project | | | 15 | Submit Final Report | **Project:** Present and Demo Final Project | | ||
| 16 | **วันจักรี** | Wrap Up | | | 16 | **วันจักรี** | Wrap Up | | ||
| 17 | **วันหยุดชดเชยวันสงกรานต์** | Wrap Up | | | 17 | **วันหยุดชดเชยวันสงกรานต์** | Wrap Up | | ||
- | | **Final Period: May 1<sup>st</sup> – 16<sup>th</sup> 2017 (Saturday May 6<sup>th</sup>, 2017, 08:00-11:00)** ||| | + | | **Final Period: April 20<sup>st</sup> – May 3<sup>rd</sup> 2020 (Friday April 24<sup>th</sup>, 2020, 08:00-11:00)** ||| |
/** | /** |