Course Content
- Start Date: 20/02/23
- Category: IBSU Information Technology S1
- Announcement
- Timetable
- Unit Information Guide
- Staff Contact Details & Timetable
- Assessment:1- Quiz-1 (Assessable-New) 5%
- Assessment-1: Quiz-2 (5%)
- Assessment 2 - Case Analysis
- assessmenttemplate
- Assessment 3 - Case Analysis
- Unit Resources
- Assessment Resources
- Attendance
- Attendance
- Unit Evaluation
- Lecturer Evaluation Week 6 - Database Management Systems
- Lecturer Evaluation Week 11 - Database Management Systems
- Unit Survey Week 8-13 - Database Management Systems
- IBS Comments and Suggestion Box Online
- Final Exam
- Survey on Study Progression
- Please read this week topic-slides and do the acti... (copy)
- Readings (copy) (copy)
- Required Reading Coronel, C. & Morris S. ...
- Supplementary Reading1. &nb...
- This week's lecture (copy)
- Topic 1 - Introduction to DBMS (copy)
- Activities (copy)
- Components of Database Environment
- Features of database system
- Reminder (copy)
- Do the activities given for this topic and ensure ...
- Please read this week topic-slides and do the acti... (copy) (copy) (copy)
- Readings
- Required Reading Coronel, C. & Morris S. ... (copy)
- Supplementary Reading1. &nb... (copy)
- This week's lecture
- Topic-2 ER Model Lecture Slides
- Activities
- Match : Attributes and their types
- Activity ER model
- Reminder (copy) (copy)
- Do the activities given for this topic and ensure ... (copy)
- Please read this week topic-slides and do the acti... (copy) (copy)
- Readings
- Required Reading Coronel, C. & Morris S. ... (copy) (copy)
- Supplementary Reading1. &nb... (copy) (copy)
- This week's lecture
- Topic-3 Relational Model Lecture Slides
- Activities
- Database schema and instances
- Activity 2.1 Codd's 12 rule of relational database
- Reminder
- Do the activities given for this topic and ensure ... (copy) (copy)
- Please read this week topic-slides and do the acti... (copy) (copy) (copy)
- Readings (copy) (copy)
- Required Reading Coronel, C. & Morris S. ... (copy) (copy) (copy) (copy)
- Supplementary Reading1. &nb... (copy) (copy) (copy)
- This week's lecture (copy) (copy)
- Topic-4 Structured Query language- Lecture Slides
- Activities (copy)
- Data types
- SQL commands
- Reminder (copy) (copy)
- Do the activities given for this topic and ensure ...
- Readings (copy) (copy)
- Please read this week topic-slides and do the acti... (copy) (copy) (copy) (copy)
- Required Reading Coronel, C. & Morris S. ... (copy) (copy) (copy) (copy)
- Supplementary Reading1. &nb... (copy) (copy) (copy) (copy)
- This week's lecture (copy) (copy)
- Topic-5 Normalization Lecture Slides
- Topic-5 Normalization lecture notes
- Activities (copy) (copy)
- Activity 5.1 Normalization
- 5. 2 Normalization rules
- Reminder (copy)
- Do the activities given for this topic and ensure ...
- Readings (copy) (copy) (copy) (copy)
- Please read this week topic-slides and do the acti... (copy) (copy) (copy) (copy) (copy)
- Required Reading Coronel, C. & Morris S. ... (copy) (copy) (copy) (copy) (copy)
- Supplementary Reading1. &nb... (copy) (copy) (copy) (copy) (copy)
- This week's lecture (copy) (copy)
- Topic -6 RAID storage
- Activities (copy) (copy) (copy)
- activity 6.1 RAID
- activity 6.2 RAID levels
- Reminder (copy) (copy)
- Do the activities given for this topic and ensure ...
- Revision test
- Readings (copy) (copy) (copy) (copy)
- Please read this week topic-slides and do the acti... (copy) (copy) (copy) (copy) (copy) (copy)
- Required Reading Coronel, C. & Morris S. ... (copy) (copy) (copy) (copy) (copy) (copy)
- Supplementary Reading1. &nb... (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- This week's lecture (copy) (copy) (copy)
- Topic-7 Hashing Lecture Slides
- Activities (copy) (copy) (copy) (copy)
- Hashing
- Hashing types
- Reminder (copy) (copy) (copy)
- Do the activities given for this topic and ensure ... (copy)
- Readings (copy) (copy) (copy) (copy)
- Please read this week topic-slides and do the acti... (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- Required Reading Coronel, C. & Morris S. ... (copy) (copy) (copy) (copy) (copy) (copy)
- Supplementary Reading1. &nb... (copy) (copy) (copy) (copy) (copy) (copy)
- This week's lecture (copy) (copy)
- Topic-8 Data Warehousing Lecture Slides
- Activities (copy) (copy) (copy) (copy) (copy)
- Data Warehouse characteristics
- Difference between data warehouse and database
- Reminder (copy) (copy) (copy) (copy) (copy)
- Do the activities given for this topic and ensure ... (copy) (copy)
- Readings (copy) (copy) (copy) (copy)
- Please read this week topic-slides and do the acti... (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- Required Reading Coronel, C. & Morris S. ... (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- Supplementary Reading1. &nb... (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- This week's lecture (copy) (copy)
- Topic-9 Database administration
- Activities (copy) (copy) (copy) (copy) (copy) (copy)
- activity 9.1 Functions of data and database administrator
- Activity 9.2- Restore and recovery
- Reminder (copy) (copy) (copy) (copy)
- Do the activities given for this topic and ensure ...
- Readings (copy) (copy) (copy)
- Please read this week topic-slides and do the acti... (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- Required Reading Coronel, C. & Morris S. ... (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- Supplementary Reading1. &nb... (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- This week's lecture (copy)
- TOPIC-10 Distributed Database
- Activities (copy) (copy) (copy) (copy) (copy) (copy) (copy)
- Activity 10.1
- Activity 10.2 replication
- Revision test2
- Reminder (copy) (copy) (copy) (copy) (copy)
- Do the activities given for this topic and ensure ...
- Summary Notes