DATABASE SYSTEMS KWANKAMON DITTAKAN 968 151 DATABASE SYSTEM

DATABASE SYSTEMS KWANKAMON DITTAKAN

968 -151 DATABASE SYSTEM Data, information and information management; database system concept and architectures; relational database management system; Structured Query Language (SQL); normalization; Entity-Relationship (E-R) diagram; applying relational database

STAFF Lecturer Kwankamon Dittakan, Ph. D College of Computing Prince of Songkla University T: +66 76 276 712 E: kwankamon. d@phuket. psu. ac. th

TEACHER ASSISTANT TA Tassanee Hatthiya (P’Kwan) Room 1406 College of Computing Prince of Songkla University E: tassanee. hattiyakj 080@gmail. com

CONTENT (MIDTERM) Chapter 1 Introduction to Database Chapter 2 Database Architecture, Data Model and Relational Database Chapter 3 Database Design and E-R Model Chapter 4 Database Application Development Lab § Introduction to SQL § Create Database § Initial Select Statement § Aggregate Function and Grouping Data

CONTENT (FINAL) Chapter 5 Normalization Chapter 6 Relational Algebra and Relational Calculus Chapter 7 Transaction Management Chapter 8 Database Systems Management • Lab • • Subqueries Join Multiple Tables Data Modification Integrity Constraint

RECOMMENDED TEXTBOOKS

EVALUATION Midterm Final Other assessment §Attendance §Quiz and Assignment §Active Learning 35% 30% 5% 10% (Group work, Homework, presentation, report)

GRADING METHODS A B+ B C+ C D+ D E : 82 -100 : 75 -81 : 68 -74 : 61 -67 : 54 -60 : 47 -53 : 40 -46 : 0 -39