{"course":{"id":"112262702B01","name":"資料庫實務","enroll_type":"選修","general_type":"","dept":"人工智慧學程","grade":2,"class_group":"甲","teacher":"謝筱齡","credit":3,"hour":3,"time":[{"day":3,"section":[6,7,8]}],"classroom":"","max":56,"min":10,"remark":"","alt_for":"","courses":""},"detail":[["指定教材","All materials are online, will be provided in class\nAdditional textbook(s) or topics will be determined in class or requested by students as well"],["參考教材","All materials are online, will be provided in class;\nReferences will be assigned including additional handouts as the course progresses"],["成績評量標準","Practices, Homework assignments: Students not only need to understand the lectures but also need to have hands-on experience & skills for the corresponding on-line available DBMS products, for example MySQL, PostgreSQL, Time Series Database exercises, various required tasks involving open sources, materials provided in class. Grading policy will be based upon: (1) Interactive interfaces in class; (2) Written practices including presentation skills; (3) Comprehensiveness and Creativity of assigned tasks, and (4) students' learning attitudes and eagerness"],["教學方法","理論講授,實務講授,個案分析,分組實驗(實作),個人實驗(實作)"],["教學目標","The AIoT Computer Architecture will be introduced initially. In the Architecture, it encompasses a Data Center or Database(s) to handle various types of data. In order to manage the data, the fundamentals of Database Management System (DBMS) will be illustrated in the course. In addition, the various hands-on practices  applying to a Relational Database will be emphasized. The topics of the course include Entity-Relationship Diagram (Semantic Modeling), Relational Database construction (including attributes, tuples, primary or foreign keys, etc.). Data Definition Language, Data Manipulation Language, database normalization, examples of database programming development via APIs, functionalities, tasks as well as activities, for example MySQL, PostgreSQL, Time Series Database exercises, DBMS queries or case studies. Students defined/interested topics will be included as well. Students not only can learn basic computer/DBMS related terminologies and techniques, but also can enhance and improve their English proficiency in the areas. The course aims at sophomore students of Artificial Intelligent major with/without backgrounds in Database, IoT, or Computer Science related fields."]],"office_time":[["謝筱齡","Office Hours: after the class or by appointments, e-mails, phone (03-571-2121 x55287; sl_hsieh@nycu.edu.tw)"]],"schedule":[["2024/01/17","6","8","3","謝筱齡","AIoT Computer Architecture - Computer system(1)","","English Terminologies and concepts in Computer system components","Establish students initial and high level of computer science English capabilities"],["2024/01/24","6","8","3","謝筱齡","AIoT Computer Architecture - Computer system(2)","","Computer system components' features","Establish students initial and high level of computer science capabilities in English"],["2024/01/31","6","8","3","謝筱齡","AIoT Computer Architecture - embedded system with protocols","","embedded system components and communication mechanism","Establish students initial and high level of computer science capabilities in English"],["2024/02/21","6","8","3","謝筱齡","Networking  - wired/wireless Internet, Mobile Telephony System","","Networking Infrastructures","Establish students basic and high level of networking background"],["2024/02/28","6","8","3","謝筱齡","Database Concepts (1)","","Introduction to Relational Database Management System","Database Sematic Modeling, SQL Schema, and Database development programming in Java, C examples"],["2024/03/06","6","8","3","謝筱齡","Database Concepts (2)","","Introduction to Relational Database Management System","Database Sematic Modeling, SQL Schema, and Database development programming in Java, C examples"],["2024/03/13","6","8","3","謝筱齡","Database Practice Capabilities (1)","ER Diagram; Relational Database Construction","Provide DBMS Concepts; ER Diagram; Functional Dependency, Normalization","ER Diagram; relational tables; attributes, tuples, primary & foreign keys"],["2024/03/20","6","8","3","謝筱齡","Database Practice Capabilities (2)","ER Diagram; Relational Database Construction","Provide DBMS Concepts; ER Diagram; Functional Dependency, Normalization","ER Diagram; relational tables; attributes, tuples, primary & foreign keys"],["2024/03/27","6","8","3","謝筱齡","Database Practice Capabilities (3)","Relational Database normalization construction; 1NF, 2NF, 3NF & BCNF relational tables","Provide DBMS Concepts; ER Diagram; Functional Dependency, Normalization","ER Diagram; relational tables; functional dependency, 1NF, 2NF, 3NF, etc."],["2024/04/03","6","8","3","謝筱齡","SQL Schema; DB Query & Implementations for Database Accessing","DB Database Definition Language, Database Manipulation Language & Query Practice applying to MySQL","Data Definition and Data Manipulation; Basic Database Management  Programming Skills applying to MySQL","Database SQL Schema and Database development programming in Java, C examples applying to MySQL"],["2024/04/10","6","8","3","謝筱齡","Continued as above; additional DB normalization practice","Continued as above; additional DB normalization practice","Continued as above; additional DB normalization practice","Database SQL Schema and Database APIs development programming in Java, C examples; relational tables normalization practice"],["2024/04/17","6","8","3","謝筱齡","Continue/Review; Implementations for Database Accesses applying to PostgreSQL","Continue/Review; Implementations for Database Accesses applying to PostgreSQL","Continue/Review; Implementations for Database Accesses applying to PostgreSQL","PostgreSQL practice"],["2024/04/24","6","8","3","謝筱齡","Continue/Review; Implementations for Database Accesses; Time Series Database Introduction & Practice","Continue/Review; Implementations for Database Accesses; Time Series Database Introduction & Practice","Continue/Review; Implementations for Database Accesses; Time Series Database Introduction & Practice","Time Series Database Introduction & Practice"],["2024/05/01","6","8","3","謝筱齡","Continue/Review; Implementations for Database Accesses","Continued as above","Continued as above","Continued as above"],["2024/05/08","6","8","3","謝筱齡","Additional DBMS Technical examples practices in ODBC/JDBC Driver Programming","","In class practice; Data Definition and Data Manipulation; Basic Database Management  Programming Skills; ODBC/JDBC Driver","Group presentation Database SQL Schema and Database programming in Java, C examples"],["2024/05/15","6","8","3","謝筱齡","Additional DBMS Technical examples practices in ODBC/JDBC Driver Programming","","In class practice; Data Definition and Data Manipulation; Basic Database Management  Programming Skills, SQL Schema and ODBC/JDBC Driver Programming in Java examples","Group exercises, presentations practice"],["2024/05/22","6","8","3","謝筱齡","DBMS final project exercise & presentation","","DBMS final project exercise & presentation","DBMS final project exercise & presentation"],["2024/05/29","6","8","3","謝筱齡","DBMS final project exercise & presentation","","DBMS final project exercise & presentation","DBMS final project exercise & presentation"]]}