Download Unit 04 Database-Assignment RQF and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!
Higher Nationals
Internal verification of assessment decisions – BTEC (RQF)
INTERNAL VERIFICATION – ASSESSMENT DECISIONS Programme title Database Design&Development Assessor Mr.Dilshan Internal Verifier MR. Santhosh Unit(s) Unit 0 4 : Database Design & Development Assignment title Data base system for the SmartMovers Transport Company Student’s name Darshan kumaran 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 Programme Leader signature (if required) Date
Higher Nationals - Summative Assignment Feedback Form
Student Name/ID Darshan kumaran Unit Title Unit 0^4 :^ Database Design & Development Assignment Number 1 Assessor Mr.Dilshan Submission Date 08 /0 8 /2019 (^) 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 P 2 M2 M3 D LO3 Test the system against user and system requirements. Pass, Merit & Distinction Descripts P 3 M 4 D LO4 Produce technical and user documentation. Pass, Merit & Distinction Descripts P 4 P 5 M (^5) 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.
General Guidelines
- A cover page or title page should be attached to your assignment. Use page 1 of this assignment brief as your cover page and make sure all details are accurately filled.
- The entire assignment brief should be attached as the first section of your assignment.
- The assignment should be prepared using a word processing software.
- The assignment should be printed single sided in an A4 sized paper.
- Allow 1” margin on top, bottom and right sides of the paper and 1.25” on the left side (for binding). Word Processing Rules
- The font size should be 12 point, and should be in the style of Time New Roman.
- Set line spacing to 1.5. Justify all paragraphs.
- Ensure that all headings are consistent in terms of size and font style.
- Use footer function on the word processor to insert your name, unit, assignment no, and page number on each pag e. This is useful if individual sheets get detached from the submission.
- Use the spell check and grammar check function of the word processing application to review the use of language on your assignment.
Important Points:
- Carefully check carefully the hand in date and the instructions given with the assignment. Late submissions will not be accepted.
- Ensure that sufficient time is spent to complete the assignment by the due date.
- Do not wait till the last minute to print or bind the assignment. Such excuses will not be accepted for late submissions.
- You must be responsible for efficient management of your time.
- 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.
- Failure to achieve at least a PASS grade will result in a REFERRAL grade.
- Non-submission of work without valid reasons will lead to an automatic REFERRAL. You will then be asked to complete an alternative assignment.
- If you use other people’s work or ideas in your assignment, it must be properly referenced, using the HARVARD referencing system, in your text or any bibliography. Otherwise, you’ll be found guilty of committing plagiarism.
- If you are caught plagiarising, your grade will be reduced to a REFERRAL or at worst, you could be excluded from the course.
Higher National Diploma in Computing
Assignment Brief
Student Name /ID Number (^) Darshan kumaran Unit Number and Title Unit 4: Database Design & Development Academic Year (^) 2018/ Unit Tutor Mr.Dilshan Assignment Title Data base^ system for the SmartMovers Transport Company Issue Date (^) 08/07/ Submission Date (^) 08/08/ IV Name & Date Submission format sPart 1: The submission is in the form of an individual written report. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of 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. The recommended word limit is 2,000–2,500 words, although you will not be penalised for exceeding the total word limit. Part 2: The submission is in the form of a fully functional relational database system demonstrated to the Tutor; and an individual written report (please see details in Part 1 above). Part 3: The submission is in the form of a witness statement of the testing completed by the Tutor; technical documentation; and a written report (please see details in Part 1 above). Unit Learning Outcomes: 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: *Please note that assignment guidance is for reference only and should be more specific in detail to meet customized needs. Assignment brief Case study You are employed as a Database Developer for a large IT development company. The company has been approached by a transport company called SmartMovers which has grown to a level where need to have an automated system to handle day today operational activities to meet customer demands. You are given the job to design and develop a database solution for SmartMovers to meet their business requirements. The company transports chemical products from one location to another on behalf of registered customers. Customers are of three types namely Catogory1, 2 and 3. Each customer is given a unique customer number and his or her details have to be recorded in the system. Each transport operation is called a job, which involves picking up one or more loads of the products from a customer requested start location and delivers it to a customer requested destination. A unique number is given for each job and for each load when they are created. A Load is transported using a particular transport unit, which consists of a lorry, a driver, assistant, and a container (for carrying the product) A container is fixed to a trailer so it needs to be coupled to a lorry at the start of a Job. (Single container can transport only one chemical product due to safety requirements) Payments for a job depends on customer type, product type (No Risk, High risk) and the load type (small, medium and large). Transport operations are run from 9 regional depots. Jobs are allocated to individual depots to service. Depots hold, manage and maintain their own transport units which are permanently allocated to them to service Jobs. Normally transport units are held at the base Depot they belong.
Activity 2
Activity 2. Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables. a. Develop a relational database system according to the ER diagram you have created (Use SQL DDL statements). b. Provide evidence of the use of a suitable IDE to create a simple interface to insert, update and delete data in the database c. Implement the validation methods explained in task 1.2-part c. d. Display the details payment with the job details and the customer details using Join queries Activity 2. a. Explain the usage of DML with below mentioned queries by giving at least one single example per each case from the developed database. Select Update Delete Note: - The queries you have selected should be meaningful and relevant to the given scenario. Activity 2. a. Explain how security mechanisms have been used and the importance of these mechanisms for the security of the database. Implement proper security mechanisms (EX: - User groups, access permissions) in the developed database.
Activity 2. a. Explain the usage of the below SQL statements with the examples from the developed database Group by Order by Having Between Where
Activity 3
Activity 3. a. Provide a suitable test plan to test the system against user and system requirements b. Provide relevant test cases for the database you have implemented Note:- Learner needs to give expected results in a tabular format and screenshots of the actual results with the conclusion Activity 3. a. Explain how the selected test data in task 3.1 b) can be used improve the effectiveness of testing. Activity 3. a. 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.
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 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 that includes system security and database maintenance.
M3 Assess whether meaningful data has been extracted using query tools to produce appropriate management information.
Darshan Kumaran Unit 04: Database Design & Development 21 Acknowledgments Firstly, I want to thank God for giving me the knowledge and inspiration to Do this Assignment. I also want to thank my parents, my brothers and my partner for their support. A special thanks to our lecturer Mr. Dilshan who supported me throughout this assignment. Also a special thanks to our branch manager Mr.Santhosh who has also been involved in supporting and encouraging us throughout the assignment. Thank You Darshan Kumaran
Table of Contents
- Darshan Kumaran Unit 04: Database Design & Development
- List of Tables
- List of Figures
- Activity - Activity1.1 - Activity 1.2 - Activity 1.3
- Activity - Activity 2.1 - Activity 2.2 - Activity 2.3 - Activity 2.4
- Activity - Activity 3.1 - Activity 3 .2 - Activity
- Activity - Activity4.1 - Activity 4 .2 - Activity
- List of References
- Gant Chartt
- Darshan Kumaran Unit 04: Database Design & Development
- Table 1: Cost of Hardware Software Requirements List of Tables
- Table 2: Entities and Attributes
- Table 3: Student table
- Table 4: Employee table
- Table 5: Employee table 1NF
- Table 6: Products table
- Table 7: Products Category table
- Table 8: Brand table
- Table 9: Products Brand table
- Table 10 : Test Case table
- Table 11 : Test Case table
- Table 12 : Test Case table
- Table 13 : Test Case table
- Table 14 : Test Case table
- Table 15 : Test Case table
- Table 16 : Test Case table
- Table 17 : Test Case table
- Table 18 : Test Case table
- Table 19 : Test Case table
- Table 20 : Test Case table
- Table 21 : Test Case table
- Table 22 : Test Case table
- Table 23 : Test Case table
- Table 24 : Test Case table
- Table 25 : Test Case table
- Table 26 : Test Case table
- Darshan Kumaran Unit 04: Database Design & Development
- Table 27 : Test Case table
- Table 28 : Test Case table
- Table 29 : Test Case table
- Table 30 : Test Case table
- Table 31 : Test Case table
- Table 32 : Test Case table
- Table 33 : Test Case table
- Table 34 : Feedback table
- Table 35 : Feedback table
- Table 36 : Feedback table
- Table 36 : Feedback table
- Table 36 : Feedback table
- Table 36 : Feedback table
- Table 36 : Feedback table
- Darshan Kumaran Unit 04: Database Design & Development
- Figure 1. Entity Relationship Diagram List of Figures
- Figure 2 Admin Interface to Insert, Delete, Update and Search Data from Customer Table................
- Figure 3 Admin Interface to Insert, Delete, Update and Search Data from Depot Table
- Figure 4 Admin Interface to Insert, Delete, Update and Search Data from Product Table..................
- Figure 5 Admin Interface to Insert, Delete, Update and Search Data from T.U Table
- Figure 6 Admin Interface to Insert, Delete, Update and Search Data from Job Table..........................
- Figure 7 User Interface to Search Data from Customer Table
- Figure 8 User Interface to Search Data from Depot Table....................................................................
- Figure 9 User Interface to Search Data from Product Table
- Figure 10 User Interface to Search Data from Transport Unit Table
- Figure 11 User Interface to Search Data from Job Table
- Figure 12 Smart Movers effective ERD
- Figure 13 Customer Table
- Figure 14 CustomerTelno Table
- Figure 15 Location Table
- Figure 16 Depot Table...........................................................................................................................
- Figure 17 DepotTelno Table
- Figure 18 Payment Table
- Figure 19 TransportUnit Table..............................................................................................................
- Figure 20 TransportUnitTelno Table
- Figure 21 Load Table
- Figure 22 Job Table
- Figure 23 Product Table
- Figure 24 Evidence
- Figure 25 Evidence
- Figure 26 Evidence
- Figure 27 Evidence
- Figure 28 Evidence
- Figure 29 Evidence
- Figure 30 Evidence
- Figure 31 Evidence
- Figure 32 Evidence
- Figure 33 Evidence
- Figure 34 User Authentication Customer UI
- Figure 35 lengths for the field mentioned with datatype.......................................................................
- Figure 36 Customer UI Have lookup box
- Figure 37 ‘Not Null’ Statement make the field Mandatory
- Figure 38 BETWEEN Operator used for validate by range check…………………..………..............
- Figure 39 after exaction of sql Inner joint query
- Figure 40 Results for Insert query
- Figure 41 Results for Update query
