database design and development hnd assignment

• No category

e116765-1634752502190-110100-unit-04-database-design-and-development-pamudi

Related documents

Add this document to collection(s)

You can add this document to your study collection(s)

Add this document to saved

You can add this document to your saved list

Suggest us how to improve StudyLib

(For complaints, use another form )

Input it if you want to receive answer

• High School
• You don't have any recent items yet.
• You don't have any courses yet.
• You don't have any books yet.
• You don't have any Studylists yet.
• Information

Unit 04 - Database design and Development - Assignmnet

Hnd in computing, esoft metro campus.

Recommended for you

Students also viewed.

• Big o analisis - dfdadvaddfsfd
• Psoudocode before - ............
• Pp assaignment final doc
• 025646121 - networking
• Heq dip ds syllabus - bcs
• 011304-57-Database-Mohamed Aakil

Related documents

• DHCP - networking
• Dishan Sanjaya Unit 03 - Professional Practice-Holistic Assignment Reworded
• Sample - HND and L7 Pearson registration
• Database-1 - gain the practical knowledge
• Graphic-Practical - gain the practical knowledge
• Software Testing-2 - gain the practical knowledge

Preview text

Higher nationals, internal verification of assessment decisions – btec (rqf).

INTERNAL VERIFICATION – ASSESSMENT DECISIONS

Programme title BTEC HND in Computing

Dileepa Mihiranga Internal Verifier

Unit 04: Database Design & Development

Assignment title

Database Solution for Polly Pipe

Student’s name

R Yasiru Lakshan Rathnayaka

List which assessment criteria the Assessor has awarded.

Pass Merit Distinction

INTERNAL VERIFIER CHECKLIST

Do the assessment criteria awarded match those shown in the assignment brief? Y/N

Is the Pass/Merit/Distinction grade awarded justified by the assessor’s comments on the student work?

Has the work been assessed accurately? Y/N

Is the feedback to the student: Give details:

• Constructive?
• Linked to relevant assessment criteria?
• Identifying opportunities for improved performance?
• Agreeing actions?

Y/N Y/N Y/N

Does the assessment decision need amending? Y/N

Assessor signature Date

Internal Verifier signature Date

Programme Leader signature (if required) Date

Confirm action completed Remedial action taken Give details:

Assessor signature Date Internal Verifier Date

Programme Leader signature (if required)

Formative Feedback: Assessor to Student

Action Plan

Summative feedback

Feedback: Student to Assessor

Student signature

Pearson Higher Nationals in

Assignment 01.

Non-submission of work without valid reasons will lead to an automatic RE FERRAL. You will then be asked to complete an alternative assignment.

If you use other people’s work or ideas in your assignment, reference them properly using HARVARD referencing system to avoid plagiarism. You have to provide both in-text citation and a reference list.

If you are proven to be guilty of plagiarism or any academic misconduct, your grade could be reduced to A REFERRAL or at worst you could be expelled from the course

Student Declaration

I hereby, declare that I know what plagiarism entails, namely to use another’s work and to present

it as my own without attributing the sources in the correct form. I further understand what it

means to copy another’s work.

• I know that plagiarism is a punishable offence because it constitutes theft.
• I understand the plagiarism and copying policy of Edexcel UK.
• I know what the consequences will be if I plagiarise or copy another’s work in any of the assignments for this program.
• I declare therefore that all work presented by me for every aspect of my program, will be my own, and where I have made use of another’s work, I will attribute the source in the correct way.
• I acknowledge that the attachment of this document signed or not, constitutes a binding agreement between myself and Pearson, UK.
• I understand that my assignment will not be considered as submitted if this document is not attached to the assignment.

Student’s Signature: Date: (Provide E-mail ID) (Provide Submission Date)

Assignment brief

Polly Pipe is a water sports provider and installer based in Braintree, England. They need you to design and implement a database that meets the data requirements. These necessities are defined in this scenario and below are samples of the paper records that the Polly Pipe preserves.

Polly Pipe is focused in placing aquariums at business customers. Customers can request several installations, but each installation is tailor-made for a specific customer. Facilities are classified by type. One or more employees are assigned to each facility. Because these

facilities are often very large, they can include carpenters and masons as well as water installers. The facilities use equipment such as aquariums, air pumps and thermostats. There can be multiple computers in a facility.

Below are examples of paper records that Polly Pipe currently maintains.

Staff Management Record Staff Number Name Type SHA1 Dave Clark Plumber SHA8 John Smith Installation Manager SHA2 Freddy Davies Aquatics installer SHA11 McCloud Aquatics installer SHA23 Satpal Singh Plumber SHA66 Winstn Kodogo Aquatics installer SHA55 Alison Smith Brick Layer

Equipment Type Table

Type Equipment Tanks 20 gallon tank, 50 gallon tank, 100 gallon tank, 200 gallon tank Thermostats Standard, Super Air Pumps Standard, Super Filters Air driven, Undergravel

Instillation Management Form

• Identify the user and system requirements to design a database for the above

Installation ID

Installation Type

Installation Name and Address

Customer Equipment Types of Staff Required

Period of Staff assignm ent 234 Freshwater Tropical

Oak House, 17 Wroxton Road, Hertfordshi re, H5 667

2 air pumps 200 gallons fish tank 1 x standard thermostat

1 x Carpenter 1 x Aquatics installer 1 x Electrician

From 1st Septemb er 2012

654 Freshwater Cold

Bayliss House, Orange Street, Kent, K 988

Sally Dench

2 air pumps 200 gallons fish tank Large Gravel Bag 2 x standard thermostat s

5 x Carpenters 1 x Installation Manager 1 x Aquatics installer 1 x Plumber 3 x Labourers

1 st June 2005 – 1 st June 2011

767 Marine Eaglestone Castle, Eaglestone , Kent

Perry Vanderru ne

2 x 200 gallons fish tanks 500 Wood panels

10 x Carpenters 2 x Installation Manager 1 x Aquatics installer 1 x Plumber 3 x Labourers

From 30 th June 2012

943 Marine 23 Sackville Street, Wilts. W

Eric Mackinto sh

No staff required

157 Freshwater Tropical

Humbertso n Castle, Kent, K

2 air pumps 400 gallons fish tank 3 x standard thermostat

1 x Aquatics installer

1 st Septemb er 2005

• 1st Septemb er 2012

Activity 3.

Provide a suitable test plan to test the system against user and system requirements.

provide relevant test cases for the database you have implemented. Assess how the

selected test data can be used to improve the effectiveness of testing. Note:- Learner needs to give expected results in a tabular format and screenshots of the actual results with the conclusion

Get independent feedback on your database solution from the non-technical users and

some developers (use surveys, questioners, interviews or any other feedback collecting

method) and make recommendations and suggestions for improvements in a separate

conclusion/recommendations section.

Produce a technical documentation and a user guide for the developed database system.

Suitable diagrams diagrams (Use case diagram, class diagram, flow charts, DFD level 0 and

• should be included in the technical documentation to show data movement in the

Assess the developed database by suggesting future enhancements to ensure the

effectiveness of the system.

Grading Criteria Achieved Feedback

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 that includes interface and output designs, data

validations and data normalization.

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.

P3 Implement a query language into the relational database

M2 Implement a fully functional database system that

includes system security and database maintenance.

M3 Assess whether meaningful data has been extracted

 What is database?

• Multiple Choice

Course : HND in Computing

University : esoft metro campus.

• Discover more from: HND in Computing ESOFT Metro Campus 999+   Documents Go to course
• More from: HND in Computing ESOFT Metro Campus 999+   Documents Go to course