database management - Class announcement
Quick link (quiz and score)
Warning: multiple submission will be removed using remove duplication add-in by Google Sheet. Only the remain is valid.
Quiz 1 [ PRE | POST ]
Quiz 2 [ PRE | POST ] Quiz 3 [ PRE | POST ] Quiz 4 [ PRE | POST ] Quiz 5 [ PRE | POST ] Quiz 6 [ PRE | POST ] Quiz 7 [ PRE | POST ] Quiz 8 [ PRE | POST ] Quiz 9 [ PRE | POST ] Quiz 10 [ PRE | POST ] Quiz 11 [ PRE | POST ] Quiz 12 [ PRE | POST ] Quiz 13 [ PRE | POST ] Quiz 14 [ PRE | POST ] Quiz 15 [ PRE | POST ] |
Quiz score 1 [ Pre | Post ]
Quiz score 2 [ Pre | Post ] Quiz score 3 [ Pre | Post ] Quiz score 4 [ Pre | Post ] Quiz score 5 [ Pre | Post ] Quiz score 6 [ Pre | Post ] Quiz score 7 [ Pre | Post ] Quiz score 8 [ Pre | Post ] Quiz score 9 [ Pre | Post ] Quiz score 10 [ Pre | Post ] Quiz score 11 [ Pre | Post ] Quiz score 12 [ Pre | Post ] Quiz score 13 [ Pre | Post ] Quiz score 14 [ Pre | Post ] Quiz score 15 [ Pre | Post ] |
Teaching plan
overview |
Technical information
436304 Database Management 3 (2-2-5) = 2 hours lecture, 2 hours practice, 5 hours self-learning Objective
Lessons in this class include:
Expected result
After completion of this class, students are expected to be:
Class characteristic
This course is a technology related course for Arts students. To ensure understanding of each subject of interest, quizzes will be conducted regularly. Handouts are in English to stimulate class participation and discussion. English handouts also aim to improve English reading skill which is very important for understanding technical documents. Lectures are conducted in Thai to ensure understanding on the subjects. Quiz This course featured two scored quizzes in every session. Student should read the related materials before taking a class. They should also make sure they understand the lesson after the class. The two quizzes aim to stimulate self-study to fit 6 hours of self-study in the syllabus. One quiz is conducted in the beginning of the class to measure self-learning afford. Another is conducted before leaving the class to reflect on student understanding on the subject they just studied. Some questions in the quizzes may challenge students' wits as well as knowledge. Students may expect some answers like "Not possible" or "Wrong question". Self-learning Students is assumed to have no prior knowledge in database technology. They are expected to have a basic knowledge in computer technology. This course will present them a new field of knowledge. Students are expected to learn from outside course materials as well as provided handouts. The quizzes will be challenging and not necessarily derived purely from provided texts. Students train themselves some learning discipline fit for people who work in the field of technology. Handout This course features handout provided by the designated instructor. All handouts are in English. Students in faculty of arts are expected to be good, if not excellence, in English. In case they are not good, they must attend every lecture which will be provided in Thai to ensure their understanding. All questions, include vocabularies, are most welcome. Seriously, guys, if you don't understand, ask it out! Handouts do not feature note area. Students are encouraged to prepare their own notebook and a pen or pencil. Lecture All lectures in this course are in Thai. Using English handout and English presentation aided software, Students will be forced to learn English as a language that highest portion of the knowledge in this field is transferred. However, the teacher realizes the need of clear understanding on the lessons. So, if students have problem understanding the handout or the lecture, they can communicate in Thai. |
score |
Quiz : 10%
Term project : 40% (group score x peer review) Final exam : 50% |
schedule
|
This information is an in-class planning. The real delivery may be varied according to the situation. Each session lasts 200 minutes but the allocated time may be 5 - 15 minutes shorter. These shorter time is designed to be a spend on some activities which may take longer than planned.
Note on English + Q/A section - It is designed to encourage students to learn English. Questions should be related to information network. Prizes are given to those who participate.
Session 1 - Introduction [ slide ] Pre-quiz : How well have you prepared? [10m] Get to know : instructor and students introduction [20m] Review : What do you know about this course? [10m] Topic : How is this course structured? Score? [20m] Break : Chill out [15m] Topic : Project planning [30] Discussion : Project discussion [20] Break : Chill out [15m] Topic : What is database? Why should I care? [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 2 - basic DBMS and basic database objects [ slide ] Pre-quiz : How well have you prepared? [10m] Review : What is a database again? Have you thought about your project? [10m] Lecture : DBMS (use MS Access) and basic DB objects, table, column, row [40m] Break : Chill out [15m] Workshop : DBMS tools for front-end such as form and controls [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Break : Chill out [15m] Workshop : DBMS tools for front-end properties such as filters and events [50m] Post-quiz : How much have you learned? [10m] Session 3 - Table, keys, relationship and how a badly designed database can mess up your data [slide] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [20m] Topic : Table, keys and relationship [30m] Break : Chill out [15m] Workshop : Design a (NF0) DB [50m] Break : Chill out [15m] Workshop : Anomalies on the recently designed DB [30m] Topic : Introduction to normalization English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 4 - Normalization : to kill anomalies [ slide ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [10m] Topic : NF0 - NF3 [40m] Break : Chill out [15m] Topic : BCNF to NF6 [30m] Topic : Problems with normalization [20m] Break : Chill out [15m] Workshop : Design challenge! Use excel to design tables without anomaly [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 5 - ERD and Database design [ slide ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [30m] Topic : Database design using Crow-feet ER diagram - [20m] Break : Chill out [15m] Workshop : Database design [50m] Break : Chill out [15m] Workshop : Database implementation and EERD [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 6 - Database design summary (and project interview as time permitted) [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [20m] Workshop : Database design [30m] Break : Chill out [15m] Workshop : Database design [50m] Break : Chill out [15m] Workshop : Database design [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 7 - Beyond operational database [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [30m] Topic : Operational database concept and example [20m] Break : Chill out [15m] Topic : Analytical database [50m] Break : Chill out [15m] Topic : NoSQL and other new exciting kind of database [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 8 - Web database bundle & SQL language [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [10m] Topic : Apache, MySQL and PHP (using WAMP server) [20m] Workshop : Config WAMP server [20m] Break : Chill out [15m] Topic : SQL language [50m] Break : Chill out [15m] Workshop : SQL utility commands such as USE, SHOW, DESCRIBE [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 9 - Data Definition [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [20m] Workshop : Data type [30m] Break : Chill out [15m] Workshop : CREATE [50m] Break : Chill out [15m] Workshop : ALTER and DROP [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 10 - Data manipulation [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [10m] Topic : INSERT [40m] Break : Chill out [15m] Workshop : UPDATE [25m] Workshop : DELETE [25m] Break : Chill out [15m] Workshop : Issues with concurrent connection and data manipulation [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 11 - Query [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [10m] Workshop : SELECT FROM WHERE ORDER BY [40m] Break : Chill out [15m] Workshop : JOIN [50m] Break : Chill out [15m] Workshop : NESTED SELECT and MORE [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 12 - Functions [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [10m] Workshop : SQL aggregate functions [40m] Break : Chill out [15m] Workshop : SQL aggregate functions and scalar functions [50m] Break : Chill out [15m] Workshop : SQL aggregate functions and scalar functions [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 13 - Database design in practice [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [10m] Workshop : Design a database - business logic - Library services [40m] Break : Chill out [15m] Workshop : Design a database - EERD [50m] Break : Chill out [15m] Workshop : Design a database - SQL [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 14 - Database implementation in practice [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [10m] Workshop : Database implementation - from last session design [40m] Break : Chill out [15m] Workshop : Database implementation - test run [50m] Break : Chill out [15m] Workshop : Database administration - tuning database [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 15 - Database administration & security [ slides ] Pre-quiz : How well have you prepared? [10m] Review : Last session flashback [10m] Topic : Database administration - DBA job [30m] Workshop : Database administration - Back up and restore [20m] Break : Chill out [15m] Workshop : Database administration - User management [30m] Break : Chill out [15m] Workshop : Database security - Protect your database from basic threats [30m] English + Q/A : Encourage you to learn English + ask and find answer, for a prize! [20m] Post-quiz : How much have you learned? [10m] Session 16 - Project presentation Workshop : Project presentation (time divided equally by group) |
project |
Students are required to design and implement a database system by a self-constructed team. The database must be presented and usage demonstration is required. The documentation must include ER diagram and explanation of the database. The system will be broken down and the team must fix the imposed problems to guarantee their knowledge on their own system.
The objective of the project is to ensure students’ knowledge on database system. Teams are required to submit a proposal on the chosen project. The deadline is at the 8th session. The proposal structure is explained below. This is students’ responsibility. There may be no warning. Teams those failed to submit their proposal will get 0 score for the project (and recommend they withdraw from the course because their score would be 60/100, at best) Project proposal is submitted through this <GOOGLE FORM> Scoring criteria Students can access teacher's scoring card <here> Example project topics Topics of term project are as followed (can be changed for significant technology advance). Students can propose their own topic.
|
example projects files
Coming soon - for now, you can get the project at my old desk in librarian department. Please return it to the shelf after use.
Recommendation |
Textbook
Michael Kifer, Arthur Bernstein, and Philip M. Lewis. (2006). Database systems : an application-oriented approach. Boston: Pearson/Addison-Wesley. [SULIB] Additional Reading (chosen by campus availability / ease of understanding)
|