Database development, Essays (university) of Database Management Systems (DBMS)

Download Database development and more Essays (university) Database Management Systems (DBMS) in PDF only on Docsity!

Pearson Higher Nationals in

Computing Unit 04: Database

Design & Development

Assignment

Shehan Wasala Esoft Metro Campus

Higher Nationals

Internal verification of assessment decisions – BTEC (RQF)

INTERNAL VERIFICATION – ASSESSMENT DECISIONS Programme title BTEC HND in Computing Assessor Mrs Ishani Internal Verifier Unit(s) Unit 04: Database Design & Development Assignment title Database Solution for Polly Pipe Student’s name E.Shehan Wasala 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 signature Date 1 | P a g e S h e h a n W a s a l a E 1 1 8 0 7 6 U n i t 4 D D D

Higher Nationals - Summative Assignment Feedback Form

Student Name/ID Unit Title Unit 04: Database Design & Development Assignment Number 1 Assessor Submission Date 2022.07.06 (^) Date Received 1st submission Re-submission Date Date Received 2nd submission Assessor Feedback: LO1 Use an appropriate design tool to design a relational database system for a substantial problem Pass, Merit & Distinction Descripts

P1 M1 D

LO2 Develop a fully functional relational database system, based on an existing system design Pass, Merit & Distinction Descripts P2 P3 M2 (^) M3 D LO3 Test the system against user and system requirements. Pass, Merit & Distinction Descripts P4 M4 D LO4 Produce technical and user documentation. Pass, Merit & Distinction Descripts P5 M5 D Grade: Assessor Signature: Date: Resubmission Feedback: Grade: Assessor Signature: Date: Internal Verifier’s Comments: Signature & Date:

• 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.

Assignment Feedback

Formative Feedback: Assessor to Student Action Plan Summative feedback Feedback: Student to Assessor Assessor signature Date Student signature Shehan Wasala Date 2022.07.

General Guidelines

1. A Cover page or title page – You should always attach a title page to your assignment. Use previous page as your cover sheet and make sure all the details are accurately filled.
2. Attach this brief as the first section of your assignment.
3. All the assignments should be prepared using a word processing software.
4. All the assignments should be printed on A4 sized papers. Use single side printing.
5. Allow 1” for top, bottom , right margins and 1.25” for the left margin of each page. Word Processing Rules
6. The font size should be 12 point, and should be in the style of Time New Roman.
7. Use 1.5 line spacing. Left justify all paragraphs.
8. Ensure that all the headings are consistent in terms of the font size and font style.
9. Use footer function in the word processor to insert Your Name, Subject, Assignment No, and Page Number on each pag e. This is useful if individual sheets become detached for any reason.
10. Use word processing application spell check and grammar check function to help editing your assignment. Important Points:
11. It is strictly prohibited to use textboxes to add texts in the assignments, except for the compulsory information. eg: Figures, tables of comparison etc. Adding text boxes in the body except for the before mentioned compulsory information will result in rejection of your work.
12. Carefully check the hand in date and the instructions given in the assignment. Late submissions will not be accepted.
13. Ensure that you give yourself enough time to complete the assignment by the due date.
14. Excuses of any nature will not be accepted for failure to hand in the work on time.
15. You must take responsibility for managing your own time effectively.
16. If you are unable to hand in your assignment on time and have valid reasons such as illness, you may apply (in writing) for an extension.
17. Failure to achieve at least PASS criteria will result in a REFERRAL grade.
18. Non-submission of work without valid reasons will lead to an automatic RE FERRAL. You will then be asked to complete an alternative assignment.
19. 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.
20. 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.

1. I know that plagiarism is a punishable offence because it constitutes theft.
2. I understand the plagiarism and copying policy of Edexcel UK.
3. I know what the consequences will be if I plagiarise or copy another’s work in any of the assignments for this program.
4. 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.
5. I acknowledge that the attachment of this document signed or not, constitutes a binding agreement between myself and Pearson, UK.
6. I understand that my assignment will not be considered as submitted if this document is not attached to the assignment. Shehan Wasala [email protected] 06.07. 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

Activity 1

1.1. Identify the user and system requirements to design a database for the above scenario and design a relational database system using conceptual design (ER Model) by including identifiers (primary Key) of entities and cardinalities, participations of relationships. Convert the ER Model into logical database design using relational database model including primary keys foreign keys and referential Integrities. It should contain at least five interrelated tables. Check whether the provided logical Installation ID Installation Type Installation Name and Address Customer Equipment Types of Staff Required Period of Staff assignment 234 Freshwater Tropical Oak House, 17 Wroxton Road, Hertfordshire , 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 September 2012 654 Freshwater Cold Bayliss House, Orange Street, Kent, K7 988 Sally Dench 2 air pumps 200 gallons fish tank Large Gravel Bag 2 x standard thermostats 5 x Carpenters 1 x Installation Manager 1 x Aquatics installer 1 x Plumber 3 x Labourers 1 st June 2005 – 1st June 2011 767 Marine Eaglestone Castle, Eaglestone, Kent Perry Vanderrune 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 30th June 2012 943 Marine 23 Sackville Street, Wilts. W Eric Mackintosh 2 air pumps 200 gallons fish tank 1 x standard thermostat No staff required 157 Freshwater Tropical Humbertson Castle, Kent, K Perry Vanderrune 2 air pumps 400 gallons fish tank 3 x standard thermostat 1 x Aquatics installer 1 st September 2005 – 1st September 2012

Activity 3

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 1) 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.

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

M4 Assess the effectiveness of the testing, including an explanation of the choice of test data used. 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.

ACKNOWLEDGEMENT On this assignment, I've worked harder and spent more time. However, it would not have been possible without the kind support and help of several people and organizations. I want to sincerely thank each and every one of them. I want to express my gratitude to everyone who has been most helpful to me during this endeavor. I am grateful to my teachers for their unwavering assistance with the project. Their support and Their desire to share their knowledge with me and their wise opinions. A special thank you goes out to my coworkers who helped me finish the project. They all shared their own intriguing ideas and thoughts, which enabled me to finish the project with all the necessary details. I want to express my gratitude to the BTEC batch 75 students for their wonderful support and encouragement, which enabled me to complete this assignment. I want to sincerely thank and appreciate everyone in the business who has given me their time and undivided attention. Finally, I want to express my sincere gratitude to my family members for giving me the moral support I needed to finish the project. Without their ongoing support, I could not have completed this task.

the fact that requirements are defined for customers, business managers, system engineers, and other experts. Those are the key categories where the requirements are defined. 1.1.3 User requirement User requirements are natural-language statements with diagrams that describe the services the system is expected to provide to system users as well as the constraints it must operate under. User requirements might range from broad assertions of system requirements to specific requests. Definitions of system operation that are extensive and exact. User needs are defined as the things that users expect if the notion is defined from the computer system. A list of system requirements that can be used to allow you to make one. The customer requirements for the Polly Pipe System are as below.  The data has been revised.  Keep records of all staff-management, facility, payment, installation, equipment, customer, and employee information.  Integrating new customers into the system  Updates to the installation system.  Creating new customer transactions. 1.1.2 System requirement System requirements are the specifications that developers use to develop this system. These are the requirements that require a much more in-depth understanding of the system. There are two types of system requirements:  Functional requirements  Nonfunctional requirements

1.1.1 Functional requirements These are technical requirements for how the system should work, such as what kind of software the database will need to run and what kind of physical gear it will need. Requirements define what the system developer must include in the system in order to create the needed system.  All objects can be added, updated, and deleted.  Use [customer id] and [customer name] to find customer information. [Employee Identifier, Employee Name] Employee information  [Manager, employees, and customer] login options 1.1 Nonfunctional requirements These are system components that are not covered by functional requirements and have to do with unique behavioral characteristics. The Polly Pipe system's non-functional requirements are listed below.  Accessibility  Performances  Usability  Storage  Disaster Recovery  Maintainability  Flexibility  Security