Download Assignment 2 1622 (D grade) and more Assignments Information Technology in PDF only on Docsity!
ASSIGNMENT 2 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing Unit number and title Unit 04: Database Design & Development Submission date^29 -^4 -^2023 Date Received 1st submission^30 -^4 -^2023 Re-submission Date Date Received 2nd submission Student Name Nguyễn Văn Quang Student ID Gch Class Gch1107 Assessor name Trần Thị Thoa 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 Quang Grading grid P2 P3 P4 P5 M2 M3 M4 M5 D2 D
❒ Summative Feedback: ❒ Resubmission Feedback: Grade: Assessor Signature: Date: Signature & Date:
I. Develop the database system (P2 – P3) 1.1 Final Mock-up of the application Figure 1 : wireframe login interface Figure 2 :Wire frame main page of customer
Figure 3 :wireframe of view page Figure 4 :wireframe of update page
Figure 7 :The Wireframe of product list Figure 8 :The Wireframe of product list after fill in
Figure 9 :The Wireframe of comment list Figure 10 :The Wireframe of comment list after fill in
Figure 13 : wirefame update for manager after fill blank Figure 14 : wireframe result customer for manager
1.2.Queries to create database with results Create database and use database: Here are 2 SQL statements to create a new database named "Shop_FPT_1" and switch to use that database. "CREATE DATABASE" is used to create a new database with the specified name. "USE" is used to select the database to work with the tables and queries in it. Figure 15 : Query to create database Create table Product: Figure 16 :Query to create product table This is a SQL command to create a new table called "Product" in the currently used database, with columns "Product_ID", "Product_Name", "Description", "Price", and "Category_id". The table has a primary key on the "Product_ID" column and a foreign key constraint on the "Category_id" column referencing the "Category" table.
Create table category: Figure 20 : Query to create category table Here is the SQL statement to create a new table named "Category" in the database in use, with columns "Category_id" and "Category_name". This table has a primary key of column "Category_id" and column "Category_name" as unique. Figure 21 : The result of the create table category statement. Create table manager: Figure 22 : Query to create manager table
Here is the SQL statement to create a table "Manager" in the database, with the columns "Manager_ID", "Email", "Fullname", "Address", "Manager_age", "Phone" and "Director_id". This table has a primary key of "Manager_ID" and has a foreign key constraint to the table "Director" through the column "Director_id". Figure 23 : The result of the create table manager statement. Create table comment: Figure 24 : Query to create comment table Here is the SQL statement to create a table "Manager" in the database, with the columns "Manager_ID", "Email", "Fullname", "Address", "Manager_age", "Phone" and "Director_id". This table has a primary key of "Manager_ID" and has a foreign key constraint to the table "Director" through the column "Director_id".
