TIS3351: This is an individual assignment STRICTLY NO COPYING from other sources except codes given in this course If detected all parties involved will get 0 marks: Advanced Database Assignment, MMU, Malaysia

University Multimedia University (MMU)
Subject TIS3351: Advanced Database

Individual Assignment

This is an individual assignment. STRICTLY NO COPYING from other sources except codes given in this course. If detected all parties involved will get 0 marks.

Assignment

In this assignment, designed and implement an operational data store and a data warehouse with an ETL (Extract, Transform, Load) scheme for the Faculty of Computing and Informatics at Multimedia University.

The main entities to be modelled include but are not limited to students, lecturers, Courses, and Assessment Marks. Add more entities if needed. Attributes related to the Student should include high school, state of origin, SPM or UEC results, gender, and age. Attributes related to Lecturer should include the highest qualification, major, age, and academic post.

Are You Searching Answer of this Question? Request Malaysian Writers to Write a plagiarism Free Copy for You.

GPA and CGPA need not be captured in this assignment.

There are three parts to implement.

Part 1

Draw the Entity-Relationship Diagram (ERD) of the operational data stored in the third normal form and convert the ERD to a relational schema. Describe any design assumptions made. Implement the relational schema with an SQL script file. Insert sufficient example data for thirty students, nine courses (three for each trimester for trimesters 1, 2, and 3 ), and six lecturers.

Part 2

Draw the ERD of the data warehouse and convert the ERD to a relational schema. Implement the data warehouse with an SQL script file. Implement an ETL scheme with one or multiple SQL script files, one script file for each trimester, to extract data from the operational data store and load them into the data warehouse. If needed, create and drop temp tables during the ETL process. An ETL operation is to be run every trimester.

Part 3

Implement five possible queries for the data warehouse. Assume the queries are used by the President of MMU to gain an insight into the current state of MMU from various perspectives.

Deliverables

a) ERD
b) Relational schema
c) Design assumptions made
d) SQL scripts
e) The corresponding SQL output text

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

Get Help By Expert

We offer the best homework help in Malaysia. Our team of expert homework writers are highly trained and experienced to deliver top-quality solution on information technology assignments on time with accurate spelling, and grammar that will help you to get a higher rank in your database assignments.

Answer

Recent Solved Questions

Online Exam & Assignment Writing Services

11770+ Orders Delivered

4.9/5
5 Star Rating

Confidential & Secure Assignment Help For

Group Assignment Help

Online Exam -Test & Quiz

Cheapest Price Quote

Diploma & Certificate Levels

Semester & FYP Papers

Summative & Individual

GBA & Reflective

Last Minute Assistance

Sample Assignment Download

MKT410 Introduction to marketing UiTM assignment example Malaysia
Marketing is the process of influencing consumer behavior to reach and satisfy customer needs. This includes providing products, information, or services that will have value for consumers in exchange for…
Marketing
BCM413 Builder Quantities And Estimating I UITM Assignment Sample Malaysia
The BCM413 Builder Quantities And Estimating I course provides students with a comprehensive introduction to the processes of evaluating project costs, measuring and counting materials and labor, and cost estimating.…
Assignment Sample

UP TO 15 % DISCOUNT

Instant Paper Writing Services by Native Malaysia Writers

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now

Get Assistance for Assignments, online Exam, and Projects Writing