Download Assignment Information technology database and more Schemes and Mind Maps Information Technology in PDF only on Docsity!
ASSIGNMENT 1 FRONT SHEET
Qualification BTEC Level 5 HND Diploma in Computing Unit number and title Unit 3 : Professional Practice Submission date Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Cao Dang Vinh Khoa Student ID GCS Class GCS1007 Assessor name Huynh Thi My Trang 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 P2 P3 P4 M1 M2 M3 D1 D
Summative Feedback: Resubmission Feedback: Grade: Assessor Signature: Date: Internal Verifier’s Comments: Signature & Date:
Task 1 - Statements of user and system requirements (P1):
1. Overview about the Problem: FPT Shop is currently facing difficulties in handling the database management from all stores across the country. It decided to develop a new database to: assist FPT shop in managing invoices and item suppliers, users can register with their phone numbers as IDs and order or rate, and management can view all data from all stores. 2. Requirements of the application: Analyse the requirements and produce clear statements of user and system requirements. Design a relational database system using appropriate design tools and techniques Develop a fully functional relational database system, based on an existing system design. Test the system against user and system requirements. Produce technical and user documentation **Task 2 – Design the relational database system (P1 – M1):
- Analyse the requirements :**
- Support FPT shop to manage invoices and product suppliers. To manage customers, it is necessary to have a customer description table and based on the requirements to support customers as well as complete the set targets of the restaurant. Then finalize the database based on:
- About customers: customer name, customer code, customer gender, customer address, customer phone number
- employee: employee number, employee name, employee phone number, employee address, employee gender, working day, employee salary.
- On the invoice: invoice number, invoice date, employee code, employee phone number.
- On the detailed invoice: invoice code, item code, sale quantity, total amount.
- On the item: item code, item name, currency, supplier code, price.
- About supplier: supplier code, company name, company address, company email, item.
Database design with explanations: A. Relations: Sale management database has relations as following: nhanvien(manhanvien,hotennhanvien,SDT,diachi,gioitinh,ngayvaolam,luong,CMND) It stores staff information khachhang(SDT,hotenkhachhang,gioitinh,diachi,) It stores customer information mathang(mamathang , tenmathang , donvitiente , manhacungcap , giatien) It stores product information hoadon(masohoadon , ngayxuathoadon , manhanvien , SDT) It stores information of invoices chitiethoadon( masohoadon , mamathang , soluongban , tongtien) It stores invoice details nhacungcap(manhacungcap , tencongty , diachi , Email , mathang) it stores the provider
Staff table Column name Data Type Key Allow nulls StaffCode int PK StaffName nvarchar(50) StaffNumber Int x StaffAddress nvarchar(20) x StaffSex nvarchar(10) StaffWorkingDay Datetime StaffWage nvarchar(20) x StaffID int Supplier table Column name Data Typle Key Allow nulls SupplierCode int PK CompanyName nvarchar(20) SupplierAddress nvarchar(20) SupplierEmail nvarchar(20) SupplierItem nvarchar(20) x Item table Column name Data Typle Key Allow nulls ItemCode int PK ItemName nvarchar(20) CurrencyUnit nvarchar(50) SupplierCode int x ItemPrice nvarchar(50) Customer table Column name Data Typle Key Allow nulls CustomerNumber int PK CustomerName nvarchar(50) CustomerSex nvarchar(10) x
Invoice details table Invoice table Column name Data Typle Key Allow nulls InvoiceCode nvarchar(50) PK InvoiceDate datetime StaffCode nvarchar(50) StaffNumber int (Anon., n.d.) CustomerAddress nvarchar(20) Column name Data Typle Key Allow nulls InvoiceCode nvarchar(50) PK ItemCode nvarchar(50) FK SellNumber nvarchar(50) x TotalMoney Int x
