This course introduces students to the foundations of database management system, with focus on concepts and structures necessary to design and implement a database system. Students will have an explorations on topics including database design, the relational model, SQL, transaction management, concurrency control, and brief introduction of schema Refinement and normal forms. Detailed case studies will be applied to provide better practical skills in this field.