We're Open
+44 7340 9595 39
+44 20 3239 6980

1. Identify what is required and produce a selection of relevant models using a mixture of SSM and UML

  100% Pass and No Plagiarism Guaranteed

1. Identify what is required and produce a selection of relevant models using a mixture of SSM and UML

CIS020-2: Data Modelling and Management
Referral Individual Assignment 1 Brief
CIS020-2: Individual Coursework Assignment – 1 Brief

CASE STUDY

You are individually required to develop and implement a database system for an application area in which you have experienced and/or are familiar with/have an interest in. For example, it could be a booking type application or an order processing type system. Other examples include a system to book tickets for a theatre, a flight or a system to allow customers to hire or buy books, tools, a system to hire/buy cars and so forth. The scenario and the designed database system [up to 30 marks] will be judged by the tutors using the following criteria.

Example of minimum functionality:

• Browse product by category [up to 10 marks]

• Search product by a free-text keyword [up to 10 marks]

• Advanced product search [up to 10 marks]

• Product stock availability Check [up to 10 marks]

• Order one or more product(s) [up to 10 marks]

• Customer registration including validation checks [up to 10 marks]

• Product stock reduction on order [up to 10 marks]

• Order confirmation issuing a system generated unique number [up to 10 marks]

• Ability to cancel and/or amend order details [up to 10 marks]

• Add and update product stocks as an administrator [up to 10 marks]

Minimum required to pass is 40 marks

METHOD OF IMPLEMENTATION:

You may use back/front end environments of your choice to develop your system, as long as it is relevant/desirable to industry. Oracle APEX is advised as there are tutorial materials available on breo

Follow these STEPS carefully!

You are required to:

1. Identify what is required and produce a selection of relevant models using a mixture of SSM and UML

2. Produce an Entity Relationship Model (ERM)

3. Use the normalisation process to refine your ERM

4. Develop and implement the back-end of your DB system using suitable industry relevant platform

5. Implement the front-end of your DB system using suitable industry relevant platform

6. Demonstrate the DB system within a written report and how your system meets the minimum requirements.

7. Include example SQL code to demonstrate creating the relevant tables and querying the database. Extra marks will be awarded for a query which joins two or more tables. This SQL code should be included in the report and be in SQL*Plus format.

8. Provide documentation for the DB system including:

• User Documentation: this should provide instruction and reference to users as to the operation of the system.

• Documentation: this should provide sufficient information for maintenance and enhancement. It should also provide an overview of the system structure, code details      and screen dumps.

• A copy of the whole DB system in a CD.


Deliverables

 

-      Written report submission

  • Submit report and zipped folder containing your code using the Link on Breo  

Full Documentation: A paper-based report to serve as the documentation covering all

steps (1-7 inclusive).

An example structure for your written report may be as follows:

-      An introduction/abstract describing the contents of the whole document and what the purpose of it is

-      A textual description of your scenario

-      Modelling of your scenario including Soft Systems Methodology modelling and UML modelling.

-      Step by step Normalisation of the ER model

-      A final fully Normalised ER model

-      Presentation of the database system developed from the ER model including implemented schema and presentation of the user interface

-      Clear presentation of how the system meets the minimum requirements (as stated in the assignment brief above)

-      Full user documentation for the system

-      Documentation for maintenance of the system and enhancement if necessary

-      An Appendix section including an overview of the system structure, code details and screen dumps.

The document should be no more than 15 pages in total length (excluding references and Appendices).

Pay very special attention to format your document consistently, and make sure that font sizes and styles are consistent, headings are consistent and the whole document is clearly structured and presented.

 

The System Itself:

This will be assessed through your supporting report documents and the fully working system (or link to system if it is on a server) submitted on a CD/zipped folder as part of the full documentation submission. The more functions the better.

Marking Scheme – Individual Assignment 1 all parts

A Range: An excellently detailed but concise individual report, providing a very clear introduction/abstract and plan of work, very clearly describing the problem scenario. A sufficiently complex scenario including SSM, UML and excellent Entity Relationship (ER) modelling of the conceptual schema which very clearly reflects the textual scenario presented earlier. The Normalisation process is carried out in a very logical and clear manner, very clearly and logically showing 1NF, 2NF and 3NF in logical steps. A final Normalised ER model clearly shows the logically presented tables including accurate optionality and all cardinality for all entities and relationships. Excellent SQL code for creating tables and querying database is included. Very clear and well thought out system functionality showing how all of the minimum requirements have been met as outlined in the assignment brief. The document also presents very clear and concise but detailed full user documentation for the user’s benefit.

B Range: A detailed and concise individual report, providing a clear introduction/abstract and plan of work describing the problem scenario. A sufficiently complex scenario including SSM, UML and  good Entity Relationship (ER) modelling of the conceptual schema which clearly reflects the textual scenario presented earlier. The Normalisation process is carried out in a logical and clear manner, clearly showing 1NF, 2NF and 3NF in logical steps. A final Normalised ER model clearly shows the logically presented tables including  optionality and all cardinality for all entities and relationships. Good SQL code for creating tables and querying database is included. Clear and well thought out system functionality clearly shows how the minimum requirements have been met as outlined in the assignment brief. The document also clearly presents user documentation for the user’s benefit.

C Range: A good individual report, providing an introduction/abstract and plan of work describing the problem scenario. A reasonable scenario including SSM, UML and Entity Relationship (ER) modelling of the conceptual schema which reflects the textual scenario presented earlier. The Normalisation process is carried out in a logical manner, showing 1NF, 2NF and 3NF in logical steps. A final Normalised ER model shows the resulting tables including some optionality and cardinality for entities and relationships. System functionality shows how the minimum requirements have been met as outlined in the assignment brief. SQL code for creating tables and querying database is included. The document also presents user documentation for the user’s benefit.

D Range: An adequate individual report, providing an introduction/abstract and plan of work and covering the problem scenario. A scenario including SSM, UML and Entity Relationship (ER) modelling which to some extent reflects the textual scenario presented earlier. The Normalisation process is carried out, showing a progression through the logical steps of normalisation. Some optionality and cardinality for entities and relationships may also be included. SQL code for creating tables and querying database is included. System functionality  shows how a selection of the minimum requirements have been met as outlined in the assignment brief.

E: An inadequate individual report, providing a poor introduction/abstract and not covering the problem scenario adequately. The scenario SSM, UML and Entity Relationship (ER) modelling does not sufficiently reflect the textual scenario presented earlier. The Normalisation process is not carried out to an adequate level, and does not show a clear logical progression through the steps of normalisation. Optionality and cardinality for entities and relationships may also be included but are in the majority of cases inaccurate. System functionality does not show how a reasonable selection of the minimum requirements have been met as outlined in the assignment brief.

F: Not meeting the minimum for the E requirements range


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: 1. Identify what is required and produce a selection of relevant models using a mixture of SSM and UML
  • Price: £ 129
  • Post Date: 2021-01-06T04:53:27+00:00
  • Category: Research Paper Queries
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

1. Identify what is required and produce a selection of relevant models using a mixture of SSM and UML 1. Identify what is required and produce a selection of relevant models using a mixture of SSM and UML
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I have tried other sites for assignment help but the result that Insta Research has produced outweighs others. Since I am weak at writing and shaping the data logically, I am glad I took help from this site. Thanks to my writer for such a great quality of the assignment in Business.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

CIPD assignment is not my cup of tea. That’s the reason I sought out this place suggested by my friend. I would say that the writers of this site are really admiring. I was assigned the best CIPD writer that solved all my issues. He explained to me the difficult topics so well that now I am able to talk on those topics eloquently. I owe my writer a huge thanks and praise! And yes, I would recommend other students as well to come to instaresearch.co.uk for the top CIPD assignment help.