Sidia is a education Platform website.
Course Description
This course discusses the concepts and definitions of databases, which include the concepts of database preparation and database architecture and design using a relational model approach (entity relationship diagram). Apart from that, the concept of mapping between the conceptual model and the physical database model is also discussed. Next, the concept of database normalization is introduced as part of the database design quality testing method. After that, we studied the concept of database processing using a relational algebra notation approach which was strengthened by introducing the concept and implementation of the use of query language (SQL) through data definition language (DDL) and data manipulation language (DML).
Program Objectives (PO)
- Mampu berpikir logis, kritis, sistematis, dan kreatif dalam merancang sistem basis data yang berguna dalam kehidupan nyata
- Mampu bekerja sama dalam tim untuk mengelola basis data
- Mampu menuliskan query SQL berdasarkan algoritma yang ada
- Mampu mengelola data dan informasi dalam sistem basis data
- Mampu mengimplementasikan konsep basis data dalam menyelesaikan permasalahan bidang sains data
Aktifitas Pembelajaran
-
Pertemuan 1 Konsep basis data -
Pertemuan 2 Merancang model konseptual basis data relasional -
Pertemuan 3 Merancang model konseptual basis data relasional -
Pertemuan 4 Merancang model konseptual basis data relasional -
Pertemuan 5 Merancang model konseptual basis data relasional -
Pertemuan 6 Melakukan mapping model basis data konseptual ke dalam model fisik -
Pertemuan 7 Melakukan mapping model basis data konseptual ke dalam model fisik -
Pertemuan 8 Merancang basis data dengan teknik normalisasi -
Pertemuan 9 Konsep basis data dari studi kasus untuk membangun Entity Relationship Diagram (ERD) -
Pertemuan 10 Algoritma query melalui Aljabar Relasional (AR) dan Kalkulus Relational (KR) -
Pertemuan 11 Algoritma query melalui Aljabar Relasional (AR) dan Kalkulus Relational (KR) -
Pertemuan 12 Menulis query dengan SQL -
Pertemuan 13 Menulis query dengan SQL Kompleks -
Pertemuan 14 Menulis query dengan SQL Kompleks -
Pertemuan 15 Merancang sistem basis data untuk menyelesaikan permasalahan yang berkaitan dengan Sains Data -
Pertemuan 16 Ujian Akhir Semester
Lecturer
Difficult Things About Education.
$75$10
More Similar Courses
Related Courses
Kimia Umum
Study of basic concepts: Scientific Method, Properties of Matter, Stoichiometry, Periodic System of Elements, Chemical Bonds, Energetics, Forms of Substances, Solutions, Colloids, Carbon Chemistry, Green
Discrete Mathematics
Examining the concept of basic rules in counting, permutations, combinations, generating functions, recursive relations, and the principle of inclusion-exclusion and applying them to solve daily
Conservation of Natural Resources
This course discusses 1) The scope of conservation which includes: Definition, objectives, benefits and efforts to preserve natural resources and the environment; 2) Environmental ethics
Copyright © 2026 Sinau Digital UNESA All Rights Reserved