iTa'LeEm
SEM2 LISC 7424 INFORMATION PROCESSING AND DATABASE DEVELOPMENT
0%
Previous
Course data
General
Announcements
Announcements
Consultation Hour
Course Planner
WEEK 1
W1 - Lecture Slides (Introduction to Database)
W1 - Class Activity 1 (How a Library Database Works?)
W1 - Class Activity 2
WEEK 2
W2 - Lecture Slides (Understanding Database Design)
W2 - Lecture Slides (Understanding Database Structure)
W2 - Class Activity
Assignment 1 - Consequences of Good and Bad Database Design
WEEK 3
W3 - Lecture Slides (Understanding User Requirements)
W3 - Lecture Slides (DB Models)
W3 - Lecture Slides (RDBMS)
W3 - Class Activity - RDBMS - Identifying Constraint
WEEK 4
W4 - Lecture Slides (User Needs vs DB Model)
W4 - DB Operations: Cartesian Product vs Join
W4 - Lecture Slides (Bibliographic Retrieval System - Cataloging Digital Resources)
W4 - Class Activity - Bibliographic Retrieval System
W4 - Class Activity - SOM & ERD
Project - Information Processing and Database Development
WEEK 5
W5 - Lecture Slides (Database Administration)
W5 - Lecture Slides (Extracting Business Rules)
W5 - Class Activity - Identifying Business Rules
Project - Milestone 1 Material - How to Design Your Database
WEEK 6
W6 - Lecture Slides (Metadata for Digital Resources)
W6 - Evolution of Bibliographic Standards
W6 - Microsoft Access Video Tutorial (1)
Project - Milestone 1
WEEK 7
W7 - Lecture Slides (Authority Control)
W7 - Why do we need Authority Control?
W7 - Authority Control vs Access Points
W7 - Authority Control: Consistency in Records
WEEK 7 - Microsoft Access Tutorial
Beginners
Progressive Report: Milestone 2 (Phase 1)
WEEK 8
ERD Diagram
Project - Milestone 2 (P1)
Project - Milestone 2 (P2)
W8 - Lecture Slides (Validation Control)
WEEK 9
W9 - Lecture Slides (Normalization of Data.1)
WEEK 10
W10 - Lecture Slides (Normalization of Data.2)
Open Book - Normalisation - Quiz 1
Open Book - Normalisation - Quiz 2
Open Book - Normalisation - Quiz 3
W10 - Quiz - Solutions
WEEK 11
W11 - Lecture Slides (MySQL)
Project - Milestone 3
WEEK 12
W12 - Lecture Slides (MySQL Statements)
WEEK 13
W13 - Lecture Slides (MySQL Grouping Functions)
W13 - Lecture Slides (Connecting MySQL from PHP)
W13 - Lecture Slides (MySQL Grouping Functions)
W13 - Lecture Slides (Connecting MySQL from PHP)
WEEK 14
Project - Milestone 4
Next
iTa'LeEm
Side panel
2023/2024 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
2019/2020 Academic Session
English (en)
Bahasa Melayu (ms)
English (en)
العربية (ar)
Log in
Course Navigation
LISC 7424 SEM2
Site Navigation
Home
Skip to main content
Course info
Home
Courses
Session 2022/2023 Semester 2
INFORMATION & COMMUNICATION TECHNOLOGY
LISC 7424 SEM2
Summary
SEM2 LISC 7424 INFORMATION PROCESSING AND DATABASE DEVELOPMENT
Instructor:
NOR SAADAH BINTI MD NOR 9019
Skill Level
:
Beginner