SQL Data Manipulation Exercises

Agus·

Database

Preview

At a Glance

Grade Level10th Grade

SubjectDatabase

Original Prompt

INTI MEMAHAMI Sintaks 1: Orientasi Peserta Didik pada Masalah 1. Guru menyajikan sebuah Kasus Nyata "Toko 'Maju Jaya' mengalami kekacauan data. Ada data barang baru yang belum masuk, ada kesalahan penulisan harga pada barang tertentu, dan ada data member yang sudah tidak aktif namun datanya masih tersangkut di transaksi." 2. Peserta didik diminta mengamati file database awal yang disediakan guru. Sintaks 2: Mengorganisasikan Peserta Didik untuk Belajar 3. Peserta didik dibagi menjadi kelompok ke...

This educational resource focuses on SQL data manipulation commands—INSERT, UPDATE, and DELETE—within the context of managing a database for a retail store, 'Maju Jaya'. It begins with an introduction to SQL and the importance of database integrity. Students are encouraged to explore their preliminary knowledge about databases before encountering practical problems faced by the store, such as stock discrepancies and unregistered members. Structured exercises guide learners to use SQL syntax to manipulate data correctly, emphasizing error analysis like duplicate entries and foreign key constraints. The resource includes guided practice, reflection exercises, and criteria for self-evaluation, aimed at developing students' proficiency in SQL operations.