College of Computing & Knowledge Abilities Session: 4, 2025 Lecturer: Dr Fenghui Ren Scope The needs of Assignment 2 consist of conceptual modelling of an files warehouse, implementation of 0NF tables in HQL, implementation of external tables in HQL, and querying an files cube. This assignment is due on 6 November 2025, by 9:00 pm Singaporean Time (ST). This assignment is price 20% of the total evaluation within the field. The assignment contains 4 duties, and the specification of every process starts from a brand original web grunt. Simplest electronic submission via Moodle at: https://moodle.uowplatform.edu.au/login/index.php shall be permitted. Electronic mail submissions is perhaps not permitted. A submission map is defined on the pause of Assignment 2 specification. A policy regarding behind submissions is incorporated within the field remark. Simplest one submission of Assignment 2 is allowed and most productive one submission per student is permitted. A behind submission penalty (25% of the total designate) shall be utilized for every 24 hours behind. A submission that contains an unsuitable file hooked up is treated as a appropriate submission with all penalties coming from the evaluation of the file hooked up. All files left on Moodle in a recount “Draft(not submitted)” is perhaps not evaluated. The second assignment is a person assignment and it’s anticipated that every its duties shall be solved individually without any cooperation with the change students. On the change hand, it’s allowed to expose within the submission comments that a speak element or process of this assignment has been implemented in cooperation with one other student. In such a case evaluation of a role or element would possibly perhaps perhaps perhaps be shared with one other student. In all other conditions plagiarism will result in a FAIL grade being recorded for total assignment. Whereas you happen to would possibly perhaps perhaps receive any doubts, questions, and plenty of others. please consult your lecturer or tutor for the period of laboratory/tutorial lessons or over email. Write My Assignment Hire a Legitimate Essay & Assignment Writer for finishing your Academic Assessments Native Singapore Writers Team 100% Plagiarism-Free Essay Highest Satisfaction Price Free Revision On-Time Transport Job 1 (5 marks) Intuitive make of an files cube from a conceptual schema of an operational database A bus transportation firm maintains an operational database, that contains files about the most up-to-date locations of the busses owned by the firm. A most up-to-date attach of a bus is sure by a day out phase a bus passes via, in a second. A day out contains a chain of day out segments. A bus can traverse a day out in each instructions. It would possibly probably perhaps be necessary to label, that the operational database contains most productive “point-in-time” files. On every occasion a bus strikes to the next phase all files about its past locations (on the outdated segments) is eliminated from a database. The final contents of an operational database is in step with a conceptual schema given below. The firm would favor to implement an files warehouse that would possibly perhaps perhaps perhaps be aged to implement the next purposes. derive the total change of kilometers travelled by each bus per year, month-to-month per day. derive the total change of trips performed per bus, per driver, per year, month-to-month, per day. derive the total change of drivers per day out. derive the total change of buses tear per day out phase, per day out, per year, month-to-month per day. derive a median period of bus tear per day out phase, per day out, per year, month-to-month per day. derive the total gas consumption per day out phase, per day out, per bus model, per manufacturer, per year, month-to-month, per day. derive the total change of trips per bus, per depot, per metropolis derive the total change of passengers per phase, per day out, per year, month-to-month per day. (This process can’t be implemented. Lacking files on the change of passengers.) derive doubtlessly the most attention-grabbing change of passengers per bus, per day out, (This process can’t be implemented. Lacking files on the change of passengers.) derive a median change of passengers per day out. (This process can’t be implemented. Lacking files on the change of passengers.) Spend a immediate explanation of a database enviornment and a conceptual schema given above, to derive an files cube, that wants to be implemented by the bus firm to originate an files warehouse. To your specification of an files cube, list the details, the measures, the names of dimensions and the hierarchies. Opt any three dimensions from an files cube found within the outdated step and no not up to 4 values in each dimension and one measure to plot a sample three-d files cube in a perspective look honest like a look incorporated in a presentation 09 Knowledge Warehouse Ideas, dawdle 6. Deliverables A file solution1.pdf that contains a specification of files cube as a list of details, measures, dimensions, and hierarchies obtained because of process (1), a perspective drawing of three-d files cube because of process (2). Job 2 (5 marks) Conceptual modelling of an files warehouse An honest of this process is to originate a conceptual schema of a sample files warehouse enviornment described below. Learn and analyse the next specification of an files warehouse enviornment. A colossal community of automobile repair/repairs facilities would favor to originate an files warehouse to store files about the facilities located within the diversified cities, the vehicles maintained on the facilities, and the workers working on the facilities. It’s anticipated that the next files shall be saved within the files warehouse. A automobile repair/repairs facility is described by its attach (country, metropolis, constructing number), email take care of and cell phone number. The house owners bring their automobile to the facilities for repairs and/or maintenances. An owner is described by a corpulent title and a special cell phone number. A facility retains the dates when a automobile changed into brought for repairs/maintenances and when it changed into serene by an owner. A automobile repair/repairs facility has a change of workers. An employee is both a mechanic or an admin person. An employee has a special employee number, first title, final title, and date of starting up. The repairs/maintenances are performed by the mechanics. An Implementation of every repair/repairs requires an involvement of 1 mechanic. A time spent by a mechanic on a repair/repairs and all spare ingredients aged are recorded for every repair/repairs. The knowledge warehouse must possess files about the total number days spent on repair /repairs of every automobile and the total sum of cash paid by an owner of a automobile for repair/repairs. A automobile is described by a registration number, manufacturer, model, and a year when it changed into manufactured. The house owners exhaust bank cards to pay for repairs/maintenances. A bank card number and a title of monetary institution that issued a card is recorded in a database. A files warehouse must be designed such it wants to be conceivable to without considerations implement the next lessons of purposes. A administration of the automobile repair/repairs facilities would favor to derive from an files warehouse files about the total change of repairs/maintenances per facility, per year, month-to-month per day, per metropolis and per mechanic, total prices of repairs/repairs per facility, per year, month-to-month per day, per metropolis and per mechanic, total change of mechanics involved per repair/repairs, per year, month-to-month per day, per facility, per metropolis, common time spent on repairs/maintenances per year, month, day, total change of ingredients aged for repairs/maintenances per year, month, day, per facility, per metropolis. To plot a conceptual schema, exhaust a graphical notation defined to you in a presentation 11 Conceptual Knowledge Warehouse Develop. To originate a conceptual schema of a sample files warehouse enviornment, apply the steps listed below. Step 1 Procure a truth entity, derive the measures describing a truth entity. Step 2 Procure the size. Step 3 Procure the hierarchies over the size. Step 4 Procure the descriptions (attributes) of all entity sorts. Step 5 Map a conceptual schema. To plot a conceptual schema, it be important to exhaust a graphical notation defined to you in a presentation 11 Conceptual Knowledge Warehouse Develop. To plot your design, which that you would possibly perhaps exhaust UMLet design drawing tool and observe a “Conceptual modelling” notation, Preference of a drawing notation is on hand within the right kind kind upper nook of the major menu of UMLet design drawing tool. UMLet 14.3 gadget would possibly perhaps perhaps perhaps be downloaded from the field’s Moodle Web place in a share WEB LINKS. A orderly hand drawing is quiet all appropriate kind. Deliverables A file solution2.pdf with a drawing of a conceptual schema of a sample files warehouse enviornment. Job 3 (5 marks) Implementation of a desk with a fancy column kind (0NF desk) in Hive Mediate that we receive got a series of semi-structured files that contains files about the scholars and their final reviews (in a scale from 0 to ninety 9) of the enrolled issues. The major designate in each row is a special student number. Next, we receive got a list of pairs, that consist of field code and the final evaluation in a field. 1111,CSIT111:01,CSIT121:23,CSIT101:50,CSIT235:ninety 9,ISIT312:02 1112,CSIT101:56,CSIT111:78,CSIT115:10,ISIT312:05 1113,CSIT121:76,CSIT235:87:ISIT312:49 1114,CSIT111:50,ISIT312:45 1115,ISIT115;67,CSCI235:45,CSIT127:56 … Put in force HQL script hql that creates an internal desk to store files about the student numbers and the reviews of the issues. An internal desk must be nested (it must be in 0NF). Encompass into the script INSERT statements that load sample files into the desk. It’s most realistic to insert no not up to 5 records, that receive a structure in step with the records listed above. Encompass into the script SELECT statements that lists the contents of the desk. Mediate that no more 5 issues had been participated by each student. When ready, exhaust a remark line interface beeline to process a script solution3.hql and to put a characterize from processing in a file solution3.pdf. If the processing of the file returns the errors then it be important to connect away with the errors! Processing of your script must return NO ERRORS! A resolution with errors is price no marks! Deliverables A file solution3.pdf with a characterize from processing of HQL script solution3.hql. The characterize MUST NOT consist of any errors, and the characterize must list all SQL statements processed. Job 4 (5 marks) Implementation of an files warehouse as a series of external tables in Hive Earn the next files: creator.tbl, merchandise.tbl, dbcreate.sql. Spend an editor to gape the contents of *.tbl files. The files possess synthetic files extracted from the relational tables. A file dbcreate.sql contains CREATE TABLE statements aged to originate the relational tables with the substitute files. Switch the files creator.tbl, merchandise.tbl into HDFS. Put in force HQL script hql to originate the external tables, that provide a tabular look of synthetic files incorporated within the files creator.tbl, merchandise.tbl. The external tables must overlap on the files transferred to HDFS within the outdated step. It’s urged to exhaust CREATE TABLE statements incorporated in a file dbcreate.sql to originate a file solution4.hql. Encompass into hql script SELECT statements, that list the total change of rows in each desk, the total change of rows in each tables, and the first 3 rows from each of the external tables implemented within the outdated step. When ready, exhaust a remark line interface beeline to process a script solution4.hql and to put a characterize from processing in a file solution4.pdf. If the processing of the file returns the errors then it be important to connect away with the errors! Processing of your script must return NO ERRORS! A resolution with errors is price no marks! Deliverables A file solution4.pdf with a characterize from processing of HQL script solution4.hql. The characterize MUST NOT consist of any errors, and the characterize must list all SQL statements processed. Submission of Assignment 2 Demonstrate, that which that you would possibly perhaps receive most productive one submission. So, derive fully sure that you put up the right kind files with the right kind contents. Please put up an Academic Consideration in SOLS if an extension (1 week maximally) is required. Please combine all files into a single zipped file (A2-solutions.zip). Please put up the zipped file via Moodle within the next plan: Win valid of entry to Moodle at http://moodle.uowplatform.edu.au/ To login exhaust a Login link located within the right kind kind upper nook the Web pages or within the midst of the underside of the Web pages When logged decide a place ISIT312 (SP425) Extensive Knowledge Management (4) Scroll the total manner down to a share SUBMISSIONS Click on at Assignment 2 Click on at a button Add Submission Switch the zipped file A2-solutions.zip into an attach That you can perhaps presumably plod and drop files right here to add them. That you can perhaps additionally exhaust a link Add… (9) Click on at a button Put changes (10)Click on at a button Publish assignment (11)Click on on the checkbox with a textual grunt hooked up: By checking this field, I verify that this submission is my recognize work, … in present to substantiate authorship of your submission. (12)Click on at a button Continue End of specification Buy Personalized Reply of This Review & Elevate Your Grades Win 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.
