iTa'LeEm
SEM2 INFO 1303 Section 06 DATABASE SYSTEMS
0%
Previous
Course data
WELCOME
Announcements
Course Info
Important Matters, Must READ!
Getting Started with Oracle
Link to download Oracle 10g XE
Minicollege.sql
UPDATED_Minicollege dataset
Group Project
Group Registration
Group Project Guidelines
MIDTERM EXAM
WEEK 1: INTRODUCTION TO DATABASE AND ENVIRONMENT
Lecture 1 - Intro to DB and Environment
WEEK 2: DATABASE PLANNING, DESIGN AND ADMINISTRATION
Pre-Class activity: EXPLORE! Learn basic DB concepts using Generative AI
Lecture 2 - DB Plan Design Admin
WEEK 3: RELATIONAL MODEL AND RELATIONAL ALGEBRA
Lecture 3 - Relational Model and Relational Algebra
Lecture 3a - Relational Model
SELF-PACED LEARNING: RELATIONAL ALGEBRA
Mini Quiz
WEEK 4: ERD and ENHANCED ERD MODELING
Lecture 4 - ERD and Enhanced ERD Modeling
In class exercise: ER and ERD Clinic Database
Slides with annotations in class
ASSIGNMENT: ER and ERD E-Commerce Database
WEEK 5: SQL - DATA MANIPULATION (INTRODUCTION)
Basic Concepts on SQL Programming
Lecture 5 - Data Manipulation (Introduction)
Mini Quiz : SQL Basic Retrieval
WEEK 6: SQL - DATA MANIPULATION (INTERMEDIATE)
Lecture 6 - Data Manipulation (Intermediate)
SQL Programming OUTER JOIN: What and How?
WEEK 7: SQL - DATA MANIPULATION (ADVANCED)
Lecture 7 - Data Manipulation (Advanced)
WEEK 8: DATA DEFINITION
Lecture 8 - Data Definition
Class Assignment: Advanced SQL and Data Definition
Sales Company SQL script
WEEK 9: NORMALIZATION
Lecture 9 - Normalization
Slides with additional details _ Lecture 9 - Normalization
WEEK 10: LOGICAL DATABASE DESIGN
Lecture 10 - Logical DB Design
QUIZ 1
QUIZZES
Course Information
Lecture Slides
Exercises
Next
iTa'LeEm
واجهة جانبية
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
2019/2020 Academic Session
العربية (ar)
Bahasa Melayu (ms)
English (en)
العربية (ar)
تسجيل الدخول
Course Navigation
INFO 1303_06 SEM2
Site Navigation
الصفحة الرئيسية
تجاوز إلى المحتوى الرئيسي
معلومات المقرر الدراسي
الصفحة الرئيسية
المقررات الدراسية
Session 2023/2024 Semester 2
INFORMATION & COMMUNICATION TECHNOLOGY
INFO 1303_06 SEM2
الملخص
SEM2 INFO 1303 Section 06 DATABASE SYSTEMS
Instructor:
MIRA KARTIWI 6326
Skill Level
:
Beginner