Download Database Design and Development for Polly Pipe and more Study notes Computer Science in PDF only on Docsity!
Higher Nationals
Internal verification of assessment decisions – BTEC (RQF)
INTERNAL VERIFICATION – ASSESSMENT DECISIONS Programme title BTEC^ HND^ in Computing Assessor Internal Verifier Unit(s) Unit 04: Database Design & Development Assignment title Database Solution for Polly Pipe Student’s name W.A.dilan Jason ondre fernando 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? Y/N 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 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 1
signature Programme Leader signature (if required) Date 2
Formative Feedback: Assessor to Student Action Plan Summative feedback Feedback: Student to Assessor Assessor signature Date Student signature Date 4
Pearson Higher Nationals in
Computing
Unit 04: Database Design & Development
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 7
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 ) [email protected] 10/08/ 8
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 10
Instillation Management Form
Activity 1
1.1. Identify the user and system requirements to design a database for the above 11 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 Lee A. sun 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 2 air pumps 200 gallons fish tank 1 x standard thermostat No staff required 157 Freshwater Tropical Humbertso n Castle, Kent, K Perry Vanderru ne 2 air pumps 400 gallons fish tank 3 x standard thermostat 1 x Aquatics installer 1 st Septemb er 2005
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 Activity 3. 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.
Activity 4
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 system. Assess the developed database by suggesting future enhancements to ensure the effectiveness of the system. 13
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 14
LO2 & LO
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. 16
Database Solution for Polly Pipe
Report by Dilan Jason//DDD//
th
august 2021
ACKNOWLEDGEMENT
I would like to express deep appreciation and indebtedness to the following: Lecturer- Miss indumini, coordinators- Miss Madushi and Miss Sanjeewani for their endless support, kind and understanding spirit throughout the course. And I would like to thank esoft metro campus for the facilities provided to accomplish this project. 17
ER diagrams help explain the logical structure of a database before implementing the database system. ER model of Polly pipe database- Logical database
Database normalization
Normalization is the process of reorganizing data in a database. There are no data redundancy in a normalized database, data dependencies are logical and all data items are stored together. The first normal form (1NF) – A table in which the intersection of every column and record contains only one value (no multiple values), for example in Instillation Management Form has multiple values so it is not in 1NF. To 1NF- The second normal form (2NF) – A table that is in 1NF and every non-primary key column is fully functional dependent on the primary key. Example in this case, Facilitytype instaID, E.No, CID customerID CID, address, Cname employeenumber Ename, Etype equipmentType Equipment The third normal form (3NF) – A table that is in 1NF and 2NF and in which non primary key column is transitively dependent on primary key. Example in this case, primary key customer ID has become the foreign key in installation table- 20 Installation Name and Address Oak House, 17 Wroxton Road, Hertfordshire, H5 667 Bayliss House, Orange Street, Kent, K7 988 Eaglestone Castle, Eaglestone, Kent 23 Sackville Street, Wilts. W Humbertson Castle, Kent, K Installation ID Installation Name 234 H5 667 654 K7 988 767 Kent 943 W 157 Kent, K Installation ID Address 234 Oak House, 17 Wroxton Road, Hertfordshire 654 Bayliss House, Orange Street 767 Eaglestone Castle, Eaglestone 943 23 Sackville Street. 157 Humbertson Castle
