ARE YOU LOOKING FOR BEST TUTOR TO WRITE YOUR HIGHER NATIONAL CERTIFICATE/DIPLOMA IN COMPUTING ASSESSMENTS? DO YOU NEED PERFECTLY WRITTEN SOLUTION FOR UNIT 4 DATABASE DESIGN AND DEVELOPMENT ASSIGNMENT?

Qualification - Higher National Certificate/Diploma in Computing

Unit Name - Database Design and Development

Unit Number - Unit 4

Assignment Title - Database Design & Development

Learning Outcome:

Learning Outcome 1: Use an appropriate design tool to design a relational database system for a substantial problem.

Learning Outcome 2: Develop a fully functional relational database system, based on an existing system design.

Learning Outcome 3: Test the system against user and system requirements.

Learning Outcome 4: Produce technical and user documentation.

Assignment Brief:

Case study

You are employed as a Database Developer for a large IT consultancy company. The company has been approached by a company called Bluegenesis which is expanding rapidly due to the huge growth in demand of their products and services from building contractors. New housing developments are growing as a result of the government's agenda to regenerate the old disused factory complexes outside the city of Islamabad.

Bluegenesis have, to date, managed their business by using a computerised system which was developed by a college student five years ago. The system is now too slow and no system documentation was produced when it was implemented so changes to the system cannot be made easily. The CEO of Bluegenesis feels that their business requirements have changed, and they need to invest in new technology and a new system in order to grow and manage their business successfully.

Bluegenesis currently has sales agents who follow up sales leads which are mainly generated from their marketing material and calls taken by staff in the company office. Sales are also generated by the agents who visit building contractors. Each visit from a lead results in a quote and some of these quotes result in an actual sale, either to supply only, or to supply and install. Bluegenesis supplies a huge range of windows and doors. They buy most of their products in bulk from a few large manufacturers and store the products in their warehouse. They also make some bespoke windows and doors in their workshop in the warehouse.

Your company has accepted the contract to develop a database system for Bluegenesis and to provide the necessary technology to run the system. Your brief is to develop the database system element of the contract from Bluegenesis.

You have been asked by your manager to investigate the system requirements; and design, create and implement the system. One of the requirements of the contract is that user and technical documentation be made available to Bluegenesis.

DONT MISS YOUR CHANCE TO EXCEL IN UNIT 4 DATABASE DESIGN AND DEVELOPMENT ASSIGNMENT! HIRE TUTOR OF MIRACLESKILLS.COM FOR PERFECTLY WRITTEN HIGHER NATIONAL CERTIFICATE/DIPLOMA IN COMPUTING UNIT SOLUTIONS!

Part 1

Before you start the development process, your manager has asked you to produce a report for the CEO of Bluegenesis, containing:

1. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables.

2. Clear statements of user and system requirements. (P1)

You would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include interface and output designs, data validations and cover data normalisation. (M1)

Your manager would like a separate report on your assessment of the effectiveness of the design in relation to user and system requirements. (D1)

Part 2

Once the designs have been accepted by your manager you have been asked to develop the database system using evidence of user interface, output and data validations and querying across multiple tables (P2).

You should also demonstrate the creation of table(s) using SQL language(i.e. Create table) (P3)

You want to include more than just the basics, so you will implement a fully functional database system which will include system security and database maintenance features. You may use MS Access for this development (M2)

The developed system will be demonstrated to your manager. Your manager has asked you to produce a report:

1. Assessing whether meaningful data has been extracted through the use of query tools to produce appropriate management information. (M3)

2. Evaluating the effectiveness of the database solution in relation to user and system requirements, and suggest improvements. (D2)

ENROL WITH UNIT 4 DATABASE DESIGN AND DEVELOPMENT ASSIGNMENT HELP SERVICES OF MIRACLESKILLS.COM AND GET BETTER RESULTS IN HIGHER NATIONAL CERTIFICATE/DIPLOMA IN COMPUTING ASSIGNMENTS!

Part 3

Once the system has been developed, you will test the system and your manager will complete a witness statement indicating how your tests are performing against user and system requirements.

You will produce a brief report assessing the effectiveness of the testing (P4), including an explanation of the choice of test data used. (M4)

Lastly you will produce technical and user documentation which will be given to the company (P5). You want to provide some graphical representations for ease of reference in the technical guide, so you have decided to produce a technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works. (M5)

You should also suggest any future improvements that may be required to ensure the continued effectiveness of the database system. (D3)

Grading Criteria

Learning Outcome

Pass

Merit

Distinction

LO1 Use an appropriate design tool to design a relational database system for a substantial problem

P1 Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements.

M1 Produce a comprehensive design for a fully functional system which includes interface and output designs, data validations and data normalisation.

D1 Assess the effectiveness of the design in relation to user and system requirements.

LO2 Develop a fully functional relational database system, based on an existing system design

P2 Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables.

 

P3 Implement a query language into the relational database system.

M2 Implement a fully functional database system which includes system security and database maintenance.

 

M3 Assess whether meaningful data has been extracted through the use of query tools to produce appropriate management information.

D2 Evaluate the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.

LO3 Test the systems against user and system requirements

P4 Test the system against user and system requirements.

M4 Assess the effectiveness of the testing, including an explanation of the choice of test data used.

LO4 Produce technical and user documentation

P5 Produce technical and user documentation.

M5 Produce technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works.

D3 Assess any future improvements that may be required to ensure the continued effectiveness of the database system.

HIRE PROFESSIONAL TUTORS FROM MIRACLESKILLS.COM AND GET BEST QUALITY UNIT 4 DATABASE DESIGN AND DEVELOPMENT ASSIGNMENT HELP AND HIGHER NATIONAL CERTIFICATE/DIPLOMA IN COMPUTING ASSESSMENT HELP SERVICES!

RELATED COURSES & ASSIGNMENT SERVICE!!


COMMENTS(0)

LEAVE A COMMENT


Captcha

 

 

Are You Looking for Database Design and Development Assignment Help?


Featured Higher National Certificate/Diploma in Computing Assignment Help Services of Miracleskills.com!

  • Level 4 Unit 1: Programming Assignment Help 15 Credits
  • Level 5 Unit 37: Architecture Assignment Help 15 Credits
  • Level 5 Unit 28: Prototyping Assignment Help 15 Credits
  • Level 4 Unit 3: Professional Practice Assignment Help 15 Credits
  • Level 4 Unit 8: Computer Systems Architecture Assignment Help 15 Credits
  • Level 4 Unit 2: Networking Assignment Help 15 Credits
  • Level 5 Unit 13: Computing Research Project Assignment Help 30 Credits
  • Level 4 Unit 10: Website Design and Development Assignment Help 15 Credits
  • Level 4 Unit 5: Security Assignment Help 15 Credits
  • Level 5 Unit 34: System Analysis and Design Assignment Help 15 Credits
  • Level 4 Unit 6: Managing a Successful Computing Project Assignment Help 15 Credits
  • Level 5 Unit 40: User Experience and Interface Design Assignment Help 15 Credits
  • Level 5 Unit 14: Business Intelligence Assignment Help 15 Credits