PENYERAHAN DAN PENILAIAN TUGASANASSIGNMENT SUBMISSION AND ASSESSMENT

_________________________________________________________________________KOD KURSUS /COURSE CODE : CBDA2103TAJUK KURSUS /COURSE TITLE : DATA ANALYSIS AND MODELINGSEMESTER /SEMESTER : JAN 2013_________________________________________________________________________

ARAHAN KEPADA PELAJAR / INSTRUCTIONS TO STUDENTS

1. Tugasan ini mengandungi SATU (1) soalan sahaja yang disediakan dalam bahasa modul bercetak kursus ini. / This assignment contains only ONE (1) question that is set in the language of the printed module for the course.

2. Jawab dalam Bahasa Melayu atau Bahasa Inggeris. / Answer in Malay or English.

3. Muat turunkan templat tugasan versi bahasa yang berkenaan daripada MyVLE untuk penyediaan dan penyerahan tugasan anda. Tugasan anda hendaklah ditaip dengan menggunakan Times New Roman fon saiz 12 dan langkau 1.5. baris/ Download the language version of the assignment template concerned from the MyVLE for preparation and submission of your assignment. Your assignment should be typed using 12 point Times New Roman font and 1.5 line spacing.

4. Tugasan anda hendaklah antara 2500 hingga 3000 patah perkataan tidak termasuk rujukan. Bilangan perkataan hendaklah ditunjukkan di hujung tugasan anda. Jangan salin soalan dan arahan tugasan dalam jawapan anda. / Your assignment should be between 2500 to 3000 words excluding references. The number of words should be shown at the end of your assignment. Do not copy the assignment question and instructions to your answer.

5. Anda dikehendaki menghantar tugasan SECARA ONLINE melalui MyVLE. Sila rujuk kepada portal untuk arahan mengenai prosedur menghantar tugasan anda secara on-line. Anda dinasihatkan menyimpan senaskah tugasan yang diserahkan untuk rujukan sendiri. / You must submit your assignment ONLINE via the MyVLE. Refer to the portal for instructions on the procedures to submit your assignment on-line. You are advised to keep a copy of your submitted assignment for personal reference.

6. Anda hanya boleh menghantar tugasan SEKALI sahaja dalam SATU fail. / You can submit your assignment ONCE only in a SINGLE file.

7. Tugasan anda hendaklah diserahkan pada 26hb Feb. hingga 10hb Mac 2013. Serahan selepas 10hb. Mac TIDAK akan diterima. / Your assignment must be submitted between 26th Feb. and 10th March 2013. Submission after 10th March will NOT be accepted.

8. Tugasan hendaklah disiapkan secara individu. Anda dilarang meniru tugasan orang lain. Anda juga dilarang sama sekali memplagiat kerja orang lain sebagai kerja sendiri. /Your assignment should be prepared individually. You should not copy another person’s assignment. You should also not plagiarise another person’s work as your own.

PENILAIAN / EVALUATION

Tugasan ini menyumbang sehingga 40% daripada jumlah markah kursus berkenaan dan akan dinilai berdasarkan kepada Rubrik yang dilampirkan. / This assignment accounts for 40% of the total marks for the course and shall be assessed based on the Rubrics attached .

Anda akan diberikan maklum balas tentang tugasan ini sebelum Peperiksaan Akhir Semester bermula / You would be given feedback on the assignment before the Final Semester Examination commences.

PLAGIARISME: POTONGAN MARKAH / PLAGIARISM: MARKS DEDUCTION

Amaran: Tugasan yang diserahkan, secara automatik, akan disemak untuk menentukan kadar pertindihan. Jika plagiarisme dikesan, markah akan dipotong seperti berikut: / Warning : The submitted assignment will automatically undergo a similarity check. If plagiarism is detected, marks would be deducted as follows:

Tugasan dengan pertindihan kandungan antara 10 - 30%: potongan 20% daripada jumlah markah yang diperoleh.

Tugasan dengan pertindihan kandungan antara 31 - 50%: potongan 40% daripada jumlah markah yang diperoleh.

Tugasan dengan pertindihan kandungan lebih daripada 50%: Markah sifar akan diberikan. Assignments with 10 - 30 % overlap with others: 20% deduction from the total marks scored. Assignments with 31 - 50 % overlap with others: 40% deduction from the total marks scored. Assignments with more than 50% overlap with others: Zero mark would be given.

SOALAN TUGASAN /ASSIGNMENT QUESTION

This question is intended to help you to understand the problem specification before designing a proper ERD for a new database system. As such, you are required to choose ONE (1) of the following applications:

i)Online Ticketing Applicationii)Hotel Booking Applicationiii)Car Rental Application

Then, answer each of the following questions:

a) Prepare a brief proposal for the chosen application by including the following items:

i. Describe the primary objective of proposed system. (Describe the objective clearly, in at least one or two paragraphs)

ii. Describe ONE (1) potential process from the chosen application that can be operated by using a database system (e.g.: registration process, billing process, scheduling process, handling process, or any simple process that can be used to keep track of record inside the application).

iii. Identify and describe clearly at least FIVE (5) primary data involved in this application.

[Marks: 15 Marks]

b) Based on the proposed application above:

i. List out FIVE (5) main entities that could be included in the application complete with their attributes (at least two).

(Note: each entity should have at least one primary key.)

ii. Identify the relationship between all entities complete with their cardinalities.

iii. Draw a complete Entity Relationship Diagram (ERD) by using the entities and attributes that have been identified above. Make sure you clearly identify the relationships between the entities and their cardinality.

Note: For information regarding the ERD shapes, refer to the CBDA2103 module (Topic 4).

[Marks: 25 Marks]

(40 marks)

MUKA SURAT TAMAT / END OF PAGE

LAMPIRAN / ATTACHMENT

RUBRIK TUGASAN / ASSIGNMENT RUBRICS

Criteria WeightPoor

(0 Mark)Weak

(1 Mark)Moderate(2 Marks)

Good(3 Marks)

Excellent(4 Marks)

Total Marks (Max)

The primary objective of proposed system

1.25

- No primary objective given.

- Primary objective given was incorrect.

- Primary objective given was correct but ambiguous and not suitable with the chosen application.

- Primary objective given was correct and suitable with chosen application.

- Primary objective given was correct, clear, precise and suitable with chosen application.

5

Potential Process Determination 1.25

- No business process given.

- Business process given was incorrect.

- Business process given was correct but ambiguous and not suitable with the chosen environment.

- Business process given was correct and suitable with the chosen environment.

- Business process given was correct, clear, precise and suitable with the chosen environment.

5

Primary Data determination 1.25

- Not given at all. - Only one relevant primary data was given.

- 2 or 3 relevant primary data were given.

- 4 relevant primary data were given with complete description.

- 5 or more relevant primary data were given with complete description.

5

Entity determination 1.25

- Not given at all. - Only one relevant entity was given.

- 2 or 3 relevant entities were given.

4 relevant entities were given with relevant attributes.

- 5 or more relevant entities were given. 5

Attributes determination 1.25

- Not given at all. - Only one or two entities have relevant attributes.

- 2 or 3 entities with relevant attributes were given.

- 4 entities with were given relevant attributes.

- All entities were given with relevant attributes. 5

key determination 0.5 - Not given at all. - Key given for each

entity is irrelevant. - Relevant key given for some entities.

- A relevant key given for most entities.

- All entities have their unique key.

2

Relationship and Cardinalities Determination

1.25

- Not given at all. - Only one correct relationship given without cardinality.

- Only one or two correct relationships were given.

- Only some relationship has correct cardinality.

- Each entity (as identified in the previous question) has correct relationship.

- Only some relationship has correct cardinality.

- Each entity (as identified in the previous question) has correct relationship.

- Each relationship has correct cardinality.

5

Draw complete Entity-Relationship Diagram (ERD) for the database chosen.

2

- No diagram. - ERD given incorrect. - ERD given only has entities without any attributes or relationship.

- ERD given not complete with all entities, attributes, relationship and cardinalities as defined in the previous question.

- A complete ERD drawn with all entities, attributes, relationships and cardinalities as defined in the previous question.

– used correct arrangement of diagram.

8

Total Points/ Marks

10 40