Hi please i need support to create my project for Advanced Database Technologies please see the attached files

Computer and Information System Coursework Assessment

201920

Course	CIB3403- Advanced Database Technology
Assessment Method	Group Project
Date of Assessment	Week 14	Duration / Deadline(s)
Maximum Mark	100	Percentage of Final Grade	25%

Instructions to Students

This is an open book assessment.
This exam paper has 3 pages including the cover page.
Answer ALL questions.

Student HCT ID	Student Name	Signature

GROUP PROJECT RUBRIC

CLO3: Analyze current and emerging database technologies used in information storage, retrieval and analysis.
Criteria	Max Marks	Below Expectations [Weight *]	Meets Expectations [Weight *]	Exceeds Expectations [Weight *]
a. Analyze DM, TM, and WM results using RapidMiner	6	[3 points] The student was unable to properly solve the data mining problem and use RapidMiner	[5 points] The student was able to define the DM problem without finding the solution using RapidMiner.	[6 points] The student showed a full mastery of DM problem definition and solving using RapidMiner.
b. Experiment the start schema for the design and development of data warehousing using Advanced SQL Queries to extract data	6	[3 points] The student did not design the correct star schema of the data warehouse and didn’t find the correct SQL queries	[5 points] The student was able to design the start schema of the data warehouse however the SQL queries are not all correct	[6 points] The student have proposed a full correct start schema and implemented the required SQL queries
Subtotal	12
CLO4: Demonstrate the impact of enterprise data analytic tools on organizational performance.
a. Describe Decision Support System Concepts & Technologies, and types	8	[4 points] The student did not correctly describe DSS facets (concepts, technologies, and types)	[6 points] The student was able to correctly describe some DSS facets (concepts, technologies, and types)	[8 points] The student described fully and correctly all the DSS facets (concepts, technologies, and types)
b. Apply What if analysis, Goal seeking, and Pivot Tables to real cases.	20	[10 points] The student wasn’t successful in	[17 points] The student was able to successfully	[20 points] The student showed a full mastery

		applying any of the scenario management techniques nor Pivot Tables on the proposed case	apply some scenario management techniques or Pivot Tables on the proposed case	of applying all scenario management techniques and Pivot Tables on the proposed case
c. Construct a dashboard for a business performance management system using Tableau	10	[5 points] The student did not properly use Tableau to construct the dashboard of the proposed case.	[8 points] The student showed a partial understanding and usage of Tableau to construct the dashboard of the proposed case.	[10 points] The student showed a full understanding and usage of Tableau to construct the dashboard of the proposed case.





Subtotal	38
Project Group Mark	50

INDIVIDUAL PRESENTATION / DEFENSE

Criteria	Max Marks	Below Expectations [Weight *]	Meets Expectations [Weight *]	Exceeds Expectations [Weight *]
CLO3: Analyze current and emerging database technologies used in information storage, retrieval and analysis. Analyze DM, TM, and WM results using Rapid Miner Experiment the start schema for the design and development of data warehousing using Advanced SQL Queries to extract data Sample of questions during viva: What is your contribution to the group when analyzing the DM problem using Rapid Miner? How did you discuss your finding from (b) and conclude the result among team members? If you have more time to improve your deliverables, which part you will enhance? Highlight the importance of the work you did in the project.	12	[6 points] Explanation and reasoning is wholly lacking, unable to verify contribution to the task assigned or demonstrate a total misunderstanding of the assignment task.	[10 points] Explanation and reasoning related to task conducted and teamwork contribution is reasonable or logically placed with evident of key points but significantly lacking in support.	[12 points] All explanation and reasoning related to the task conducted and teamwork contribution is above standard with most main points are backed-up with sufficient supporting evidence and examples as required.
CLO4: Demonstrate the impact of enterprise data analytic tools on organizational performance. Describe Decision Support System Concepts & Technologies, and types Apply What if analysis, Goal seeking, and Pivot Tables to real cases. Construct a dashboard for a business performance management system using Tableau. Sample of questions during viva: How was your interaction with your teammates while constructing the dashboard? Do you have some pending concerns (non-solved issues) with your group members? As it is the easiest part, how was the management of your group in part (d)?	38	[19 points] Clear relying of the student on other group members. All the answers are vague and ambiguous. The student was unable to situate his contribution to the whole project.	[31 points] The student was able to situate his contribution to the whole project. Some answers are vague and ambiguous.	[38 points] The student justified a clear and valuable contribution to the group. He showed full respect to his teammates and full mastery of technical and nontechnical requirements of the project.
Subtotal	38
Project Group Mark	50

FINAL GRADE PROJECT SCORE:

	STUDENT 1	STUDENT 2	STUDENT 3	STUDENT 4
Total Group Project Score:
Total Individual Oral VIVA / Oral Defense:
Final Score

C I S 2 0 1 9 2 0 C I B 3 4 0 3 G r o u p P r o j e c t V 3

P a g e 1 | 3