|
Module/Course Title: Database Lab
|
|
Module course code
KOMS120207
|
Student Workload
39.67 hours
|
Credits
1 / 1.5 ETCS
|
Semester
2
|
Frequency
Even Semester
|
Duration
16
|
|
1
|
Type
of course
Core Study Courses
|
Contact
hours
45.33 hours of lab activities
|
Independent
Study
|
Class Size
30
|
|
2
|
Prerequisites
for participation (if applicable)
-
|
|
3
|
Learning Outcomes
- Students can demonstrate systematic thinking in analyzing and designing software and database solutions
- Students can apply effective methods in developing software and databases
- Students can create and evaluate software and database solutions
- Students can apply DDL on MySQL
- Students can apply DML on MySQL
- Students can apply DTL on MySQL
- Students can create a database for case studies of information systems
|
|
4
|
Subject aims/Content
Database Lab is one of the compulsory courses in the Computer Science Study Programme. This course provides understanding of database practices, implementation of relational data models, practice of forming normalized database results, practice of using query language (SQL) for searching, sorting, filtering, deleting and updating data as well as creating database application programs in development data processing system computer-based as well as the practice of using databases in information systems. Database lab course discusses Data Definition Language, Data Manipulation Language, JOIN, Subquery, View, Aggregate Function, Stored Procedure, Function, and Triggers using DBMS. Study Material
Pengantar Praktikum Basis Data
- Perancangan desain basis data
- Pengenalan Power Designer
Database Design with Power Designer
- Conceptual Data Model (CDM)
- Cardinality dan Mandatory
- Generate Physical Data Model (PDM)
- Generate SQL
The Practice of Designing CDM-PDM Information System Databases with Power Designer
- Specifying database constraints according to the case
- Transforming the database constraints into a CDM-PDM design
SQL language for data definition and manipulation.
- Types of data
- Data Definition Language (DDL)
- Create Database
- Drop Databse
- Create Table
- Alter Table
- Delete Table
- Drop Table
Data Manipulation Language:
- Insert
- Update
- Delete
Merging multiple tables:
- Join
- Cartesian Product
- Inner Join
- Outer Join
- Union
Built in Function
- Date and Time Function
- Sorting Function
- Aggregate Function
- Group By Function
- Having Function
-
Subquery
- Nested Query
- Subquery on join and function
Set operations
- Union
- Intersect
- Except
Create View
Control Flow Function
- If
- Ifnull
- Nullif
- Case
- Temporary Table
Stored procedure
- Stored Procedure System
- Stored Procedure user
Triggers
- Create Triggers
- Alter Triggers
- Drop Triggers
Transaction Control Languange (TCL)
- Commit
- Rollback
- Save Point
-
|
|
5
|
Teaching methods
Synchronous:
Face-to-face meeting/online meeting
|
|
6
|
Assesment Methods
Attendance and participation
|
|
7
|
This module/course is used in the following study programme/s as well
Computer Science Study Programme
|
|
8
|
Responsibility for module/course
- I Nyoman Saputra Wahyu Wijaya, S.Kom., M.Cs
- NIDN : 0826108901
|
|
9
|
Other Information
- Silberschatz, Abraham, et al. 2019. Database System Concepts, 7th edition. McGraw-Hill Education
- Ramez Elmasri, Shamkant B. Navathe.2015. Fundamentals of Data-base Systems. Pearson
- David M. Kroenke, Database Processing (Fundamental, Design, Implementation)
- Oracle Academy Database Foundation and Database Desain Courses
- I. N. S. W. Wijaya, K. A. Seputra, and W. G. S. Parwita, “Comparison of the BM25 and rabinkarp algorithm for plagiarism detection,” J. Phys. Conf. Ser., vol. 1810, no. 1, 2021, doi: 10.1088/1742-6596/1810/1/012032.
- K. J. Atmaja and I. N. S. Wahyu Wijaya, “Pengembangan Sistem Evaluasi Kinerja Dosen (E-Kuesioner) Stmik Stikom Indonesia,” JST (Jurnal Sains dan Teknol., vol. 8, no. 1, pp. 55–64, 2019, doi: 10.23887/jst-undiksha.v8i1.17290.
- https://www.youtube.com/playlist?list=PLZPZq0r_RZOMskz6MdsMOgxzheIyjo-BZ
- https://www.youtube.com/watch?v=7S_tz1z_5bA&t=2194s
|