Design and create a database to solve a real world problem

PayPal Acceptance Mark

Order Details
Most required features and functions have their purpose defined with an awareness that there will be a different audience for some elements;
process diagrams are presented for major functions;
An Entity-Relationship Diagram, including most attributes and many clear relationships;
Details of most of the queries needed, how they might look and explanation as to why most of them are needed;
Clear and consistent designs for many of the forms and reports with indications who would use them and special features identified
Consideration of the main user is clear including their likely skill level.
A range of strategies are proposed to ensure data is valid
A variety of error handling processes are proposed to avoid application crashes. The user is supported in some case
Clear. Covering most processes, error messages
Some special features such as macros, vb code or other feature explained
Clear, full and systematic testing evidenced for many aspects
Honest reflection of many aspects of the database against the proposal
Described with many issues identified
Purpose and many functions described Dif
1. Analyse and represent an information system using data models
2. Interrogate the data in a database
3. Create a useable interface incorporating input and output
4. Understand the implications of data security
Task 1: To submit a proposal outlining the problem and suggested solution. (5% of the total marks for this assignment)
Addressing learning outcome 1:
1. Analyse and represent an information system using data models
This initial statement of requirements should be about 400 words in length and must be agreed by the tutor before progression. It should outline, in non-technical language, the purpose of the database and what functions it is required to perform.
Task 2: To document the design and solution (45% of the total marks for this assignment);
Addressing learning outcomes 1 and 4:
The documentation to consist of
1b) Systems analysis (3 marks)
After the initial statement has been agreed, a detailed systems analysis should be carried out, to determine in detail the required features and functions of the system.
2) Design (12 marks);
This will include a detailed Entity-Relationship Diagram, including attributes, together with details of queries needed, and designs for forms and reports. Consideration must be given to how users will operate the database, the sophistication of the users and how you propose to eliminate errors and maintain security of data.
3) User Instructions (6 marks)
Appropriate instructions for users on how to accomplish the various tasks within the database
4) Technical Documentation (4 marks)
For someone who may need to amend the database design: An explanation of any special features such as event coding, properties of controls etc
5) Evidence of testing the database (10 marks)
Documentary evidence that you have created adequate test data and satisfactorily tested the database. The test data should include an appropriate number of records and a suitable range of data.
6) Evaluation of the final database (6 marks)
Does it do what you set out in your initial proposal (requirements analysis)? What aspects need to be corrected, amended or completed? How could this database be improved?
Part 3: To create a working database that meets the proposal (with Tutor amendments if required) (50% of the total marks for this assignment)
Addressing learning outcomes 2, 3 and 4

PayPal Acceptance Mark

Do You Need A Similar Assignment?

Place an order with us. Our skilled and experienced writers will deliver a custom paper which is not plagiarized within the deadline which you will specify.

Note; 6 Hours urgent orders deliver also available.

If you need more clarifications contact our support staff via the live chat for immediate response.


Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page: