We're Open

  100% Pass and No Plagiarism Guaranteed

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

Student Name /ID Number

 

Unit Number and Title

Unit 4 : Database Design & Development

Academic Year

2021-22

Unit Assessor

 

Assignment Title

Dollis Hill GP Surgery Database

Issue Date

23/11/2021

Submission Date

22/03/2022

IV Name  

 

Date

15/09/2021

Submission Format:

The submission has to be in the form of written report for each individual task that includes the screen shots of design (MS-VISIO) of the database as well as the implemented database (screenshots from MS-ACCESS) where appropriate. You are required to make use of task number, headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system. Please also provide a bibliography using the Harvard referencing system. Also, the implemented relational database system must be submitted and demonstrated to the Tutor; Testing must be completed in Tutor’s presence.

Unit Learning Outcomes: Unit 4 : Database Design & Development

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

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

LO3 Test the system against user and system requirements.

LO4 Produce technical and user documentation

Assignment Brief and Guidance:

Case Scenario

You have got a database design and management company called Info-Solution Database Ltd. Your client Dollis Hill GP Surgery wants your company to create and maintain their appointment management database to maintain details of its doctors, patients, appointments, test prescribed, nurses etc. According to the Surgery’s requirement:

Each doctor can be identified by unique doctor id, doctor’s name, doctor speciality.

Each patient can be identified by unique patient id, patient name, patient phone number, patient date of birth.

Each nurse can be identified by unique nurse id, nurse’s name.

Details of doctor’s appointment should show which doctor is treating which patient on which date and time, and medical problem of the patient being diagnosed.

Details of prescribed tests should show which doctor ordered for the test for which patient, and which nurse will administer the test on which date and time. It will show what type of test it is. 

Unit 4 : Database Design & Development

Student Name/ID

 

Unit Title

 Database Design & Development

Assignment Number

Assignment 01

Assessor

 

 

Submission Date

22/03/2022

Date Received 1st submission

 

 

Re-submission Date

 

Date Received 2nd submission

 

Assessor Feedback:

Grade:

Assessor Signature:

 

Date:

Resubmission Feedback:

 

Grade:

 

Assessor Signature:

 

Date:

Internal Verifier’s Comments:

Signature & Date:

You as an employee of Info-Solution Database Ltd are required to provide the design and implement the same design to produce a fully functional database system to help Dollis Hill GP Surgery to carry out its tasks efficiently.

Task 1 a)-(LO1)

 i. Make a list of user requirements and system requirements based on the given scenario

ii.  Provide ERD made based on the user requirements and system requirements(in MS-Visio) for 3NF with explanation.

Task 1 b)-(LO1)

  1. Based on the given scenario describe the process of Normalisation (with diagrams in MS-Visio) up to 3NF (i.e. UNF,1NF,2NF,3NF)
  1. Design an appropriate database for the given scenario. The design documentation must include:
  • An entity relationship diagram (3NF stage only) with correct cardinality in MS-ACCESS.
  • Design of the tables, input forms based on ERD 
  • Designs of at least four complex database queries and four database reports that could be used by the organisation as described by the scenario. All reports must be created from complex database queries. 

Task 1 c)- (LO1) Evaluate the effectiveness of the ERD in terms of user and system requirements using a requirements traceability matrix .

Task 2 a) – (LO2)

 Implement the design and provide evidence of the implementation via annotated screenshots.  Create all the required tables, forms and reports.

Task 2 b)- (LO2)

  1.   i.   Make ‘USER-ID’ and ‘PASSWORD’ mechanism to secure the implemented database.
  2.   ii.   Provide annotated screenshot as an evidence of implemented database maintenance.

Task 2 c)-(LO2)

Create all the queries using SQL code and provide evidence of the implementation via annotated screenshots and source code.

Task 2 d)—(LO2) Include query validation methods where as per the management’s requirement (e.g. number of appointments done by a doctor per day.)

Task 3 a) – (LO3) Test the system using an appropriate test plan. Amongst other things testing must demonstrate that entity integrity, referential integrity and data integrity has been enforced, buttons are working properly, user interface matches the user requirement.

Task 3 b)- (LO3) Provide evidence of successful testing by producing a test report based on the test plan (in TASK 3a) including an explanation of the choice of test data used.

Task 3 c ) - (LO2 & LO3) Critically evaluate the strengths and weaknesses of the database created in the previous tasks and suggest methods for improvement if required. 

Task 4 a ) (LO4)

    i. Produce a user-manual for the implemented database.

    ii. Produce a data dictionary for the implemented database.

Task 4b) (LO4) 

 Produce a data flow diagram and a flow-chart for the implemented database with proper explanation of each.

Task 4 c) (LO4)

 Justify, how the future improvements that have been suggested in Task 3c) are helpful in overcoming the weaknesses of the database system Unit 4 : Database Design & Development

 

Pearson Education 2016

Higher Education Qualifications

Assignment Brief

 

Learning Outcomes and Assessment 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 Evaluate 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.

 

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

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

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

P3 Implement a query language into the relational database system  .

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 system 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

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

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

Evaluate the database in terms of improvements needed to ensure the continued effectiveness of the system.

Student Assessment Submission and Declaration Unit 4 : Database Design & Development

When submitting evidence for assessment, each student must sign a declaration confirming that the work is their own.

Student name:

Assessor name:

Issue date:   23/11/2021

Submission date:  22/03/2022

Submitted on:

Programme: Higher National Certificate/Diploma in Computing

Unit:   4 : Database Design & Development

Assignment number and title: Assignment 01- Dollis Hill GP Surgery Database

       

Plagiarism

Plagiarism is a particular form of cheating. Plagiarism must be avoided at all costs and students who break the rules, however innocently, may be penalised.  It is your responsibility to ensure that you understand correct referencing practices.  As a university level student, you are expected to use appropriate references throughout and keep carefully detailed notes of all your sources of materials for material you have used in your work, including any material downloaded from the Internet. Please consult the relevant unit lecturer or your course tutor if you need any further advice.

Student Declaration

Student declaration

I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that making a false declaration is a form of malpractice.

Student signature:                                                             Date:

 

Student Name/ID

 

Unit Title

 Database Design & Development

Assignment Number

Assignment 01

Assessor

 

 

Submission Date

22/03/2022

Date Received 1st submission

 

 

Re-submission Date

 

Date Received 2nd submission

 

Assessor Feedback:

Grade:

Assessor Signature:

Date:

Resubmission Feedback:

Grade:

Assessor Signature:

Date:

Internal Verifier’s Comments:

Signature & Date:

 

Pearson Education 2016

Higher Education Qualifications

Summative Assignment Feedback Form

 * Please note that grade decisions are provisional. They are only confirmed once internal and external moderation has taken place and grades decisions have been agreed at the assessment board

Unit 4 : Database Design & Development

StudentName/ID

 

UnitTitle

 Database Design & Development

AssignmentNumber

Assignment 01

Assessor

 

 

SubmissionDate

22/03/2022

DateReceived1stsubmission

 

 

Re-submissionDate

 

DateReceived2ndsubmission

 

AssessorFeedback:

 

Grade:

 

AssessorSignature:

 

Date:

ResubmissionFeedback:

 

Grade:

 

AssessorSignature:

 

Date:

InternalVerifier’sComments:

Signature&Date:


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


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

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

We've produced some samples of what you can expect from our Academic Writing Service - these are created by our writers to show you the kind of high-quality work you'll receive. Take a look for yourself!

View Our Samples