Faculty of Computing & Records Technology Session: 4, 2025 Lecturer: Dr Fenghui Ren Scope The objectives of Task 2 comprise conceptual modelling of an knowledge warehouse, implementation of 0NF tables in HQL, implementation of exterior tables in HQL, and querying an knowledge cube. This project is due on 6 November 2025, by 9:00 pm Singaporean Time (ST). This project is rate 20% of the whole review in the field. The project contains 4 initiatives, and the specification of each and each task begins from a brand unusual page. Simplest digital submission through Moodle at: https://moodle.uowplatform.edu.au/login/index.php will be permitted. E mail submissions is maybe not permitted. A submission design is explained on the shatter of Task 2 specification. A protection relating to slow submissions is included in the field outline. Simplest one submission of Task 2 is allowed and easiest one submission per scholar is permitted. A slow submission penalty (25% of the whole designate) will be applied for every and each 24 hours slow. A submission that contains an inaccurate file linked is treated as a upright submission with all consequences coming from the review of the file linked. All recordsdata left on Moodle in a relate “Draft(not submitted)” is maybe not evaluated. The 2nd project is a person project and it is miles expected that every body its initiatives will be solved in my opinion with none cooperation with the various students. Then again, it is miles allowed to reveal in the submission feedback that a particular factor or task of this project has been implemented in cooperation with another scholar. In one of these case review of a task or factor is probably shared with another scholar. In all various cases plagiarism will lead to a FAIL grade being recorded for whole project. In case you would perchance merely contain any doubts, questions, etc. please consult your lecturer or tutor for the interval of laboratory/tutorial lessons or over e-mail. Write My Task Hire a Official Essay & Task Writer for winding up your Tutorial Assessments Native Singapore Writers Personnel 100% Plagiarism-Free Essay Easiest Pride Rate Free Revision On-Time Supply Job 1 (5 marks) Intuitive manufacture of an knowledge cube from a conceptual schema of an operational database A bus transportation firm maintains an operational database, that contains knowledge in regards to the contemporary places of the busses owned by the firm. A contemporary set of a bus is for sure by a visit segment a bus passes through, in a 2nd. A amble contains a series of amble segments. A bus can traverse a visit in each and each instructions. It is critical to reveal, that the operational database contains easiest “point-in-time” knowledge. At any time when a bus strikes to the following segment all knowledge about its previous places (on the previous segments) is eliminated from a database. The last contents of an operational database is in line with a conceptual schema given below. The firm would wish to implement an knowledge warehouse that is probably previous to implement the following gains. accept the whole alternative of kilometers travelled by each and each bus per yr, per thirty days per day. accept the whole alternative of journeys conducted per bus, per driver, per yr, per thirty days, per day. accept the whole alternative of drivers per amble. accept the whole alternative of buses run per amble segment, per amble, per yr, per thirty days per day. accept a mean interval of bus run per amble segment, per amble, per yr, per thirty days per day. accept the whole fuel consumption per amble segment, per amble, per bus model, per manufacturer, per yr, per thirty days, per day. accept the whole alternative of journeys per bus, per depot, per metropolis accept the whole alternative of passengers per segment, per amble, per yr, per thirty days per day. (This task cannot be implemented. Missing knowledge on the alternative of passengers.) accept the largest alternative of passengers per bus, per amble, (This task cannot be implemented. Missing knowledge on the alternative of passengers.) accept a mean alternative of passengers per amble. (This task cannot be implemented. Missing knowledge on the alternative of passengers.) Notify a transient explanation of a database domain and a conceptual schema given above, to search out an knowledge cube, that can contain to be implemented by the bus firm to manufacture an knowledge warehouse. In your specification of an knowledge cube, checklist the information, the measures, the names of dimensions and the hierarchies. Pick any three dimensions from an knowledge cube model in the previous step and not not as much as 4 values in each and each dimension and one measure to design a sample three-d knowledge cube in a standpoint look equal to a look included in a presentation 09 Records Warehouse Ideas, race 6. Deliverables A file solution1.pdf that contains a specification of knowledge cube as a checklist of information, measures, dimensions, and hierarchies received as a outcomes of task (1), a standpoint drawing of three-d knowledge cube as a outcomes of task (2). Job 2 (5 marks) Conceptual modelling of an knowledge warehouse An goal of this task is to manufacture a conceptual schema of a sample knowledge warehouse domain described below. Be taught and analyse the following specification of an knowledge warehouse domain. A huge network of car restore/repairs products and services would wish to manufacture an knowledge warehouse to retailer knowledge in regards to the products and services situated in the various cities, the autos maintained on the products and services, and the workers working on the products and services. It is miles expected that the following knowledge will be stored in the knowledge warehouse. A car restore/repairs facility is described by its set (nation, metropolis, building quantity), electronic mail deal with and cell phone quantity. The house owners lift their car to the products and services for repairs and/or maintenances. An proprietor is described by a chunky title and a special cell phone quantity. A facility retains the dates when a car changed into brought for repairs/maintenances and when it changed into peaceful by an proprietor. A car restore/repairs facility has a alternative of workers. An employee is both a mechanic or an admin person. An employee has a special employee quantity, first title, last title, and date of starting up. The repairs/maintenances are conducted by the mechanics. An Implementation of each and each restore/repairs requires an involvement of 1 mechanic. A time spent by a mechanic on a restore/repairs and all spare formulation previous are recorded for every and each restore/repairs. The ideas warehouse must accept knowledge in regards to the whole quantity days spent on restore /repairs of each and each car and the whole quantity of cash paid by an proprietor of a car for restore/repairs. A car is described by a registration quantity, manufacturer, model, and a yr when it changed into manufactured. The house owners exhaust credit rating playing cards to pay for repairs/maintenances. A bank card quantity and a title of bank that issued a card is recorded in a database. A knowledge warehouse will contain to be designed such it will contain to be probably to with out complications implement the following lessons of gains. A administration of the auto restore/repairs products and services would wish to accept from an knowledge warehouse knowledge about the whole alternative of repairs/maintenances per facility, per yr, per thirty days per day, per metropolis and per mechanic, total charges of repairs/repairs per facility, per yr, per thirty days per day, per metropolis and per mechanic, total alternative of mechanics involved per restore/repairs, per yr, per thirty days per day, per facility, per metropolis, common time spent on repairs/maintenances per yr, month, day, total alternative of formulation previous for repairs/maintenances per yr, month, day, per facility, per metropolis. To design a conceptual schema, exhaust a graphical notation explained to you in a presentation 11 Conceptual Records Warehouse Develop. To manufacture a conceptual schema of a sample knowledge warehouse domain, follow the steps listed below. Step 1 Fetch a truth entity, accept the measures describing a truth entity. Step 2 Fetch the scale. Step 3 Fetch the hierarchies over the scale. Step 4 Fetch the descriptions (attributes) of all entity forms. Step 5 Draw a conceptual schema. To design a conceptual schema, you would perchance merely contain to exhaust a graphical notation explained to you in a presentation 11 Conceptual Records Warehouse Develop. To design your map, you can exhaust UMLet map drawing system and discover a “Conceptual modelling” notation, Preference of a drawing notation is equipped in the upright upper corner of the principle menu of UMLet map drawing system. UMLet 14.3 system is probably downloaded from the field’s Moodle Internet draw in a fraction WEB LINKS. A shapely hand drawing is peaceful all upright. Deliverables A file solution2.pdf with a drawing of a conceptual schema of a sample knowledge warehouse domain. Job 3 (5 marks) Implementation of a desk with a advanced column form (0NF desk) in Hive Think that we contain a series of semi-structured knowledge that contains knowledge in regards to the students and their last studies (in a scale from 0 to 99) of the enrolled issues. The most most valuable rate in each and each row is a special scholar quantity. Next, we contain a checklist of pairs, that comprise field code and the last review in a field. 1111,CSIT111:01,CSIT121:23,CSIT101:50,CSIT235:99,ISIT312:02 1112,CSIT101:56,CSIT111:78,CSIT115:10,ISIT312:05 1113,CSIT121:76,CSIT235:87:ISIT312:49 1114,CSIT111:50,ISIT312:Forty five 1115,ISIT115;67,CSCI235:Forty five,CSIT127:56 … Put in power HQL script hql that creates an interior desk to retailer knowledge in regards to the student numbers and the studies of the issues. An interior desk will contain to be nested (it will contain to be in 0NF). Encompass into the script INSERT statements that load sample knowledge into the desk. It is critical to insert not not as much as 5 recordsdata, which contain a construction in line with the recordsdata listed above. Encompass into the script SELECT statements that lists the contents of the desk. Think that no extra 5 issues were participated by each and each scholar. When ready, exhaust a recount line interface beeline to task a script solution3.hql and to place a file from processing in a file solution3.pdf. If the processing of the file returns the errors then you definately could merely contain to avoid wasting away with the errors! Processing of your script must return NO ERRORS! A resolution with errors is rate no marks! Deliverables A file solution3.pdf with a file from processing of HQL script solution3.hql. The file MUST NOT comprise any errors, and the file must checklist all SQL statements processed. Job 4 (5 marks) Implementation of an knowledge warehouse as a series of exterior tables in Hive Download the following recordsdata: creator.tbl, merchandise.tbl, dbcreate.sql. Notify an editor to scrutinize the contents of *.tbl recordsdata. The recordsdata accept synthetic knowledge extracted from the relational tables. A file dbcreate.sql contains CREATE TABLE statements previous to manufacture the relational tables with the synthetic knowledge. Switch the recordsdata creator.tbl, merchandise.tbl into HDFS. Put in power HQL script hql to manufacture the exterior tables, that provide a tabular look of man-made knowledge included in the recordsdata creator.tbl, merchandise.tbl. The outside tables must overlap on the recordsdata transferred to HDFS in the previous step. It is miles urged to exhaust CREATE TABLE statements included in a file dbcreate.sql to manufacture a file solution4.hql. Encompass into hql script SELECT statements, that checklist the whole alternative of rows in each and each desk, the whole alternative of rows in each and each tables, and the most most valuable 3 rows from each and each of the exterior tables implemented in the previous step. When ready, exhaust a recount line interface beeline to task a script solution4.hql and to place a file from processing in a file solution4.pdf. If the processing of the file returns the errors then you definately could merely contain to avoid wasting away with the errors! Processing of your script must return NO ERRORS! A resolution with errors is rate no marks! Deliverables A file solution4.pdf with a file from processing of HQL script solution4.hql. The file MUST NOT comprise any errors, and the file must checklist all SQL statements processed. Submission of Task 2 Point to, that you would perchance merely contain easiest one submission. So, manufacture totally sure that you submit the upright recordsdata with the upright contents. Please submit an Tutorial Consideration in SOLS if an extension (1 week maximally) is required. Please combine all recordsdata into a single zipped file (A2-solutions.zip). Please submit the zipped file through Moodle in the following skill: Internet entry to Moodle at http://moodle.uowplatform.edu.au/ To login exhaust a Login link situated in the upright upper corner the Online page online or right during the bottom of the Online page online When logged decide a draw ISIT312 (SP425) Huge Records Management (4) Scroll all the trend down to a fraction SUBMISSIONS Click on at Task 2 Click on at a button Add Submission Switch the zipped file A2-solutions.zip into an home You may streak and tumble recordsdata right here in an effort to add them. You may moreover exhaust a link Add… (9) Click on at a button Establish adjustments (10)Click on at a button Post project (11)Click on on the checkbox with a textual screech material linked: By checking this box, I verify that this submission is my accept work, … in explain to verify authorship of your submission. (12)Click on at a button Proceed Stop of specification Purchase Personalized Answer of This Overview & Elevate Your Grades Internet A Free Quote
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO ChatGPT.NO PLAGIARISM – CUSTOM PAPER
Looking for unparalleled custom paper writing services? Our team of experienced professionals at AcademicWritersBay.com is here to provide you with top-notch assistance that caters to your unique needs.
We understand the importance of producing original, high-quality papers that reflect your personal voice and meet the rigorous standards of academia. That’s why we assure you that our work is completely plagiarism-free—we craft bespoke solutions tailored exclusively for you.
Why Choose AcademicWritersBay.com?
- Our papers are 100% original, custom-written from scratch.
- We’re here to support you around the clock, any day of the year.
- You’ll find our prices competitive and reasonable.
- We handle papers across all subjects, regardless of urgency or difficulty.
- Need a paper urgently? We can deliver within 6 hours!
- Relax with our on-time delivery commitment.
- We offer money-back and privacy guarantees to ensure your satisfaction and confidentiality.
- Benefit from unlimited amendments upon request to get the paper you envisioned.
- We pledge our dedication to meeting your expectations and achieving the grade you deserve.
Our Process: Getting started with us is as simple as can be. Here’s how to do it:
- Click on the “Place Your Order” tab at the top or the “Order Now” button at the bottom. You’ll be directed to our order form.
- Provide the specifics of your paper in the “PAPER DETAILS” section.
- Select your academic level, the deadline, and the required number of pages.
- Click on “CREATE ACCOUNT & SIGN IN” to provide your registration details, then “PROCEED TO CHECKOUT.”
- Follow the simple payment instructions and soon, our writers will be hard at work on your paper.
AcademicWritersBay.com is dedicated to expediting the writing process without compromising on quality. Our roster of writers boasts individuals with advanced degrees—Masters and PhDs—in a myriad of disciplines, ensuring that no matter the complexity or field of your assignment, we have the expertise to tackle it with finesse. Our quick turnover doesn’t mean rushed work; it means efficiency and priority handling, ensuring your deadlines are met with the excellence your academics demand.
