Unit Information: SIT772 Database and Information Retrieval
Trimester: 2020 T1
Assessment 2: Information Retrieval Techniques Problem Solving Task
This document supplies the detailed information on assessment tasks for this unit.
Key information
• Due: Week 12-Sunday, 7 June 2020, 23:59 (AEST)
• Weighting: 30%
• Submit: Through CloudDeakin
Learning Outcomes
This assessment assesses the following Unit Learning Outcomes (ULO) and related Graduate
Learning Outcomes (GLO):
Unit Learning Outcome (ULO) Graduate Learning Outcome (GLO)
ULO 5: Demonstrate data retrieval skills in the
context of a data processing system.
GLO 1: Discipline-specific knowledge and
capabilities
Purpose
This task evaluates the student’s technical skills in the management of unstructured data, with
potential usage in real applications. This assessment supports student understandings of the
techniques related to unstructured data management and data processing
Instructions and Submission Guide
This is an individual assessment task. Students are required to submit ONE written report.
• Read these instructions and the following questions.
• ONE written report with the name as using student ID_givenname_A2.pdf, e.g.,
123456_Kevin_A2.pdf
• The report must be submitted via CloudDeakin assessment portal. The wrong
submission venue or the wrong submitted file may lead to the penalty.
Question 1 (Index Construction): [8 Marks]
Suppose you have joined a search engine development team to design a search algorithm based
on both the Vector model and the Boolean model.
You have collected the following documents (unstructured) and plan to apply an index
technique to convert them into an inverted index.
Doc 1:data science is field to use scientific method, process, algorithm, system to extract
knowledge.
Doc 2:data mining is the process to discover pattern in large data to involve method at the
database system.
Doc 3:information system is the study of network of hardware and software that people use
to process data.
To answer the below questions, you have to provide the detailed procedures step by step.
You need to remove all stop words and punctuation before the process of creating the inverted
index. After that, please complete the following steps:
Question 1.1: [2 Marks]
Create a merged inverted list including the within-document frequencies for each term.
Question 1.2: [2 Marks]
Use the index created as above to create a dictionary and the related posting file.
Question 1.3: [2 Marks]
Please design three Boolean queries, (for example, web AND search) and list the relevant
documents for each query. Each query must contain at least two keywords while no one
keyword appears in one document only.
Question 1.4: [2 Marks]
Please use the Vector model to query on the inverted index, and compare the result with the
Boolean model. (Hint: you can use cosine similarity and set a similarity threshold).
Question 2 (IR Evaluation): [15 Marks]
In this question, you are required to evaluate the performance of different search engines.
• First, please select two of the three search engines you are familiar,
https://www.google.com.au/, https://www.bing.com/?cc=au, https://au.yahoo.com/.
Figure 1: Select the search engine located in Australia
• Second, you are required to constrain your query to www.reuters.com by specifying:
e.g., Given a keyword query “high-tech global”, you need to write into the search box
with “high-tech global site:www.reuters.com” at your selected search engine website.
Below is the example provided for you to use google, shown in Figure 2 and Figure 3.
[Penalty is applied if your results do not follow the instruction.]
Figure 2: Search “high-tech global” within the website www.reuters.com
Figure 3: Search Results of “high-tech global” within the website www.reuters.com
• Third, please choose one target from the following list, and design two queries to search
in both search engines. So both query 1 and query 2 have to be tested in both search
engines.
 Target 1: Online tutors have more incomes in worldwide education marketing.
 Target 2: Online education expanding, awaits innovation.
 Target 3: Innovations in online learning for regional people.
• Finally, select the first 20 results in both search engines, if they return the target news,
then mark them as relevant documents, otherwise, they are irrelevant. Note: assume
there are 12 relevant documents in total (retrieved and not-retrieved). If you search
more than 12 relevant documents, you can simply regard some to be irrelevant for
practice.
The following questions are based on your search results.
Question 2.1: [3 Marks]
List your target, results and designed search queries (You can use any keywords you think are
related to the target news, even if the keywords are not contained the news text). For each
result, you can click the link and go to the page, and write down a summary with 2~3 sentences
for each result if you think this result is relevant. At your report, you are required to provide
the URL address and the summary to explain why they are relevant to the queries.
Question 2.2: [3 Marks]
Get the precision and recall values for 20 documents for query 1 in search engine 1. Interpolate
them to 11 standard recall levels. Then plot them into a chart. Get the precision and recall
values for 20 documents for query 1 in search engine 2. Interpolate them to 11 standard recall
levels. Then plot them into the same chart.
Question 2.3: [3 Marks]
Get the precision and recall values for 20 documents for query 2 in search engine 1. Interpolate
them to 11 standard recall levels. Then plot them into a chart. Get the precision and recall
values for 20 documents for query 2 in search engine 2. Interpolate them to 11 standard recall
levels. Then plot them into the same chart.
Question 2.4: [3 Marks]
Now find the average interpolated precision of query 1 and query 2 for search engine 1 and
plot it into a chart. So you will have total of 3 interpolated curves in one single chart. Now find
the average interpolated precision of query 1 and query 2 for search engine 2 and plot it into
the same chart. So, you will have total of 3 interpolated curves in one single chart.
Question 2.5: [3 Marks]
Plot the average interpolated values for Search Engine 1 and Search Engine 2 on one single
chart, and compare the algorithms in terms of precision and recall. Which search engine do you
think is superior? Why?
Question 3 (Innovation Concept Design of Decentralized Web Search Engine): [7 Marks]
In this question, you are required to make the great brainstorming for concept design. As we
learnt, all the current web search engine companies host the web data in their own web server.
The data generators cannot control their own data. In the near future, it might be highly
desirable for the worldwide researchers or companies to design a new type of web search
engine, denoted as decentralized or distributed web search engine. Lots of start-ups also make
investment in such area. The benefit is to achieve data privacy protection, data use
transparency, and removing the centralization of data management.
[https://en.wikipedia.org/wiki/Distributed_search_engine,
https://www.quora.com/Do-you-know-any-decentralized-search-engine,
https://gadget.co.za/web-gets-decentralised/].
Example: Decentralized Internet Project.
https://coins.newbium.com/post/16998-decentralized-internet-project-cardstack
In this challenging task, your design should include several important aspects:
Question 3.1: [2 Marks]
How to maintain the data using index? Must have 200~300 words to describe the design.
Question 3.2: [2 Mark]
Question 3.2. How to answer keyword queries in the new types of data environment? Must
have 200~300 words to describe the design.
Question 3.3: [1 Mark]
Question 3.3. How to evaluate such new web search engine system? Must have 200~300 words
to describe the design.
Question 3.4: [2 Marks]
Question 3.4. Provide the system structure concept design diagram. Must have a diagram and
200~300 words to explain the diagram.
Assessment feedback
General feedback to the class will be provided via CloudDeakin-Discussion Forum. The formal
assessment feedback will be released with the marks in CloudDeakin altogether.
Extension requests
Requests for extensions should be made to Unit/Campus Chairs 3 days early before the
assessment due date. Unit Chair: Jianxin Li, Jianxin.li@deakin.edu.au
Special consideration
You may be eligible for special consideration if circumstances beyond your control prevent
you from undertaking or completing an assessment task at the scheduled time.
See the following link for advice on the application process:
http://www.deakin.edu.au/students/studying/assessment-and-results/special-consideration
Assessment feedback
Detailed written feedback will be provided within two weeks of submission.
Referencing
You must correctly use Harvard referencing in this assessment. See the Deakin referencing
guide.
Academic integrity, plagiarism and collusion
Plagiarism and collusion constitute extremely serious breaches of academic integrity. They are
forms of cheating, and severe penalties are associated with them, including cancellation of
marks for a specific assignment, for a specific unit or even exclusion from the course. If you
are ever in doubt about how to properly use and cite a source of information refer to the
referencing site above.
Plagiarism occurs when a student passes off as the student’s own work, or copies without
acknowledgement as to its authorship, the work of any other person or resubmits their own
work from a previous assessment task.
Collusion occurs when a student obtains the agreement of another person for a fraudulent
purpose, with the intent of obtaining an advantage in submitting an assignment or other work.
Work submitted may be reproduced and/or communicated by the university for the purpose of
assuring academic integrity of submissions: https://www.deakin.edu.au/students/studysupport/referencing/academic-integrity

Posted in Blog

CSE 368 Introduction to Artificial Intelligence – Summer 2020
Assignment 1 – Solving sliding problem using uniformed search
Due Date: Sunday, June 9, 11:59pm
1 Assignment Overview
The goal of the assignment is to solve a sliding problem using uniformed search algorithms.
Part 1 [45 points] – Solve the problem using breadth-first search (BFS)
Part 2 [45 points] – Solve the problem using depth-first search (DFS)
Report [10 points] – Show your results interpretation
2 Deliverable
There are two parts in your submission (unless they are combined into Jupyter notebook):
• Report
Report can be done, either as a pdf or directly in Jupyter notebook. In your report:
– Describe the difference between BFS/DFS
– Show your results after applying both approaches to solve the sliding problem
– List the sequence of actions that each of the algorithms took
– Write explanation of your results
– Show the time it took each of the algorithms to solve the problem
• Code
The code of your implementations. Code in Python is the only accepted one for this project. You can
submit the code in Jupyter Notebook or Python script. You can submit multiple files, but they all
need to have a clear naming.
3 Submission
To submit your work, add your pdf, ipynb/python script to zip file Y OUR_UBIT_assignment1.zip (e.g.
avereshc_assignemtn1.zip) and upload it to UBlearns (Assignments section). After finishing the project
grading, you may be asked to demonstrate it to the instructor if your results and reasoning in your report
are not clear enough.
4 Important Information
This assignment is done individually. The standing policy of the Department is that all students involved in
an academic integrity violation (e.g. plagiarism in any way, shape, or form) will receive an F grade.
5 Important Dates
June 9, Tue, 11:59pm – Assignment 1 is Due
1

Posted in Blog

CSE2DBF 2020
Assignment 2 (20%)
Due date: 10.00am Friday, June 5th 2020
AIMS AND OBJECTIVES:
✓ to perform queries on a relational database system using SQL;
✓ to demonstrate an advanced knowledge of stored procedures, stored functions and triggers.
This is an individual Assignment. You are not permitted to work as a group when writing this
assignment.
Copying, Plagiarism: Plagiarism is the submission of somebody else’s work in a manner that gives
the impression that the work is your own. The Department of Computer Science and Information
Technology treats plagiarism very seriously. When it is detected, penalties are strictly imposed.
Students are referred to the Department of Computer Science and Information Technology’s Handbook
and policy documents with regard to plagiarism and assignment return, and also to the section of
‘Academic Integrity’ on the subject learning guide.
No extensions will be given: Penalties are applied to late assignments (5% of total assignment mark
given is deducted per day, accepted up to 5 days after the due date only). If there are circumstances that
prevent the assignment being submitted on time, an application for special consideration may be made.
See Student Handbook for details. Note that delays caused by computer downtime cannot be accepted
as a valid reason for a late submission without penalty. Students must plan their work to allow for both
scheduled and unscheduled downtime.
SUBMISSION GUIDELINES:
Task 1 should be saved to a file named task1.txt using the SPOOL command.
Task 2 should be saved to a file named task2.txt using the SPOOL command.
Task 3 should be saved to a file named task3.txt using the SPOOL command.
Note: an example of using the SPOOL command is given in the lab book. In the SPOOL file, you need
to provide the query/procedure/function/trigger execution and the sample output. For the trigger, you
need to show a sample test that demonstrates the successful execution of the trigger.
If you are not able to use SPOOL at home, please use Oracle Live SQL https://livesql.oracle.com instead
and screenshot your output into your submission file.
All the tasks above are to be submitted in soft-copy format using the CSE2DBF submission link
provided on LMS by 10.00am Friday, June 5th, 2020.
SUBMISSION CHECKLIST:
✓ The relevant SQL queries for the ‘Getaway Holidays Reservation’ Database System;
✓ The required stored procedures, stored function, and triggers.
NOTE: No built-in ORACLE column numbering (such as ROWNUM) or other ORACLE
ranking facilities (such as RANK) can be used in this assignment.
Implement the following tasks using ORACLE SQL*Plus or ORACLE Live SQL.
Download the file GHRSchema.sql from the LMS site and run it on ORACLE SQL*Plus or Oracle
Live SQL. This file contains all the CREATE and INSERT statements you will need for this assignment.
If you are using ORACLE SQL*Plus:
To run the file, issue the following command: @D:\dbf\GHRSchema.sql
→ Where D:\dbf is the location of the file (for example).
If you are using ORACLE Live SQL, you can upload the script GHRSchema.sql from the below
highlighted section “My Script” and run it.
NOTE: YOU DO NOT NEED TO INSERT MORE DATA INTO THE TABLES.
The list of tables available for this assignment is the following:
CLIENT (ClientNo, Name, Sex, DOB, Address, Phone, Email, Occupation,
MaritalStatus, Spouse, Anniversary)
CCONDITION (ClientNo, Condition)
RESERVATION (ResNo, ResDate, NoOfGuests, StartDate, EndDate,
ClientNo, Status)
ACTIVITY (ActivityID, ActName, ActDescription, ActRate, RiskLevel)
OUTDOOR_ACTIVITY (ActivityID)
INDOOR_ACTIVITY (ActivityID, Location, OpeningHours)
ACCOMMODATION (RoomNo, LevelNo, AccStatus, ConnectedRoomNo,
AccTypeID)
ACCOMMODATION_TYPE (AccTypeID, AccTypeName, AccTypeRate, NoOfBeds)
EQUIPMENT (EquipmentID, EquipName, Stock, NextInspection)
SUPPLIER (BillerCode, BusinessName, ContactPerson, Phone)
SUPPLIES (EquipmentID, BillerCode)
USES_EQUIPMENT (ActivityID, EquipmentID)
CLIENT_PREFERENCE (ClientNo, ActivityID)
RESERVATION_ACCOMMODATION (ResNo, RoomNo)
ACTIVITY_SUPERVISOR (SupervisorID)
OUTDOOR_INSTRUCTOR (InstructorID, InstrName, InstrPhone,
SupervisorID)
IFIELD (InstructorID, Field)
MASSEUSE (MasseuseID, MassName, MassPhone, Area, SupervisorID)
SWIMMING_INSTRUCTOR (SwimmerID, SwimName, SwimPhone, SupervisorID)
SUPERVISION (ResNo, ActivityID, SupervisorID, Day, Time)
NOTE: PK is printed underlined and FK is printed italic in italics.
Task 1 [50 marks]
Using the tables provided above, provide SQL statements for the following queries.
a. Display the name of the client who has made the most reservations with Getaway Holidays.
b. Display the name of the client who has booked the reservation for the longest period.
c. Display the Room no, Room type, Room rate and No of guests for the reservation made by
client(s) having last name “Perez”.
d. Display the name of the outdoor instructor who has the most duties as an activity supervisor.
e. Display the reservations (reservation number and duration) whose duration is greater than the
average duration of reservations.
[10 marks each – 50%]
Hint: in SQL, if you subtract two dates, what you get is a difference in days between those dates.
Task 2 [30 marks]
Provide the implementation of the following stored procedures and function. For submission, please
include both the PL/SQL code and an execute procedure/SQL statement to demonstrate the
functionality.
a. Write a stored procedure that displays the contact details of clients who does not have any heart
conditions or Acrophobia. The resort wants to promote a new outdoor activity to them.
b. Write a stored function that uses the reservation number, activity ID, and date as input and
returns the Name of the supervisor assigned for that specific activity.
[a: 20 marks, b: 15 marks – 35%]
Task 3 [20 marks]
Provide the implementation of the following trigger. For submission, please include both the PL/SQL
code and an insert statement to demonstrate the trigger functionality.
a. A Trigger which automatically raises an error whenever a client with Aqua phobia selects
Rafting as a preferred outdoor activity.
[15 marks – 15%]

Posted in Blog

Vellore Institute of Technology

SENSE

CSE 1002 Problem Solving and Object Oriented Programming

Assignment Marks = 10

1. Implement a Point class fro two dimensional points (x,y). Include a default constructor, a copy constructor, a negate() function to transform the point into its negative, a norm() function to return the point’s distance from the origin (0,0) and a print() function.

2. Define a Ratio class that can represent a ratio between two integers. Include necessary funstions to represent and display the ratio. Using operator overloading, overload the operator “+”, so that when, for example, the operation 2/3+4/5 is performed, the code actually performs 2/3 * 4/5. Decide all necessary data members, constructors, and other methods.

Posted in Blog

Social Considerations

Most of the companies in the world are striving to care for social responsibilities. This has turned out to be true because they cannot exist as the sole entity because they require the input of another contributing factor to deliver their services well. One of the companies of interest is Safaricom Company. It is one of the leading communication companies in the world and deals with the dissemination and the managing of the network to facilitate communication via the mobile phones. They own the biggest share of the market and, therefore, have an appropriate management that attracts most of the people. They have a concrete plan in their running of the business to deliver the services to people. The company has experienced tremendous growth attributed to the fact that they care for the population in the community hence creating an enabling environment for them to conduct business. The company has played a significant role in ensuring the life of the people is uplifted above the standard. One of the progress it has made is sponsoring the local football clubs by financing them. This has motivated young people to join the clubs and exploit their talents and hence improving their lifestyle. The young people could have been idle but through their financing, they have been able to identify their skills. The company also has been sponsoring the bright children who are from the humble background to go through their education. This is a significant milestone in the performance of the company, and therefore, people have gained trust with it. The society we live in does not need much but require a show of appreciation to create confidence in them that we live to help each other. Safaricom has been in the forefront campaigning for quality education for all. In conclusion, the-the company has for many years catered to the society around it as the people remain to be the sole and first consideration in a business environment.

References
Reader, W. J., & Unilever. (1969). Business & society. London: Information Division, Unilever.
SelectCarroll, A. B., & Buchholtz, A. K. (2003). Business & Society: Ethics and Stakeholder Management. Mason, Ohio: Thomson/South-Western.

Posted in Blog

CHARACTERISTICS OF SLAY QUEENS
The phenomenon of the “slay queen” has been much discussed in social media circles. A slay queen is basically a diva, mostly from urban locations, that has reason to believe she is every man’s eye candy and the envy of every other woman. She believes that women of her kind are superior and should thus be treated as such. However, slay queens are more annoying than interesting. Here are the common characteristics they possess.
1. Blue ticks
Slay queens can ignore your texts until you cry. It’s like your text is a Safaricom message or that “nitumie hizo pesa kwa hii number” message from a Kamiti inmate. You just keep seeing the slay queen of your dreams online most of the time, but she doesn’t respond, because she has “options.” – Lots of options. Fail to respond to her texts however and it becomes the Battle Oi Waterloo. Slay queens have extreme double standards, not just in texting but in general life too. A slay queen can’t stand waiting for a guy for 10 minutes for example. On the other hand, she doesn’t see a big deal in being two hours late for a date.
2. Taking pictures with their legs curved
Look at the pictures of most slay queens and you might think they are suffering from Rickets – the condition that causes bowed legs in some children. Slay queens are obsessed with pictures and when she makes you her photographer, you’ll have to keep repeating the shots until your fingers hurt and she is sure she has the perfect pic. Note that If you like to keep your life private, don’t date a slay queen. Nothing makes her happier than couple photos, most of which are just meant to make her ex mad. You will be exploited for photos with numerous hashtags such as #goofingwithbae, #mymanbetterthanyours #drivingwithbae etc.
3. Life of the party
A slay queen believes that being an obnoxious. Shisha-loving party girl is all part of the good life. Despite the fact that she’s puked in all the washrooms of all Kenyan clubs, a slay queen will pretend to be too cool for local music. Ask her if she’s heard Timmy Tdat’s latest song and she’ll be like “Ati Timmy Tdat? Who’s that? I don’t do local music. I love The Weekend.”
4. Accent
Slay queen’s tweng harder than Dr.Kaluyu. All their speeches are littered with phrases such as “Wharreva”, “So cute”, “Do I look fat?”” I’m done with..” and “Oh my gosh” depending on the mood. Despite the slay queen’s penchant for accents, she has very poor grammar. A slay queen doesn’t know the difference between your and you’re, I’m and Am, as well as many other English connotations. She never will. And she will be offended if you point that out.
5. Outrageous preferences for men
Slay queens have crazy standards when it comes to the kind of men they want, even when they don’t deserve such men at all. They believe that only the best of the best will suffice for their romantic life. A slay queen will dish out statements like “Aki mi I can’t date a guy who doesn’t drive” or “I can only do sleepovers in Kile and Lavi, kama ni Eastlands I kent.” Her worth is too large for just any bloke on the street, no matter how charming or educated. Money is number one for a slay queen, with looks a close second. A slay queen doesn’t care if her boyfriend is smart or a decent human being , so long as he looks cool and has some cash. And as long as he’s buying her Guarana at B-Club. And as long as she can talk to her girls about her boyfriend who buys her Guarana at B-Club, she’s happy
Other Notable Characteristics.
6. Likes oversharing on social media: A slay queen likes to over share with everyone on social media. Examples include, “ugh, feeling gross today,” “depressed,” “That amazing feeling when you get home and take off your bra,” and “My puppy died…..so sad ? RIP Toto….you were so adorable.”
7. Dumbness: A slay queen will know what is the name of Jocelyn’s baby in Love and Hip Hop Atlanta or what was the color of Pendo’s dress on Nairobi Diaries three months ago but she has no idea where Syria is, or what’s going on in the country at any given time.

Posted in Blog

Marketing Assistant in the Fashion Industry
Introduction
Marketing assistant in the fashion industry is a profession that has attracted several career professionals. The highest numbers of those attracted to this career are the fresh graduates with passion in women fashion. Moreover, the fresh graduates are characterized by the need and desire to conduct research on new fashion and latest products in the market. The main reason is to analyze and summarize the data available to get a clue of the choices of a particular company. This paper seeks to examine the career of a Marketing Assistant in the fashion industry with specialization in the fashion magazine. In doing this, the paper will look at the routine activities of a marketing assistant, the reasons attracting people to this career and the academic qualifications of this job. Moreover, the paper will critically evaluate the need for continued education for those already in the fashion industry as a marketing assistant. In addition, the paper will critically evaluate the licenses required and the responsible professional bodies or government agencies for that matter. Finally, the paper will look at the legality involved in the profession of a marketing assistant, criminal records, credentials, and fingerprints before giving a conclusive stand on the career.
The Day-By-Day Activities of the Job
Marketing assistant in the fashion industry is a very cumbersome career that needs a lot of deduction and commitment. A snapshot of people already in this career especially those working in the magazine sectors reveals that the primary activities involved in this job is persuasive convincing of customers to take up whatever the company has to offer for them. “Marketing assistant in the fashion industry entails conducting a feasibility study and market research for company’s products and services before they are launched into the market” (Basye, 22). This means that the marketing assistants who are already in fashion industry must analyze the market conditions and advise the company on the reaction of customers to the new product launched. Similarly, the market assistant job entails continuous selling and promotion of the fashion magazine to increase sales and revenue. A marketing assistant also keeps the record of daily sales and reactions of the customers towards the products and services. Besides, a marketing assistant keeps record of the customers of the company with details of their location, contacts, and loyalty to the company in the fashion magazine. None the less, a marketing assistant is involved in the activities of keeping sales and marketing journals that are used to plan and undertake daily sales activities of a company (Gurton 29). In conducting their duties, marketing assistants in the fashion magazine will need to travel to discover the new fashions in the market. Besides, they will be involved in less writing with more of their time being involved in conducting market research.
What the Career Offers Society
The impact of a career in marketing assistant in the fashion industry to the society is enormous and cannot be overlooked. In addition, the job creates a positive effect on the other members of the community who are involved with the market assistants in one way or the other. “A market Assistant plays a key role in providing crucial information to the customers and members of the public on usability and importance of the fashion magazine” (Field, 34). This is possible through the distribution of fashion magazine. In addition, the marketing assistant helps the community and the society get to understand the nature of products and services offered in the fashion magazine. Similarly, the marketing assistant makes the fashion magazine available to the community and the society. This will go well with the society in ensuring accessibility information in the fashion magazine that are critical and essential to the daily life of citizens (Forsyth, 43). Of significant impact is the provision of an opportunity for the society to interact with products and services on the market by asking questions relevant to the fashion magazine. Therefore, the career of a marketing assistant offers a lot of services to the community and; positively affects the other members of the society.
Why People may be Interested in this Career
A marketing assistant is a professional who is always smart and appealing to members of the public. While on duty, a marketing assistant dresses smartly to improve the public image and personality. This has led to so many fresh graduates dreaming of joining the profession. “The incomes offered for the position of marketing assistant in the fashion industry are huge and attractive, and this creates a lot of interest and desire among new graduates” (Steinberg, 9). In addition, many new graduates are attracted to this career because of the flexibility and convenience of the mode of work and conditions of work. It is a job that can easily fit into the schedule of any individual allowing from for resting and doing private businesses. In addition, the job provides fresh graduates with an opportunity to network and meet news friend thus increasing their knowledge of the perception of the society through the information available in the fashion magazine. The fashion magazine is also attractive and lures so many young graduates to the career (Stair, 28).

Required Education and Degrees
A marketing assistant must be well conversant with the prevailing market dimensions and should have the ability to analyze the situations prevailing in the market. “A market assistant must be capable of handling customer needs and wants in a professional and dedicated manner” (Nagle, 32). Moreover, a marketing assistant must be in possession of problem-solving and analytical skill necessary for tackling the challenges that he or she may face in the market. All these requirements of a market assistant call for a thorough academic qualification to eliminate any case of failure to deliver the expectations of a market assistant.
Therefore, the required educational qualification of a market assistant is degree in fashion marketing with specialization in magazine. Among the field of specialization that a market assistant should be well conversant with are sale, marketing, customer relation, advertising, promotion, fashion design, and professional marketing of the fashion magazine. Similarly, other critical skills like analytical and problem-solving skills are necessary for the market assistant. Moreover, planning and decision-making skills will help a Market Assistant improve the performance in the fashion industry. Of great importance is to pose educational background on communication and convincing skills.
Continuing Education Requirement
For the purposes of ensuring productivity and good performance in the marketing career, continued education is critical for the marketing assistant. Moreover, the market for any product is dynamic and keeps on changing as fashions and trends keep on changing. None the less, the fashion industry is always changing with nothing remaining static. This is facilitated by changes in preferences of the customer as technology keep on changing. Consequently, it will be essential for a good market assistant to cope with the changing technology to remain productive and relevant to the career (Steinberg, 54). This move is only possible through engaging in continued education programs routinely. For instance, the marketing assistant in the fashion industry must attend seminars, fashion shows, and conferences to acquire the latest dynamics in the market. Moreover, short courses that equip the marketing assistant with the immediate problem-solving skills and technological advancement are necessary. Continuous review of the fashion magazine is also important.
Marketing Assistant Salary
Normally, the average salary of a marketing assistant is approximately $35000 per year. However, this salary increases slightly depending on the experience but additional experience does not contribute to major change on the pay. As a result, most marketing assistants go to other positions after about 10 years in this position. According to the report by U.S. Bureau of Labor Statistics 2012, a marketing assistant salary range from $28,000 to $37,000 per year.
Required Licenses, and by Chartered Institute of Marketers
Just like any other profession, fashion marketing has a professional body that regulates the conduct and practices of its members (Kerin, 12). This professional organization is the umbrella body that is charged with the responsibility of ensuring that the members are well behaved and do not get involved in unethical behavior while on duty. The professional body for marketing assistants is the Chartered Institute of Marketers. It provides licenses and regulation framework for all members enlisted in its register. In addition, the Chartered Institute of Marketers works in collaboration with the government to issue licenses and regulate the overall practice of market assistants (Gurton 29).
Besides, this professional organization conducts regular training and advisory services to its members narrowing down to fashion industry and fashion magazine segment. This professional body also arbitrates any conflict between members and the customers.
Legal Requirements; Credentials, Fingerprinting and Criminal Background Check
There are legal frameworks that govern the practice and training of market assistants. The market assistant in the fashion industry will be obliged to comply with the regulatory frameworks that are instituted by the government in conjunction with the Chartered Institute of Markers. These legal requirements include possession of academic credentials of a minimum level of degree or diploma before gaining entry into the profession. This will ensure that the number of quacks marketing assistant is reduced. Moreover, this move helps ensure only qualified market Assistants get access to offers services to the organizations and customers. It will also help to improve the quality of services that the customers get (Clouse & Kathie, 17). In addition, the fingerprints of those seeking admission into the profession as marketing assistants must be taken to ascertain their criminal records. A person with a severe criminal background is not fit for admission as a marketing assistant since the fate of the customers may be put at risk.
Conclusion
Marketing assistant is a profession that lures the fresh graduates because of its attractive remunerations and social status in the society. It is a profession that is under strict regulations by government agencies and the Chartered Institute of Marketers. This is to ensure that the market assistants follow all the legal requirements and poses the relevant academic credentials. Similarly, in order to improve the performance of market assistants, continued education is essential. They do this by monitoring the daily trends and preferences of women in the fashion industry.
Marketing assistant position is essential because marketing assistants create a positive influence on the society with the right services and guidance they provide to the customers. Indeed, being a marketing assistant is a privilege because they are seen as a bridge between organizations and the customer. Therefore, as a marketing assistant, it is such a honor because it does not only lead to personal and professional satisfaction, but market assistants also play a fundamental role in serving other people in the society to meet their needs and preferences particularly customers.

Works Cited
Basye, Anne. Opportunities in Direct Marketing Careers. New York: McGraw-Hill, 2008.
Internet resource.
Clouse, Michael S, and Kathie J. Anderson. Future Choice: Why Network Marketing May Be
Your Best Career Move. Charlottesville, VA: Upline Press, 1996. Print.
Field, S. Advertising and Public Relations. New York: Infobase Pub, 2005. Internet
Resource.
Forsyth, Patrick. Getting a Top Job in Marketing. London: Kogan Page, 2001. Print.
Gurton, Annie. How to Get into Marketing and Pr. London: Continuum, 2003. Print.
Kerin, Roger A. Marketing. Boston, Mass: McGraw-Hill/Irwin, 2003. Print.
Nagle, Jeanne. Careers in Internet Advertising and Marketing. , 2014. Print.
Stair, Lila B, and Leslie Stair. Careers in Marketing. Chicago: VGM Career Books, 2001.
Internet resource.
Steinberg, Margery S. Opportunities in Marketing Careers. New York: McGraw-Hill, 2006.
Print.
WetFeet (Firm). Careers in Marketing. San Francisco, CA: WetFeet, Inc, 2008. Print

Posted in Blog

ISY5007 Assignment – Report on Data Management Plan (S1/2020)
30% of the final assessment
Individual Assessment
1500 words maximum, excluding appendix
Write a data management plan for ONE of the data science project scenarios given below OR seek approval in writing from the Unit Coordinator for an alternate scenario of your choice.
Your data management plan should identify data sources and articulate a reasonable approach to data acquisition, cleaning, integration, archival and analysis.
Consideration should be given to hardware/software and processing requirements.
Consider using measured, estimated, or simulated data to demonstrate the kind of data that you anticipate this project will use.
From a high-level perspective describe in English how you anticipate this data will be analysed. You may consider using pseudo code to illustrate this or use Python or a similar programming language if you have the necessary skills. Note that actually analysing data is not a requirement for this assessment.
The goal of this assessment is to demonstrate
• expectations related to data volume, velocity, and variety, veracity, and value
• planning for metadata content and format
• a reasonable approach to project governance
• recommendations for data storage, publication, archival, and retirement
• strategies to guarantee data quality, security, and privacy
Scenario Choices
Scenario 1: Your organisation aims to use data to assist the WA health department in reducing infections from the COVID-19 virus.
Scenario 2: Your organisation aims to use data for targeted advertising that promotes Western Australia as a travel destination.
Scenario 3: Your organisation aims to use data to predict which students are at risk of being terminated or dropping out of their university course.
Scenario 4: Your organisation aims to use data to predict the winner of the American presidential election.
Scenario 5: Your organisation aims to use data to predict the winner of next year’s Brownlow Medal.
Scenario 6: Your organisation aims to use data to predict the likelihood that a start-up company seeking venture capital will become a profitable business.

Posted in Blog

ASSIGNMENT 2 / Weight 10%
CSC2330 Software Project Management / March Semester 2020
1
1
LEARNING OUTCOMES
This assignment is designed to assess students’ ability on:
• Applying project management tools and techniques in various phases of the project life
cycle.
• Developing lifelong learning skills, through search of relevant materials and
discussion.
TASK 1
Assume that the source selection criteria for evaluating proposals are as follows:
• Management approach, 15%
• Technical approach, 15%
• Past performance, 20%
• Price, 20%
• Interview results and samples, 30%
Using Figure 12-5 (in the slides) and the weighted scoring model template as guides create a
spreadsheet that could be used to enter ratings and calculate scores for each criterion and
total weighted scores for three proposals.
Enter scores for Proposal 1 as 80, 90, 70, 90, and 80, respectively.
Enter scores for Proposal 2 as 90, 50, 95, 80, and 95, respectively.
Enter scores for Proposal 3 as 60, 90, 90, 80, and 65, respectively.
Source: Kathy Schwalbe. Managing Information Technology Projects (201), Revised 7th
Edition
(CLO2: PLO2)
ASSIGNMENT 2 / Weight 10%
CSC2330 Software Project Management / March Semester 2020
2
2
TASK 2
Download a free trial of MindView mind mapping software from
www.matchware.com/itpm and create a mind map of a SWOT analysis for your
organization. Or you may use any appropriate software.
Include at least TWO strengths, weaknesses, opportunities, and threats, and then provide
ideas for ONE potential project. Or, you can use your college or university for the SWOT
analysis, focusing on what it can do to improve services for students.
(CLO2: PLO2)
TASK 3
Use spreadsheet software to create Figure 1. Make sure your formulas work correctly.
Figure 1: Net Present Value (NPV)
(CLO2: PLO2)
ASSIGNMENT 2 / Weight 10%
CSC2330 Software Project Management / March Semester 2020
3
3
Your submission should not exceed 5 pages. Use Times New Roman, Font 12 and 1.5
spacing.
MARKING SCHEME
Tasks Criteria CLO2:PLO2
1 (40%) Spreadsheet must be correct, reflects the given data. 40
2 (30%) The mind map successfully illustrates the SWOT analysis
done
30
3 (30%) Spreadsheet used the correct formula to calculate NPV 30
PERFORMANCE CRITERIA
TASK 1
1 2 3 4
PLO2 Able to use
software tools
and weighted
scoring model
in order to
evaluate
project under
constant
supervision.
Able to use software
tools and weighted
scoring model in
order to evaluate
project under guided
supervision.
Able to use
software tools
and weighted
scoring model in
order to evaluate
project without
supervision.
Able to use
software tools and
weighted scoring
model in order to
evaluate project.
Able to analyse and
interpret data
TASK 2
1 2 3 4
PLO2 Able to use
appropriate
software tools
to perform
SWOT analysis
Able to use
appropriate
software tools to
perform SWOT
analysis in proposing
Able to use
appropriate
software tools to
perform SWOT
analysis in
Able to use
appropriate
software tools to
perform SWOT
analysis in
ASSIGNMENT 2 / Weight 10%
CSC2330 Software Project Management / March Semester 2020
4
4
in proposing
potential
project for
organization
under constant
supervision.
potential project for
organization under
guided supervision.
proposing
potential project
for organization
without
supervision
proposing
potential project
for organization.
Able to provide
good justification
TASK 3
1 2 3 4
PLO2 Able to use
appropriate
software tools
to perform NPV
analysis in
evaluating or
determining
potential
project for
organization
under constant
supervision.
Able to use
appropriate
software tools to
perform NPV
analysis in
evaluating or
determining
potential project for
organization under
guided supervision.
Able to use
appropriate
software tools to
perform NPV
analysis in
evaluating or
determining
potential project
for organization
without
supervision.
Able to use
appropriate
software tools to
perform NPV
analysis in
evaluating or
determining
potential project
for organization
Able to analyse and
interpret data

Posted in Blog

Student Name
Student ID
Student Signature
Assessor
Submission FER1 FER2
Result
Date
Assessor’s
Signature

Technical Support Level 5
Case Study Research
DAT536: Database Development and Design
Version 2, Level 5, Credits 20
Assessor’s Feedback
Submission
FER1
FER2
Instructions and Guidelines for Project Submission
Task completion
 Project will be judged on the basis of completeness, correctness and clarity.
 Complete ALL tasks.
 Warning: All media must be virus free! Media containing viruses or media that
cannot be run directly will result in a FAIL grade.
Format
 The report must have a title page with your name, class and ID number clearly printed.
 All written work must be done in size 12 font with 1.5 line spacing.
 All printouts must include your student ID (or group IDs) in the footer (printed).
 You may need to attach the task cover sheet found on Moodle to the front of the final
submission of your task (please confirm with your tutor).
Submission
 The completed assignment must be handed to the tutor at the beginning of the class
on the due date.
 Submit a printed copy of your report along with the soft copy. Tutor will inform you
on how to submit the soft copy.
Competency-based assessment FER and Re-enrolment
1. Students will have an opportunity to provide further evidence twice.
2. To be eligible for a FER the student must make a reasonable attempt at the questions/tasks in the
assessment.
3. Reasonable is to be defined as a response that at the very least attempts to address the
question/task.
4. Where the student does not make a reasonable attempt at ALL questions/tasks they will not
achieve and will be required to re-enrol in the paper.
5. A fee of $250 is payable for the second FER.
6. The need for further evidence from the students will be noted on the assessment as “FER” and
dated.
7. When the further evidence is deemed adequate the “FER” notation will be crossed out, initialed
and dated.
8. If a student is still deemed not yet competent after the second FER they will be required to re-enrol
in the paper. A fee will apply for re-enrolment and details will be available in the Programme
Handbook, and students will be informed of them at the start of the programme.
9. Additional FER’s are at the discretion of the Head of Faculty.
Reconsideration of Assessments and Appeals
1. Students have the right to a reconsideration of assessment or appeal if they believe an
assessment has been incorrectly marked or graded.
2. The request for reconsideration must be made in writing to the Head of Faculty within five (5)
working days of the return of the assessment. A fee of $40 per assessment applies.
3. Students must be informed that, as a result of the reconsideration of assessment, their result
may be unchanged, raised or lowered.
4. The reconsidered result will be recorded as the final result. Students retain the right to appeal
this result.
Plagiarism
 By submitting your assignment, you agree to Aspire International policy on ‘Academic Dishonesty
and Plagiarism’. Assignments completed using unfair means or plagiarised material will receive a
FAIL grade.
 All tasks must be done in your own words and referenced.
Feedback
 You may request feedback from your lecturer to verify the accuracy of your marks.
Learning Outcomes covered:
1. Apply a broad operational knowledge of database administration to
meet typical organizational data storage and retrieval requirements.
Case Study Scenario:
The UniPharma chain of pharmacies has offered to give you a free lifetime supply of medicine if you
design its database. UniPharma is a small medium enterprise (SME) in terms of company structure
and has four (4) pharmacies in the Auckland region. Being an SME, they would like to keep their
costs down but also to have an efficient solution to manage their back-office administration. Here
is some more information to help you out with the case study:
• Patients are identified by a Social Security Number (SSN), and their names, addresses, and
ages must be recorded.
• Doctors are identified by an SSN. For each doctor, the name, specialty, and years of
experience must be recorded.
• Each pharmaceutical company is identified by name and has a phone number.
• For each drug, the trade name and formula must be recorded. Each drug is sold by a given
pharmaceutical company, and the trade name identifies a drug uniquely from among the
products of that company. If a pharmaceutical company is deleted, you need not keep track
of its products any longer.
• Each pharmacy has a name, address, and phone number.
• Every patient has a primary physician. Every doctor has at least one patient.
• Each pharmacy sells several drugs and has a price for each. A drug could be sold at several
pharmacies, and the price could vary from one pharmacy to another.
• Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several
patients, and a patient could obtain prescriptions from several doctors. Each prescription
has a date and a quantity associated with it. You can assume that, if a doctor prescribes the
same drug for the same patient more than once, only the last such prescription needs to be
stored.
• Pharmaceutical companies have long-term contracts with pharmacies. A pharmaceutical
company can contract with several pharmacies, and a pharmacy can contract with several
pharmaceutical companies. For each contract, you have to store a start date, an end date,
and the text of the contract.
• Pharmacies appoint a supervisor for each contract. There must always be a supervisor for
each contract, but the contract supervisor can change over the lifetime of the contract.
1. As the Database Administrator (DBA) write down the relational schema for at least
5 tables of the database in terms of the company’s structure.
2. Draw an ER diagram that captures the preceding information. Identify any
constraints not captured by the ER diagram.
3. How would your design change if each drug must be sold at a fixed price by all
pharmacies?
4. As a part of the UniPharma change management plan how would you
administer changes if the design requirements are as follows:
If a doctor prescribes the same drug for the same patient more than once,
several such prescriptions may have to be stored.
5. UniPharma is concerned about weekly data backup. Formulate and briefly
describe a data backup plan.
Each of the 4 UniPharma pharmacies have a Pharmacy Manager, a data entry operator,
an accountant, 2 pharmacists and database administrator. Keeping this company
hierarchy in mind please answer the following questions6. Describe access privileges level of the five (5) employee types of UniPharma in the
database? and who is the person deciding the access privilege levels?
7. Being the DBA, you have to provide different access levels to the employees;
mention any three (3) access related.
8. Recently 100 tables were updated in the database after new products came in. As
a Database Administrator, what tasks will you perform to ensure consistency of the
database?
9. DBMS is a highly complex system with hundreds of transactions being executed
every second. UniPharma is concerned if it fails or crashes in the middle of
transactions, it is expected that the system would follow some sort of technique to
recover lost data. Discuss categories of failures and methods to formulate a
recovery plan.
Evidence and Judgement Statements
Task
No.
Evidence Judgement Criteria Submission FER1 FER2
1 The candidate shows the
relational schema of the
company’s database in relation
to the case study.
The candidate shows relational
schema of the five tables of the given
company. The candidate clearly
mentions the logical entities in the
table.
The candidate’s answers may vary
but must cover defining concepts as
per assessment schedule.
2 The candidate shows the ER
diagram.
The candidate has clearly presented
the ER diagram. The relevant entities
and the attributes have been logically
created. The relationships between
entities, cardinalities and constraints
have been clearly identified.
Task
No.
Evidence Judgement Criteria Submission FER1 FER2
The candidate’s answers may vary
but must cover defining concepts as
per assessment schedule.
3 The candidate analyses the
design change in the database
system in relation to the case
study.
The candidate has added and deleted
the correct attributes. The
candidate’s answers may vary but
must cover defining concepts as per
assessment schedule.
4 The candidate manages the
change management plan
according to the company’s
requirement in relation to the
case study.
The candidate has created the right
entity sets and has also identified the
relationships.
The candidate’s answers may vary
but must cover defining concepts as
per assessment schedule.
5 The candidate formulates the
weekly data backup plan with
brief description.
The candidate clearly mentions and
explains the backup techniques.
The candidate’s answers may vary
but must cover defining concepts as
per assessment schedule.
Task
No.
Evidence Judgement Criteria Submission FER1 FER2
6 The candidate lists down and
explains the access privilege
level of the employees.
The candidate clearly describes the
access privilege levels for at least five
employees types and identifies the
right decision maker.
The candidate’s answers may vary
but must cover defining concepts as
per assessment schedule.
7 The candidate lists down the
access related commands to
each employee
The candidate lists and explains at
least three access related commands.
8 The candidate maintains the
consistency of the database
after updating the database as
per the case study scenario.
The candidate clearly mentions and
explains all MySQL statements.
9 The candidate lists several
database failure techniques
and mentions the recovery
plan.
The candidate clearly explains the
database failure techniques and
recovery plan.
The candidate’s answers may vary
but must cover defining concepts as
per assessment schedule.

Posted in Blog