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 bekerja sama untuk merancang sistem basis data yang berguna dalam kehidupan nyata
- Mampu menggunakan software terkait basis data
- Mampu menuliskan query SQL berdasarkan algoritma yang ada
- Mampu menunjukkan teori dan konsep basis data dan sistem basis data
Aktifitas Pembelajaran
-
Pertemuan 1 Konsep basis data -
Pertemuan 2 Merancang model konseptual basis data relasional -
Pertemuan 3 Melakukan mapping model basis data konseptual ke dalam model fisik -
Pertemuan 4 Memecahkan permasalahan perancangan data dengan metode ERD -
Pertemuan 5 Program aplikasi untuk merancang basis data -
Pertemuan 6 Merancang basis data dengan teknik normalisasi -
Pertemuan 7 Memecahkan permasalahan perancangan data dengan teknik normalisasi -
Pertemuan 8 Progress Report Project -
Pertemuan 9 Algoritma query melalui Aljabar Relasional (AR) dan Kalkulus Relational (KR) -
Pertemuan 10 Menulis query dengan SQL -
Pertemuan 11 Menulis query dengan SQL -
Pertemuan 12 Menulis query dengan SQL kompleks -
Pertemuan 13 Merancang sistem basis data untuk menyelesaikan permasalahan yang berkaitan dengan Sains Data -
Pertemuan 14 NoSQL Database -
Pertemuan 15 Merancang NoSQL Database 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
Physical Education and Fitness
Physical education is a course that provides understanding and mastery of the nature, function and objectives of physical education. Provide introduction and experience in carrying
Conservation Natural Resources
Discusses: natural resources and the environment, biological natural resource problems at local, national and global levels, conservation and management of biological and non-biological natural resources
Innovative Learning
Studying the theoretical basis, stages, classroom management, and evaluation in differentiated learning, TaRL approach, CRT approach, direct teaching model, cooperative learning model, and scientific approach-oriented
Copyright © 2024 Sinau Digital UNESA All Rights Reserved