# data[].attributes.body
Week4-Task (LAB-GROUP)

Task:
Perform LAB exercise 3 & 4.

Action / Activity:
1. Read LAB Manual.
2. Discuss with your team members
3. Using DB2 command window-Administrator(DB2) OR PhpMyAdmin (MySQL), perform LAB Exercise #.
3. Print/screenshot or save your answer in PDF
4. Upload in your E-Portfolio individually.
5. Turn in your task via Google Classroom.

Date of submission = 15/11/2021

# data[].attributes.body
​Task:​

Install DB2 (Express C Edition) in your workstation.

​Action / Activity:​

1. Follow the installation steps.

2. Run installation.

3. Send a video to prove that you manage to install the DB2 (duration of video must less than 1 minute)

4. Keep/Update your Week1 Task(Lab) in your E-Portfolio.

Date of submission = 24/10/2021.

# data[].attributes.body
Week2-Task (Lab)

20/10/2021 - RCS1103D
21/10/2021 - RCS1103C & RCS1435A

Task:
Perform LAB exercise 1.

Action / Activity:
1. Read Lab Manual.
2. Using DB2 command window-Administrator(DB2) OR PhpMyAdmin (MySQL), perform LAB Exercise 1.
3. Print/screenshot or save your answer in PDF
4. Upload in your E-Portfolio.
5. Turn in your task via Google Classroom.

Date of submission = 26/10/2021

# data[].attributes.body
Week1 Task - 12/10/2021

​Task:​

1. Explain why database design is important.
2. What are the problems exist with the file system data management? Discuss (TWO) of them.

​Action / Activity:​
1. Please answer the questions.

2. Using your creativity, create your e-portfolio using Google Sites or Padlet. Follow the tutorial given.

3. Keep/Update your task in your E-Portfolio.

4. Insert your E-Portfolio link at the E-Portfolio Task shelf.

Date of submission = 18/10/2021

# data[].attributes.body
1.  Explain why database design is important.
Database management systems or database designs are essential because they offer an efficient way of handling large amounts and multiple types of data. The ability to access data efficiently allows us to make informed decisions quicker.

2.  What are the problems exist with the file system data management? Discuss (TWO) of them.
> Limited User Access
Flat-file systems usually do not support access for multiple users. This means that multiple users at different workstations cannot access the same data simultaneously, limiting access to important data if multiple users search for the same data at the same time

> Lack of Transactions
Requesting data from a flat-file database simply retrieves data from a single file. Requesting and retrieving data from various files at the same time (called a "transaction") is impossible. This means that complex requests that make data retrieval accurate and efficient simply do not exist.

# data[].attributes.body
Week3-Task

Group Task:
Discuss your Group Project proposal.

Action / Activity:
1. Read the project description in Group Project shelf.
2. Discuss with your team members and start planning and draft your Database Project Proposal.
3. Team leader has to turn in the task documents in PDF format via Google Classroom.

Date of submission:
- Project Proposal = 9//11/2021

# data[].attributes.body
Week7-Task (Group)

Task:
With reference to the slides & videos(additional resources) of Chapter 2 & Chapter 3, perform:
- Tutorial 1: Business Rules
- Tutorial 2: ERD

Action / Activity:
1. Discuss with your team members and perform the task given.
2. Team leader has to turn in the task documents in PDF format via Google Classroom.
3. Publish it in your e-portfolio/padlet.
4. Lecture Week 8, sharing session:
- Group 6 (Tutorial 1: Business Rules)
- Group 2 (Tutorial 2: ERD)

Submission due date = 6/12/2021

# data[].attributes.attachment_link.title
Tutorial 1 - Business Rules ICT200 Group 9

# data[].attributes.body
>>>Click the image to see the instructions

Task (Group Project):
Database Project Application (8%)
- Prepare 10 questions on DML for your project.

Action / Activity:
Include the questions in your Database Project Application report.

Date of submission = 9/1/2022

# data[].attributes.attachment_link.title
Instruction for Database Project Application.pdf

# data[].attributes.attachment_link.title
Normalization - Assignment 1 ICT200 Group 9

# data[].attributes.body
Tutorial 5

# data[].attributes.attachment_link.title
Normalization - Assignment 1 ICT200 Group 9