Genap 2023/2024
Kelas-Offr:
K-KK
Deskripsi:
Matakuliah yang mempelajari tata cara query pada SQL
Capaian Pembelajaran
· Merumuskan konsep dan fungsi basis data;
· Merumuskan model data relasional;
Memecahkan model basis data konseptual menggunakan ERD dan UML
Mendesaian dan membuat relasi aljabar dan SQL
Merancang basis data menggunakan teori normalisasi relasi
· Mendesain dan membuat trigger dan basis data aktif;
· Mendesain dan membuat aplikasi menggunakan SQL;
· Mendesaian dan membuat query;
Menyusun pemrosesan transaksi
Memecahkan studi kasus perancangan basis data
· Allen, Christopher, dkk. 2004. Introduction to Relational Databases and SQL Programming. New York: McGraw-Hill.
· Cannolly, Thomas M. dan Begg, Carolyn E. 2005. Database Systems: A Practical Approach to Design, Implementation and Management. Singapore: Pearson Education Asia.
· Coulthard, Glen dan Hutchinson-Clifford, Sarah. 2005. Advantage Series: Microsoft Office Access 2003, Complete. New York: McGraw-Hill.
· Dietrich, Suzanne W. dan Urban, Susan D. 2005. An Advanced Course in Database Systems Beyond Relational Databases. Singapore: Pearson Education Asia
· Elmasri, Ramez dan Navathe, Shamkant. 2004. Fundamentals of Database Systems. New York: Addison-Wesley.
· Kifer, Michael, dkk. 2006. Database Systems: An Application-Oriented Approach. New York: Addison-Wesley.
· Mannino, Michael V. 2004. Database Design, Application and Administration with ER Assistant. New York: McGraw-Hill.
· Riordan, Rebecca M. 2005. Designing Effective Database Sys-tems. Singapore: Pearson Education Asia.
· Rischert, Alice. 2004. Oracle SQL by Example. Singapore: Pearson Education Asia
· Rob, Peter dan Semaan, Elie. 2004. Databases Design, Development and Deployment Using Microsoft Access. New York: McGraw-Hill.
· Shah, Nilesh. 2004. Database Systems Using Oracle. Singapore: Pearson Education Asia.
· Silberschatz, Abraham dan Korth, Henry F. 2006. Database System Concepts. New York: McGraw-Hill.
- Teacher: wahyu nur hidayat