Download Database Design and Development Assignment Brief for HNC/D in Computing and more High school final essays Computer science in PDF only on Docsity!
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE) Version 1.0 – November 2017 DCL 1 – Public (Unclassified)
Assignment Brief (RQF)
Higher National Certificate/Diploma in Computing
Student Name/ID Number: Unit Number and Title: Unit 4 : Database Design and Development Academic Year: 2020 Unit Assessor: Mrs. Thandar Lwin Assignment Title: AS 2 : Develop and Test a Database System Issue Date: 10 Nov^2020 Submission Date: 9 Dec 2020 via GLMS Internal Verifier Name: Mrs. A Mon Oo Date: Submission Format: The submission is in the form of a fully functional relational database system demonstrated to the Tutor and 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 1 0. 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 3500- 4000 words, although you will not be penalised for exceeding the total word limit.
- Use Microsoft Word for documentation and report.
- Your report must be formatted as follow:
- Font Name : Verdana
- Font Size : 10 Pt
- Line Spacing : .75 inches (round)
- Line Spacing : 1.5 Pt
- Alignment : Justify
- Left Hand Side or Header : Batch Number
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE) Version 1.0 – November 2017 DCL 1 – Public (Unclassified)
- Right Hand Side or Header : Your Name
- Centre of Footer : Page Number
- Use the Harvard referencing System
- Complete the title page and sign the statement of authenticity.
- Your assignment must be submitted in pdf format and Zip format. Interim Review Session (Formative Assessment)
- On 23 rd^ Nov 2020 (Mon)
- On 24 th^ Nov 2020 (Tue) Submit the work (GLMS) to https://moodle.gusto-education.com ➢ 23:59 on 9 th^ Dec, 2020 (Dec) Assignment front sheet submit to Academic Affair on ➢ 9 th^ Dec ,2020 (Wed) Unit Learning Outcomes: LO2 Develop a fully functional relationsl database system, based on an existing system design. LO3 Test the system against user and system requirements. Assignment Brief and Guidance: Case Study You are employed as a Database Developer for a Fairyland Co.,Ltd. Your company was submitted by the Alpine Shop Ltd. with their requirements to create software to solve their requirements. Background information and procedure of Alpine Shop Ltd. Alpine Shop Ltd. plan to computerise the sales ordering system. A feasibility study has indicated that a relational Database should be installed. The details of Alpine Shop Ltd. sales and stock control are as follows: Customers sent orders request for goods. Each order may contain requests for variable quantities of one or more products from Alpine Shop Ltd.’s range. Alpine Shop Ltd. keeps a stock file showing for each product details, including product description, Quantity, Price,Sub Amount, Discount and Discount Amount. In response to the invoices that are sent out to Alpine Shop Ltd.’s customers, the customers send in payments.
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE) Version 1.0 – November 2017 DCL 1 – Public (Unclassified) Office Address No. 117 Wardan Road Lamadaw Yangon 09 - 400 250 100 09 - 400 250 200 09 - 400 250 300 09 - 400 250 400
Part 1 Once the designs have been accepted by your manager you have been asked to develop the database system using evidance of user inteface, output and data validations and querying across multiple tables. You have decided to implement a query language into the relational database system. The developed system will be demonstrated to your manager. Your manager has asked you to produce a report:
- You will implement a fully functional database system which will include system security and database maintenance features.
- Assessing whether meaningful data has been extracted through the use of query tools to produce appropriate management information.
- Evaluating the effectiveness of the database solution in relation to user and system requirements, and give the best suggestion for future improvements. Part 2 Once the system has been developed, you will test the system indicating how your tests are performing against user and system requirements. You will produce a brief report assessing the effectiveness of the testing, including and explanation of the choice of test data used. You have completed the database; you will need to make sure that the database is working correctly. You are required to create documentations a. Support implementation of completed database. In this report you should write evidence for testing your completed database with TSQL statement by taking screen shots of the completed database tables and you need to Insert is rows in each table.
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE) Version 1.0 – November 2017 DCL 1 – Public (Unclassified) b. Report that contains insert command. c. .sql that contains insert command. d. Test plan report. Sample test plan are as follow: Table Name (Product) No Purpose Key/ Constraint Data Type Test Data Description Expected Result Actual Result Pass/ Fail 1 To test the Product ID Primary Key Char(7) NOT NULL PID1 To save the Product ID For the Database to Accept the Product ID The Database accepted the Product ID Pass
- Support testing of completed database that includes as a test plan that tests the main database functionality. Any test failures should be corrected and annotated using screen shots ¡n a test log.
- You will produce a brief report assessing the effectiveness of the testing, including an explanation of the choice of test data used. Note to Students: ➢ Check carefully the submission date and the instructions given with the assignments ➢ Late assignments will not be accepted, except for valid circumstances with supporting evidences ➢ Ensure that you give yourself enough time to complete the assignment by the due date. ➢ Do not leave things such as printing to the late minute-excuses of this nature will not be accepted for failure to hand-in the work on time. ➢ You must take responsibility for managing your own time effectively. ➢ 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. ➢ Take great care that if you use other people's work or ideas in your assignment, you properly reference them in your text and any bibliography.
