Download Database Design & Development Assignment for HNC/D 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 1 : Database Design and Documentation Issue Date: 13 Oct^2020 Submission Date: 9 Nov 2020 via GLMS Internal Verifier Name: Mrs. A Mon Oo Date: Submission Format: 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 subsecitons as appropriate, and all work must be supported with research and referencing using the Harvard referncing system. Interim Review Session (Formative Assessment)
- On 2 nd^ Nov 2020 (Mon)
- On 3 th^ Nov 2020 (Tue) Submit the work (GLMS) to https://moodle.gusto-education.com ➢ 23:59 on 9 th^ Nov, 2020 (Mon) Assignment front sheet submit to Academic Affair on ➢ 10 th^ Nov ,2020 (Tue)
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE) Version 1.0 – November 2017 DCL 1 – Public (Unclassified) 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 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 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
- 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. You must provide of your references, internet Sites or book names. Use Harvard referencing for book references. Unit Learning Outcomes: LO1 Use an appropriate deisgn tool to design a relational database system for a substantial problem. LO4. Produce technical and user documentation. 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.
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE) Version 1.0 – November 2017 DCL 1 – Public (Unclassified) Total 18000 tax(5%) Delivery Fee 0 Final Total 18000 Office Address No. 117 Wardan Road Lamadaw Yangon 09 - 400 250 100 09 - 400 250 200 09 - 400 250 300 09 - 400 250 400
Before you start the development process, your manager has asked you to produce a report for the CEO of Alpine Shop Ltd., containing:
- The design of the relational database system using appropriate design tools and techniques. It should contain at least five interrelated tables. ❖ Produce a detailed design document, so you will produce a comprehensive design for a fully functional system which will include Entity Relationship Diagram (ERD), Data normalization that cover data validations and cover data normalization. Moreover, you should prepare a separate report on your assessment of the effectiveness of design in relation to user and system requirements with real world examples.
- Produce technical and user documentation. ❖ Create technical documentation for a developed relational database system based on ERD diagram and Normalization. Moreover, in your documentation including diagrams showing movement of data through the system, and flowcharts describing how the system works and describe detail data type and constraint explanation. ❖ Create user documentation and apply a range of database tools and techniques to enhance the user
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE) Version 1.0 – November 2017 DCL 1 – Public (Unclassified) interface for Alpine Shop. Moreover, your interface design should perfect and your user documentation including GUI form should be applied all of database query that represent fully functional database system and creative color, design and relevant logo and contains only sample screen shoot. ❖ Layout Forms and reports ❖ Use of logs (Forms and reports) ❖ Naming of tables and fields Finally, you should Create extra report that include future improvements that may be required to ensure the continued effectiveness of the database system. In your report you must give the suggestion from technical point of view and how to improve current database system. In addition, you would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include the following:
- Create forms user interface for adding records, deleting records and amend records for tables you have ceated a part of the solution.
- All the forms required to include appropriate validation rules which minimise data entry errors.
- Company required print invoices for the orders that have been placed. The invoice should meet the following requirements: o there should be one invoice per order o Alpine Shop Ltd.’s name and address must be displayed o the customer contact and address details must be displayed o The order number and the details for the order, including the product details and o quantity, must be displayed. o The total cost of the order should be calculated and displayed. Moreover, you should prepare a separate report on your assessment of the effectiveness of design in relation to user and system requirements with real Word examples.
