Skip to main content
CMT221W ORGANISASI & REKA BENTUK PANGKALAN DATA (DATABASE ORGANISATIONS AND DESIGN)
0%
Previous
Course data
General
Please READ ALL Announcement Messages
Reference Book
Assignment Group Registration
Assignment Proposal
System Design Submission
Report 2: System Implementation
Test 2 Score
Tutorial_Lab_Marks
Coursework Overall Marks
14 October - 20 October
Course Planner
Week1_DatabaseSystems
Group Project
Tutorial 1
21 October - 27 October
Week2_DataModels
Tutorial 1
28 October - 3 November
Week3_Relational Data Model
Lab 01
How to install Oracle
4 November - 10 November
Week 4_Entity Relationship Model
Week4_Lab02
Homework Please draw two ERD diagrams
11 November - 17 November
Week5_Advanced Data Modelling
Week5_Lab03
Revision 1
Revision 1 Submission
Revision 2
Revision 3_Chapter 02 MCQ
Revision 4 _Chapter 03 MCQ
Revision 4
18 November - 24 November
Week6_Data Normalization
Week6_Lab04
25 November - 1 December
Week7_Lab05
Week7_DataNormalization_Part2
Lab 05 SQL File
2 December - 8 December
9 December - 15 December
Week9_IntroductionToSQL 26.12 Page 39
Week9_Tutorial
16 December - 22 December
Week10_IntrotoSQLPart2
Week10_Lab06
SQL Zoo
Practice 1 Link
Practice 1 Answers
Practice 2 NOBEL Database
Answer for Nobel Database
23 December - 29 December
Week11_ADV Sql Part1
Week11_Tutorial_26.12.2024
Week11_SQLFile1
Week11_SQLFIle2
SQL Zoo Join Operation
Sum and Count function
Answer for SUM and COUNT -SQL Zooo
Answer for JOIN operation -SQL Zoo
30 December - 5 January
Week12_Lab
Week12_Sample Images
Week12_ADVSQLPart2
Test 2 Revision
6 January - 12 January
SQL Revision
Week13_Distributed Database
Week 13_Lab
13 January - 19 January
Week14_Distributed Database
Week14_Database Current Topics
Week14_Tutorial
Week14(a) Tutorial
Week14_Tutorial Resources
Distributed Database Revision file
CMT Assignment Presentation template
Presentation Schedule
Lab 08
20 January - 26 January
Mock Exam Paper
Quick Revision Part 1(Q)
Quick Revision Part 1 (QMS)
Quick Revision Part 2
MockExam_Answer
Next
Side panel
Categories
All categories
ADMIN
APPLIED SCIENCES
SCHOOL OF HOUSING, BUILDING & PLANNING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF PHARMACEUTICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF INDUSTRIAL TECHNOLOGY
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF COMPUTER SCIENCES
Semester I
Semester II
Semester I & II
KSCP
APPLIED ARTS
SCHOOL OF MANAGEMENT
Semester I
Semester II
Semester I & II
KSCP
GRADUATE SCHOOL OF BUSINESS
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF EDUCATIONAL STUDIES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF COMMUNICATION
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF ARTS
Semester I
Semester II
Semester I & II
KSCP
PURE ARTS
SCHOOL OF LANGUAGES, LITERACIES AND TRANSLATION
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF HUMANITIES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF SOCIAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
PURE SCIENCES
SCHOOL OF CHEMICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF MATHEMATICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF BIOLOGICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF PHYSICS
Semester I
Semester II
Semester I & II
KSCP
ENGINEERING
SCHOOL OF MATERIALS & MINERAL RESOURCES ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF ELECTRICAL & ELECTRONIC ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF CIVIL ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF MECHANICAL ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF AEROSPACE ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF CHEMICAL ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
DENTAL
SCHOOL OF DENTAL SCIENCES
UNDERGRADUATE
YEAR 5
YEAR 4
YEAR 3
YEAR 2
YEAR 1
POSTGRADUATE
DOCTOR DPH
Semester I
Semester II
Semester I & II
MASTER DPH
Semester I
Semester II
Semester I & II
LECTURER
MEDICAL
SCHOOL OF MEDICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
HEALTH
SCHOOL OF HEALTH SCIENCES
Semester I
Semester II
Semester I & II
KSCP
OTHERS
INSTITUTE OF NANO OPTOELECTRONICS RESEARCH AND TECHNOLOGY (INOR)
Semester I
Semester II
Semester I & II
INSTITUTE FOR RESEARCH IN MOLECULAR MEDICINE (INFORMM)
Semester I
Semester II
Semester I & II
KSCP
COLLABORATIVE MICROELECTRONIC DESIGN EXCELLENCE CENTRE
Semester I
Semester II
CENTRE FOR ISLAMIC DEVELOPMENT MANAGEMENT STUDIES (ISDEV)
Semester I
Semester II
Semester I & II
NATIONAL ADVANCED IPV6 CENTRE (NAV6)
Semester I
Semester II
WOMEN'S DEVELOPMENT RESEARCH CENTRE
Semester I
CENTRE FOR GLOBAL SUSTAINABILITY STUDIES
Semester I
Semester II
ADVANCED MEDICAL & DENTAL INSTITUTE
Semester I
Semester II
Semester I & II
KSCP
CO-CURRICULUM
Semester I
Semester II
Semester I & II
CENTRE FOR DRUG RESEARCH
Semester I
CENTRE FOR ARCHAELOGICAL RESEARCH
Semester I
Semester II
CENTRE FOR INSTRUCTIONAL TECHNOLOGY & MULTIMEDIA
Semester I
Semester II
Semester I & II
KSCP
SPLIT COURSES
Semester I
Semester II
Semester I & II
CENTRE FOR POLICY RESEARCH (CenPRIS)
Semester I
Semester II
Category 2
Category 1
Home
ePortfolio Mahara
Teaching Assessment
Helpdesk
Contact Us
Elearn USM Support Center
Library
Website
OPAC
ePerpustakaan
Course Reserve
Reference & Academic Support
Research Data Management
Proquest eBook Central
Open Educational Resources (OER)
Open Science
USM Library TV
Library Guides
ProQuest Dissertations and Theses (PQDT)
Course Search
Log in
Please login using USM Identity
Login For Admin/Guest
Categories
Collapse
Expand
All categories
ADMIN
APPLIED SCIENCES
SCHOOL OF HOUSING, BUILDING & PLANNING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF PHARMACEUTICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF INDUSTRIAL TECHNOLOGY
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF COMPUTER SCIENCES
Semester I
Semester II
Semester I & II
KSCP
APPLIED ARTS
SCHOOL OF MANAGEMENT
Semester I
Semester II
Semester I & II
KSCP
GRADUATE SCHOOL OF BUSINESS
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF EDUCATIONAL STUDIES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF COMMUNICATION
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF ARTS
Semester I
Semester II
Semester I & II
KSCP
PURE ARTS
SCHOOL OF LANGUAGES, LITERACIES AND TRANSLATION
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF HUMANITIES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF SOCIAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
PURE SCIENCES
SCHOOL OF CHEMICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF MATHEMATICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF BIOLOGICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF PHYSICS
Semester I
Semester II
Semester I & II
KSCP
ENGINEERING
SCHOOL OF MATERIALS & MINERAL RESOURCES ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF ELECTRICAL & ELECTRONIC ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF CIVIL ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF MECHANICAL ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF AEROSPACE ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
SCHOOL OF CHEMICAL ENGINEERING
Semester I
Semester II
Semester I & II
KSCP
DENTAL
SCHOOL OF DENTAL SCIENCES
UNDERGRADUATE
YEAR 5
YEAR 4
YEAR 3
YEAR 2
YEAR 1
POSTGRADUATE
DOCTOR DPH
Semester I
Semester II
Semester I & II
MASTER DPH
Semester I
Semester II
Semester I & II
LECTURER
MEDICAL
SCHOOL OF MEDICAL SCIENCES
Semester I
Semester II
Semester I & II
KSCP
HEALTH
SCHOOL OF HEALTH SCIENCES
Semester I
Semester II
Semester I & II
KSCP
OTHERS
INSTITUTE OF NANO OPTOELECTRONICS RESEARCH AND TECHNOLOGY (INOR)
Semester I
Semester II
Semester I & II
INSTITUTE FOR RESEARCH IN MOLECULAR MEDICINE (INFORMM)
Semester I
Semester II
Semester I & II
KSCP
COLLABORATIVE MICROELECTRONIC DESIGN EXCELLENCE CENTRE
Semester I
Semester II
CENTRE FOR ISLAMIC DEVELOPMENT MANAGEMENT STUDIES (ISDEV)
Semester I
Semester II
Semester I & II
NATIONAL ADVANCED IPV6 CENTRE (NAV6)
Semester I
Semester II
WOMEN'S DEVELOPMENT RESEARCH CENTRE
Semester I
CENTRE FOR GLOBAL SUSTAINABILITY STUDIES
Semester I
Semester II
ADVANCED MEDICAL & DENTAL INSTITUTE
Semester I
Semester II
Semester I & II
KSCP
CO-CURRICULUM
Semester I
Semester II
Semester I & II
CENTRE FOR DRUG RESEARCH
Semester I
CENTRE FOR ARCHAELOGICAL RESEARCH
Semester I
Semester II
CENTRE FOR INSTRUCTIONAL TECHNOLOGY & MULTIMEDIA
Semester I
Semester II
Semester I & II
KSCP
SPLIT COURSES
Semester I
Semester II
Semester I & II
CENTRE FOR POLICY RESEARCH (CenPRIS)
Semester I
Semester II
Category 2
Category 1
Home
ePortfolio Mahara
Teaching Assessment
Helpdesk
Collapse
Expand
Contact Us
Elearn USM Support Center
Library
Collapse
Expand
Website
OPAC
ePerpustakaan
Course Reserve
Reference & Academic Support
Research Data Management
Proquest eBook Central
Open Educational Resources (OER)
Open Science
USM Library TV
Library Guides
ProQuest Dissertations and Theses (PQDT)
Course Search
APPLIED SCIENCES
SCHOOL OF COMPUTER SCIENCES
Summary
Course info
CMT221W ORGANISASI & REKA BENTUK PANGKALAN DATA (DATABASE ORGANISATIONS AND DESIGN)
Lecturer:
CIK SHYAMALA A/P NADARAJAN
Lecturer:
DR. AZLEENA BINTI MOHD KASSIM
Lecturer:
DR. HAZRINA BINTI YUSOF HAMDANI
Skill Level
:
Beginner
