Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
The assignment for a btec level 5 hnd diploma in computing, specifically for the unit 04: database design & development. The assignment requires the student to develop a database system, implement it using sql queries, and produce various queries to perform crud (create, read, update, delete) operations, as well as advanced actions like stored procedures, triggers, and functions. The student is also required to test the system, document it, and provide technical and user documentation. The database system is designed to manage a point-of-sale system, including customer and employee information, product details, and sales receipts. Detailed instructions, sample queries, and illustrations to guide the student through the assignment.
Typology: Assignments
1 / 27
This page cannot be seen from the preview
Don't miss anything!
ASSIGNMENT 2 FRONT SHEET Qualification BTEC Level 5 HND Diploma in Computing Unit number and title Unit 04: Database Design & Development Submission date Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Nguyễn Thành Thông
Student declaration I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that making a false declaration is a form of malpractice. Student’s signature Grading grid P1 M1 D ❒ Summative Feedback: ❒ Resubmission Feedback:
Grade: Assessor Signature: Date: Lecturer Signature:
Task 3 – Test the system (P4 – M4) Once the system has been developed, you will test the system and your manager will complete a witness statement indicating how your tests are performing against user and system requirements. You will produce a brief report assessing the effectiveness of the testing, including an explanation of the choice of test data used Lastly you will produce technical and user documentation which will be given to the company. You want to provide some graphical representations for ease of reference in the technical guide, so you have decided to produce a 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.
Figure 1: Final Mock-Up of the application
A database system based on the designs accepted by the CEO will be provided by the query that creates the table. They will be shown next to the outcomes after they are finished. Figure 2: Create database ASM
To develop a database system, a database in SQL Server must be built: assignment 2 is the database built and used to house this point-of-sale system. Queries will be used to construct tables in order to provide field names, data types, and data validation. 2,2 Create table customer Figure 3 : Create Table Customer 2.3 Create table staff Figure 4 : Create Table Staff 2.4 Create table product
2.7 Create table Report Figure 8 : Create Table Report 2.8 Result Figure 9 : Result
Task 2 – Produce queries 2.1 Queries to INSERT data with illustrations of final result After creating the table, we insert information for the tables as below : Figure 1 0 : Insert Information for table staff Add the required information to the Staff table. You must put information in the Staff table, including staffID, staffname, staffphone, and staffaddress. StaffID can only be 6 characters long, whereas staffName can only be 50 characters, staffPhone can only be 1 5 characters, and staffAddress can only be 50 characters. Figure 11: Insert Information for table customers
Figure 13 : Insert Information for table bill Add the required information to the Bill table. You must put information in the Staff table, including billID, billDate, customerID, and staffID can only be 10 characters long, whereas billDate can only be date,customerID can only be 10characters, and staffID can only be 10 charaters. Figure 14 : Insert Information for table Bill Detail Add the required information to the BillDetail table. You must put information in the Staff table, including billID, productID, quanity can only be 10 characters long, whereas productID can only be 10 characters,quanity can only be 53 float.
Figure 15 : Insert Information for table Report Add the required information to the BillDetail table. You must put information in theReport table, including billID, productID, review can only be 10 characters long, whereas productID can only be 10 characters,quanity can only be 50 charaters. 2.2 Queries to UPDATE data with illustrations of final result During insert data on tables, sometimes user insert wrong data. we will use UPDATE statement to edit data correc. Update data product: Figure 16: Query to update date for Product The result after and before change:
Update data customer: Figure 22: Query to update date for Customer The result after and before change: Figure 23 : Before change Figure 24 : After change Update data Bill: Figure 25 : Query to update date for Bill The result after and before change: Figure 26 : Before change Figure 27 : After change Update data Bill Detail
Figure 2 8: Query to update date for Bill Detail The result after and before change: Figure 29 : Before change Figure 30 : After change Update data Report Figure 31 : Query to update date for Report
Delete data for table Staff Figure 34: Delete data for table Staff Delete data for table Product Figure 35: Delete data for table Product Delete data for table Bill Figure 36: Delete data for table Bill Delete data for table Bill Detail Figure 37: Delete data for table Bill Detail Delete data for table Report
Figure 38: Delete data for table Report 2.4 Queries to SELECT data with illustrations of final result Select 1: List all items with information like the following table based on billID Figure 39 : Select (1)
