system requirements and design of London Visual Arts System ISAD

complete a document on the system requirements and design of London Visual Arts System

ISAD Coursework in the First Semester

This coursework will require you to complete a document on the system requirements and design of London Visual Arts System(see the scenario  below), which must follow

the guidelines below:

Well structured document style
o Front page with proper title, name, date,
o Content page with chapters and their starting page numbers,
o Page numbering,
o Introduction which describes objectives of the document,
o You should not include any non-relevant statements, pictures and
should not use any fancy fonts.

Contents of the document
o Introduction which briefly describes objectives of the document,
o Plain and abstract descriptions Event Table (see lecture 6) of business activities
for  the system                                    [ 5 marks]
o Schedule (Gantt Chart)                      [ 5 mark]
o Context diagram                                 [10 marks]
o Level0 data flow diagram                   [ 50 marks]
o Entity Relation diagrams                    [ 30 marks]

Well-Analysed Requirements
o You may use Event Table (see lecture 6) form to state business activities for the
system you captured.
o All entities and their attribute-values should be stated,
o All flow of information should be clearly stated,
o You should not mention any implementation details.

System Design
1.    Entity Relationship diagrams to represent the data storage requirements for London Visual Arts (LVA) gallery System, including the attributes mentioned.
2.    Draw Data Flow Diagrams (context, and  level0) based on business activities
for the system above, by using tools are available such as  Microsoft Visio .

Scenario of the Case Study :

The managing director, John Lee of London Visual Arts (LVA) has a small art gallery based in Notting Hill in West End of London.   It has no fixed collection of

paintings of its own, but simply puts on exhibitions of paintings belonging to museums or living artists. In the past, it has relied on a paper filing system to

organise exhibitions, but John Lee wishes   to expand the business, with a short-term strategy to gain a web presence, with the availability of exhibition information,

paintings, artists and captured images of artist. John has hired you as a systems analyst, to analyse and capture the current workings and to recommend a project

design methodology approach.  The following is a description of how the current system works.

Artists who would like to exhibit contact LVA with details of their paintings, the styles and where possible photographs. The curators at LVA also contact various

museums and other galleries to find out about paintings held elsewhere. Details of all paintings and their artists are held in the paintings file.

To organise a new exhibition, the curators meet and go through the paintings file and collect together paintings that would make a good exhibition. They also make sure

that the new exhibition does not overlap too much with other past or planned exhibitions. With living artists, the curators often have to confirm with the artist that

the painting is still available and has not been sold. The details of the new exhibition are held in a special folder for that exhibition.

Having devised an exhibition, the curators go through the list of rooms at the gallery to find an available room of suitable size and a possible set of dates for the

exhibition. Once the dates are fixed, the room is reserved and details of the exhibition and its dates are sent to the promotional artist who prepares fliers and

posters for the exhibition. These are sent out to LVA’s various advertising outlets for distribution.

The final details of the exhibition are also sent to the appropriate artists and museums, who should reply to confirm and to give details of the transport required to

get the paintings to LVA. These requirements are kept in the exhibitions folder and also passed on to a transport company. The transport company ensures that the

paintings arrive safely in time for the exhibition.

Plagiarism is presenting somebody else’s work as your own. It includes: copying information directly from the Web or books without referencing the material; submitting

joint coursework as an individual effort; copying another student’s coursework; stealing or buying coursework from someone else and submitting it as your own work.

Suspected plagiarism will be investigated and if found to have occurred will be dealt with according to the procedures set down by the University.

All material copied or amended from any source (e.g. internet, books) must be placed in quotation marks and in italics, with a full reference to the source directly

underneath the material.

Your work will be submitted for electronic plagiarism checking. Any attempt to bypass our plagiarism detection systems will be treated as a severe Assessment Offence.


TASK     Knowledge of the underlying concepts and principles associated with their subject area    Evaluate and interpret the underlying concepts and principles

within the context of their area of study    Develop lines of argument and make sound judgements in accordance with basic theories and concepts of their area of

study.    Ability to evaluate the appropriateness of different approaches to solving problems related to their area(s) of study and/or work    Communicate the results

of their study/work accurately and reliably, and with structured and coherent arguments
CONTEXT DIAGRAM    10%    0-1    2-3    4-5    6-8    9-10
Significant notational and interpretation errors     Notational errors, poor interpretation     Notation correct, reasonable interpretation

Notation correct, reasonable interpretation, good supporting narrative     Excellent in all respects, use of CASE tool. Supporting narrative accurate and perceptive

GANTT CHART & WRITE EVENT TABLE            10%    0-1    2-3    4-5    6-8    9-10
Little or no attempt at identifying the business events.      Essentially correct at identifying the business events, but probably weak

interpretation.       A basic identifying and interpretation the business events to which to which the system must respond    reasonable  identifying and

interpretation the business events to which to which the system must respond    Excellent in identifying the business events to which to which the system must respond

LEVEL 0 DATA FLOW DIAGRAM      50%    0-19    20-27    28-35    36-43    44-50
Little or no attempt at logicalisation.      Poor logicalisation,      A basic understanding of the distinction between physical and logical modelling

Reasonable understanding of logicalisation.      Sound grasp of the significance of logical modelling, Good supporting narrative

ENTITY RELATIONSHIP DIAGRAM      20%    0-7    8-11    12-15    15-18    18-20

Weak ERD with substantial errors in selection of entities.      Essentially correct ERD notation but probably weak interpretation.      ERD that is basically

correct and interprets scenario reasonably. Could have errors in m:n decomposition.      All aspects fundamentally correct including m:n resolution, relationship

naming, primary and foreign keys.     All aspects correct or only very minor errors/omissions. Supporting narrative accurate and perceptive.

ENTITY/ ATTRIBUTE DEFINI-TIONS    10%    0-1    2-3    4-5    6-8    9-10
Highly inaccurate attribute definitions     Attribute definitions may have errors in keys etc.     Attribute definitions satisfactory. May have

errors in foreign keys     All aspects fundamentally correct including primary and foreign keys.     All aspects correct or only very minor errors/omissions. Supporting

narrative accurate and perceptive.

1sr Marker (print name)

Signature    Date
External Marker (print name)

Signature    Date


find the cost of your paper