Course: 12S4081 - Pengenalan Basis Data dan Sistem Informasi

Topic outline

General

Collapse all Expand all
A Gentle Introduction
- In this section, the students will have a general view of what this course is about. Starting from how information systems have been an integral part of any type of organization. When properly set up, it may guide an organization to its peak. Down under the information systems lies data, the "new oil". An organization's data is a "special" asset that needs special "treatment" in order to gain from it.
01 Database: The Core Concepts
- This section aims to introduce the students to the core concepts of databases. By finishing this section, the students should be able to:
  describe the reasons behind the existence of a database system,
  contrast between database and database management systems,
  describe the general overview of database design,
  describe the concepts of data requirements and do it systematically.
- Data and Database: An Introduction
  This subsection covers the core concepts of data, awareness of its existence, how to store and process it, and when database comes into play. The material is accompanied by friendly case studies to help the students reach the section's objectives.
- Data and Database: An Introduction (Slide) URL
- Database Design: An Overview
  This subsection draws the general overview of database design processes. This material exposes. This material is essential to guide us into the coming topics.
- Database Design: An Overview (Slide) URL
- Data Requirements
  This section covers the very first step of developing a database, which is understanding the data requirements. To identify data requirements, the steps are (1) understand the problem at hand, (2) analyze it, and (3) find reinforcement information from similar cases. This material should help the students understand the background of developing a database.
- Data Requirements (Slide) URL
- MiniQuiz 01
  Materials:
  
  Data and Database;
  
  Database Design; and
  
  Data requriements.
- Share your reflection on "Database: The Core Concepts" section! URL
  
  The result can be seen here!
02 Entity-Relationship (ER) Modeling
- In this section, the students will learn how to identify data, the relationships between data, and model them for better understanding. Entity-relationship diagram (ERD) is introduced also in this section.
- Entity-Relationship Diagram (ERD)
  In this lecture, the students should learn the second step of database design. Once the data requirements are complete, they need to be described so that others can read and understand. In this case, the Entity-Relationship diagram is used to model the data requirements.
- Entity-Relationship Diagram (Slide) URL
- Entities and Their Existence
  In this lecture, the students should learn the two types of entities and be able to identify them in a problem. The two types are strong and weak entities.
- Entities and Their Existence (Slide) URL
- MiniQuiz 02
  Materials:
  
  Entity-Relationship Diagram (ERD); and
  
  Entities and their existence.
- Share your reflection on "Entity-Relationship (ER) Modeling" section! URL
  
  The result can be seen here!
- Entity Attributes and Primary Keys
- Entity Attributes and Primary Keys (Slide) URL
- Relationship Participation
  In this lecture, the students will learn the concepts of entity participation in a relationship. There are two types of participation, namely total and partial participation.
- Relationship Participation (Slide) URL
- Attribute: Role and Types
- Attribute: Role and Types (Slide) URL
- Relationship Attributes
- Relationship Attributes (Slide) URL
- MiniQuiz 03
  Materials:
  
  Relationship participation;
  
  Entity attributes and primary keys;
  
  Attribute: role and types; and
  
  Relationship attributes.
- Share your reflection on "Entity-Relationship (ER) Modeling" section! URL
  
  The result can be seen here!
03 Relational Data Model
- In this section, the students will learn on the core concepts of the relational model along with their constraints. Don't worry, the materials will scratch only the surface.
- Relational Data Model
  In this lecture, the students should learn the core concepts of the relational model. Some discussion topics are domains, attributes, tuples, and relations.
- Relational Data Model (Slide) URL
- Data Types
- Data Types (Slide) URL
- Relation Representation
- Relation Representation (Slide) URL
- Translating ERD Into Relational Model
- Translating ERD Into Relational Model (Slide) URL
- MiniQuiz 04
  Materials:
  Relational data model;
  Data types;
  Relation representation; and
  Translating ERD into relational model.
- Share your reflection on "Relational Data Model" section! URL
  
  The result can be seen here!
04 Normalization
- Functional Dependency
- Functional Dependency (Slide) URL
- Normalization: 1st Normal Form
  In this lecture, the students should learn the core concepts of data normalization, its motivation, and when it should or should not be applied. The normalization process will go from the 1st normal form to the 2nd, and the 3rd.
- Normalization: 1st Normal Form (Slide) URL
- Normalization: 2nd Normal Form
  In this lecture, the students should learn the core concepts of data normalization, its motivation, and when it should or should not be applied. The normalization process will go from the 1st normal form to the 2nd, and the 3rd.
- Normalization: 2nd Normal Form (Slide) URL
- Normalization: 3rd Normal Form
  In this lecture, the students should learn the core concepts of data normalization, its motivation, and when it should or should not be applied. The normalization process will go from the 1st normal form to the 2nd, and the 3rd.
- Normalization: 3rd Normal Form (Slide) URL
- MiniQuiz 05
  Materials:
  
  Functional dependency; and
  
  Normalization.
- Share your reflection on "Normalization" section! URL
  
  The result can be seen here!
- Introducing SQLab
05 Structured Query Language (SQL)
- In this section, the students will learn the basic concept of structured query language (SQL) and how to use it to manipulate a database structure and data. Moreover, the students will also learn how to develop a query to retrieve information.
- Structured Query Language (SQL)
  In this lecture, the students should learn the use of SQL, the basic syntax, and types of queries.
- Structured Query Language (Slide) URL
- SQL Statement: CREATE
  In this lecture, the students should learn three query clauses to define structure: CREATE, ALTER, and DROP.
- SQL Statement: CREATE (Slide) URL
- SQL Statement: ALTER
  In this lecture, the students should learn three query clauses to define structure: CREATE, ALTER, and DROP.
- SQL Statement: ALTER (Slide) URL
- SQL Statement: DROP
  In this lecture, the students should learn three query clauses to define structure: CREATE, ALTER, and DROP.
- SQL Statement: DROP (Slide) URL
- SQL Statement: INSERT
- SQL Statement: INSERT (slide) URL
- SQL Statement: UPDATE and DELETE
- SQL Statement: UPDATE and DELETE (slide) URL
- MiniQuiz 06
  Materials:
  
  SQL Basic Syntax and Types of Queries
  
  SQL Statement: Create
  
  SQL Statement: Alter
  
  SQL Statement: Drop
  
  SQL Statement: Insert
  
  SQL Statement: Update and Delete
- Share your reflection on "Structured Query Language" section! URL
  
  The result can be seen here!
- SQL for Retrieval
  In this lecture, the students should learn how to retrieve data using SELECT and JOIN clauses.
- SQL Statement: SELECT (Slide) URL
- SQL Clause: JOIN
- SQL Clause: JOIN (Slide) URL
- MiniQuiz 07
  Materials:
  
  SQL Statement: Select
  
  SQL Clause: Join
- Share your reflection on "Structured Query Language" section! URL
  
  The result can be seen here!
06 Information Systems: The Core Concepts
- In this section, the students will learn on the core concepts of information systems and their role in an organization.
- Information Systems
- Information Systems (slide) URL
- MiniQuiz 08
  Materials:
  
  Information Systems
- Share your reflection on "Information Systems" section! URL
  
  The result can be seen here!
07 Information Security At A Glance
- In this section, the students will learn on what are challenges and threats in managing information systems. Moreover, the students will also be exposed to the possible ways to prevent and mitigate such challenges and threats.
- Information Security
- Information Security (slide) URL
- MiniQuiz 09
  Materials:
  
  Information Security
- Share your reflection on "Information Security" section! URL
  
  The result can be seen here!
08 Evaluation
- Final Exam Quiz
  Materials:
  
  Data and Database
  
  Data Requirements
  
  Entity-Relationship Diagram
  
  Entities and Their Existence
  
  Entity Attributes and Primary Keys
  
  Relationship Participation
  
  Attribute: Role and Types
  
  Relationship Attributes
  
  Relational Data Model
  
  Data Types
  
  Relationship Representation
  
  Translating ERD to Relational Model
  
  Functional Dependency
  
  Normal Forms
  
  Structured Query Language
  
  SQL Statement and Clause
  
  Information Systems
  
  Information Security
09 What's Next?

12S4081 - Pengenalan Basis Data dan Sistem Informasi

Course Content

Topic outline

General

A Gentle Introduction

01 Database: The Core Concepts

Data and Database: An Introduction

Database Design: An Overview

Data Requirements

02 Entity-Relationship (ER) Modeling

Entity-Relationship Diagram (ERD)

Entities and Their Existence

Entity Attributes and Primary Keys

Relationship Participation

Attribute: Role and Types

Relationship Attributes

03 Relational Data Model

Relational Data Model

Data Types

Relation Representation

Translating ERD Into Relational Model

04 Normalization

Functional Dependency

Normalization: 1st Normal Form

Normalization: 2nd Normal Form

Normalization: 3rd Normal Form

Introducing SQLab

05 Structured Query Language (SQL)

Structured Query Language (SQL)

SQL Statement: CREATE

SQL Statement: DROP

SQL Statement: INSERT

SQL Statement: UPDATE and DELETE

SQL for Retrieval

SQL Clause: JOIN

06 Information Systems: The Core Concepts

Information Systems

07 Information Security At A Glance

Information Security

08 Evaluation

09 What's Next?

Contact

Spada Indonesia