Description
Purpose
This task provides you with opportunities to learn the knowledge (GLO1, GLO3 & ULO2) and skills (GLO1, GLO2, GLO3 & ULO3) required in the study and practice of managing data and information in organisations. By completing this task, you will develop the skills required by data modellers and data architects to develop an Enhanced Entity Relationship (EER) model that represents a conceptual data model of a specific real- world context/case.
Context/Scenario
For this task, you need to develop an EER model for the New Art Academy case study described here. You will need to draw on this case study to develop an extensive and detailed conceptual data model for this small business. You have been approached to work with New Art Academy and are tasked to apply your recent knowledge of EER modelling to support the entrepreneurial activities of the owners of this case.
What the New Art Academy business does: its core business activities:
Monthly exhibitions : each month a young and talented artists work is carefully curated for a week-long exhibition in their small but chic and modern art gallery in St Kilda Road. This exhibition usually involves much work for Megan and Macy, i.e. not only doing research months ahead to identify the list of promising artists for their monthly exhibitions, but then also curating the best works of these artists for the exhibitions. Usually, ten of the best art works of an artist is curated and exhibited for a whole week.
Inviting art lovers and art investors : Megan and Macy have experienced that monthly exhibitions need careful administration, for one, inviting interested art lovers and art investors. Megan and Macy have built quite a long manual list of these two categories of invitees to their monthly exhibitions. Art investors buy and sell art works through a variety of channels while art lovers usually buy art works to add to their own personal home collections. Channels for buying and selling art works include other galleries, art fairs, Auctions, Online Marketplaces and direct sales to art lovers which Megan and Macy have been targeting. However, they miss a good backend database to improve their outreach to various channels via digital opportunities.
Buying and Selling artworks: Megan and Macy are continuously looking for new promising art objects in different genres to buy with the aim of exhibiting or selling to art lovers and collectors. Megan and Macy curate and buy art works for their own collection which they exhibit on a daily base in their Art Gallery for viewing and potential buying by the public and other art collectors and art lovers, except for the one week showcasing of a particular artists work.
Art on Loan: Macy continued her studies in Fine Arts in Europe and worked in a local Art gallery over there. This gallery specialised in Art on Loan, i.e. allowing art lovers and art collectors to hire a special artwork for a specific period. Macy wants to introduce this concept in their business and believe this may help art lovers and collectors to invest in a piece they cannot buy immediately, while this may add to the business value of New Art Academy . Art on loan allows a customer/client to hire a special artwork for a 1-, 2- or 3- year period paying a monthly hiring fee and an additional insurance if the work gets damaged or stolen.
Client/customers may also decide to buy the artwork after a hiring period in which case they would have to pay the remaining cost of the art object.
Art Lessons: Over the past 3 years, Macy and Megan have invested in a popular art studio and have built a steady attendance for their weekly classes in drawing and painting. Their classes have been so popular that they have a long waiting list for budding artists to join the 3x monthly evening classes that run from March to October each year.
YOUR TASKS FOR THIS ASSESSMENT
Tasks 1 & 2:
Your first task is to design an EER database for the New & Old Art Academy case. This database needs to keep track of all the information for this case, i.e. the clients/customers, the art objects, all the events (e.g. exhibitions, artist exhibitions, and art studio classes). The following information might be useful as a start but note that you might add additional information as you go along.
- New Art Academy has a collection of ART_OBJECTS. Each ART_OBJECT has a unique Id_No, an Artist (if known), a Year (when the art object was created if known), a Title, Description and a Value. Value is the valued amount in dollars of the object if it gets sold or when it needs to be replacedin the event of damage (which fortunately has not yet happened). The art objects are categorised in several ways as discussed below.
- ART_OBJECTS are categorised based on their type. There are three main types: PAINTING, SCULPTUREand STATUE plus another type called OTHER to accommodate objects that do not fall into any of the three main types.
- APAINTING has a Paint_type (oil, watercolor, acryl or pencil ), and material on which it is Drawn_on (paper, canvas, wood etc.) and Style (modern, abstract, etc.).
- ASCULPTURE or a statue has a Material from which it was created (wood, stone, ). Height, Weight and Style.
- An art object in the OTHER category has a Type (print, photo, etc). and
- ART OBJECT sare categorised as either PERMANENT_COLLECTION (objects that are owned by New Art Academy – there are a few) and BORROWED (from other nearby art galleries) or ON_LOAN which are art objects that are on loan by a customer/client. The latter category also has the Loan_Period, and Date_Start_Loan which indicates the date on which the loan actually started.
Information about objects in the PERMANENT_COLLECTION includes Date_acquired, Status (on display, on loan, or stored), and Cost. Information captured on BORROWED objects includes the Collection from which it was borrowed, Date_Borrowed, Date_returned if returned, and Date_sold if the element is sold. In additional a monthly Loan_Cost is also stored in the event of a potential sale of an ON_LOAN art object.
- Information about the Style of the painting i.e. country or culture of Origin setting (Italian, Egyptian,America, and so forth) and Period represents (Renaissance, Modern, Ancient, and so forth) is also captured for each ART_OBJECT.
- New Art Academy also keeps track of the ARTIST information, if known: Name, DateBorn (if known),Birth_Origin, Contact_details, and The Name is assumed to be unique.
- EVENT-Infois also stored, e. the Event_type (solo_artist_exhibition, special_exhibition or art_class).
- Information is also kept on other COLLECTIONS with which the New Art Academy interacts to borrowor buy art This information includes Name (unique), Type (museum, art gallery, personal), Description, Address, Phone, and current Contact_Person.
Information about Clients/Customers (this is also a unique), phone_no, address_details, postal_code and client/customer Type (buying_customer, loan_customer or artclass_attendee) is also stored.
Part of the requirements for this assessment is that students use a drawing tool drawio.com or any other suitable tool e.g. lucidchart.com (https://www.lucidchart.com/pages) to present their EER diagram.
Task 2: This task requires you to revisit your final data model and ensure that it adheres to the EER syntax and modelling requirements in terms of correctness in context and syntax. Remember to state your assumptions clearly (e.g. what elements you wish to include and exclude in your Assessment 2 EER model. It may be that you gained more insights which you wish to include.
Task 3:
Produce a concise business report for the give case study. Note we do not give you a template for this but leave the creativity to you. Please use the advice in the document A guide to Writing Business Reports . (already uploaded in the Assessment 2 folder). This document outlines the major sections of your Report which you can use as given.
Mark Summary : your final assessment marks will be allocated as follows:
Submission
You must submit your final assessment report in the Assignment Dropbox in the MIS202 CloudDeakin site on or before the due date. When uploading your assignment, name your document using the following syntax:
Submitting a hard copy of this assignment is not required. You must keep a backup copy of every assignment you submit until the marked assignment has been returned to you. In the unlikely event that one of your assignments is misplaced you will need to submit your backup copy. Any work you submit may be checked by electronic or other means for the purposes of detecting collusion and/or plagiarism and for authenticating work.
When you submit an assignment through your CloudDeakin unit site, you will receive an email to your Deakin email address confirming that it has been submitted. You should check that you can see your assignment in the Submissions view of the Assignment Dropbox folder after upload and check for, and keep, the email receipt for the submission. ( Note: use the Report template to complete your assessment).
Marking and feedback
The marking rubric indicates the assessment criteria for this task. It is available in the Cloud Deakin unit site in the Assessment folder, under Assessment Resources. Criteria act as a boundary around the task and help specify what assessors are looking for in your submission. The criteria are drawn from the ULOs and align with the GLOs. You should familiarise yourself with the assessment criteria before completing and submitting this task. Students who submit their work by the due date will receive their marks and feedback on Cloud Deakin 15 working days after the submission date.
Extensions
Extensions can only be granted for exceptional and/or unavoidable circumstances outside of your control. Requests for extensions must be made by 12 noon on the submission date using the online Extension Request form under the Assessment tab on the unit CloudDeakin site. All requests for extensions should be supported by appropriate evidence (e.g., a medical certificate in the case of ill health).
Applications for extensions after 12 noon on the submission date require University level special consideration and these applications must be must be submitted via Student Connect in your Deakin Sync site.
Late submission penalties
If you submit an assessment task after the due date without an approved extension or special consideration, 5% will be deducted from the available marks for each day after the due date up to seven days*. Work submitted more than seven days after the due date will not be marked and will receive 0% for the task. TheUnit Chair may refuse to accept a late submission where it is unreasonable or impracticable to assess the task after the due date. *’Day’ means calendar day for electronic submissions and working day for paper submissions.
An example of how the calculation of the late penalty based on an assignment being due on a Thursday at 8:00pm is as follows:
- 1day late: submitted after Thursday 11:59pm and before Friday 11:59pm 5%
- 2days late: submitted after Friday 11:59pm and before Saturday 11:59pm 10%
- 3days late: submitted after Saturday 11:59pm and before Sunday 11:59pm 15%
- 4days late: submitted after Sunday 11:59pm and before Monday 11:59pm 20%
- 5days late: submitted after Monday 11:59pm and before Tuesday 11:59pm 25%
- 6days late: submitted after Tuesday 11:59pm and before Wednesday 11:59pm 30%
- 7days late: submitted after Wednesday 11:59pm and before Thursday 11:59pm 35%
The Dropbox closes the Thursday after 11:59pm AEST/AEDT time.Support
The Division of Student Life provides a range of Study Support resources and services, available throughout the academic year, including Writing Mentor and Maths Mentor online drop ins and the SmartThinking 24 hour writing feedback service at this link . If you would prefer some more in depth and tailored support, make an appointment online with a Language and Learning Adviser .
Referencing and Academic Integrity
Deakin takes academic integrity very seriously. It is important that you (and if a group task, your group) complete your own work in every assessment task. Any material used in this assignment that is not your original work must be acknowledged as such and appropriately referenced. You can find information about referencing (and avoiding breaching academic integrity) and other study support resources at the following website: http://www.deakin.edu.au/students/study-support
Your rights and responsibilities as a student
As a student you have both rights and responsibilities. Please refer to the document Your rights and responsibilities as a student in the Unit Guide & Information section in the Content area in the CloudDeakin unit site