lOMoARcPSD|12116114
Database Design & Development
ASSIGNMENT 1
Learner’s name: Tran The Hao
ID: GCS210785
Class: GCS1003B
Subject code: 1622
Assessor name:
Le Nhi Lam Thuy
Assignment due: 16/6/2022
Assignment submitted:16/6/2022
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
Guidelines and tips
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
Database Design & Development Assignment: FPT Shop Database System, Essays (university) of Information Technology
You are employed as a Database Developer for a large IT consultancy company. The company has been approached by FPT Shop which is expanding due to the growth of the number of stores. FPT Shop is currently facing difficulties in dealing with managing the database from all shops on over country. It decided to develop a new database so that: users can register with their phone numbers as IDs and order or rate, comment for their bought devices, shop managers can take care for their stores and direct
Typology: Essays (university)
2021/2022
1 / 26
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Database Design & Development Assignment: FPT Shop Database System and more Essays (university) Information Technology in PDF only on Docsity!
lOMoAR cPSD| 12116114
Database Design & Development
ASSIGNMENT 1
Learner’s name: Tran The Hao
ID: GCS
Class: GCS1003B
Subject code: 16 22
Assessor name: Le Nhi Lam Thuy
Assignment due: 1 6 /6/2022 Assignment submitted:1 6 /6/
ASSIGNMENT 1 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 Tran The Hao Student ID GCS 210785 Class GCS1003B Assessor name Le Nhi Lam Thuy 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.
Grade: Assessor Signature: Date: Signature & Date:
Assignment Brief 1 (RQF)
Higher National Certificate/Diploma in Computing
Student Name/ID Number: Unit Number and Title: Unit 04: Database Design & Development Academic Year: 2022 Unit Assessor: Tran Trong Minh Assignment Title: Database design Issue Date: 18 Jan 2022 Submission Date: Internal Verifier Name: Date: Submission Format: 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 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. Submission ● Students are compulsory to submit the assignment in due date and in a way requested by the Tutor. ● The form of submission will be a soft copy posted on http://cms.greenwich.edu.vn/. ● Remember to convert the word file into PDF file before the submission on CMS. Note: ● The individual Assignment must be your own work, and not copied by or from another student. ● If you use ideas, quotes or data (such as diagrams) from books, journals or other sources, you must reference your sources, using the Harvard style. ● Make sure that you understand and follow the guidelines to avoid plagiarism. Failure to comply this requirement will result in a failed assignment.
LO1 P1 Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements. M1 Produce a comprehensive design for a fully functional system which includes interface and output designs, data validations and data normalisation. D1 Assess the effectiveness of the design in relation to user and system requirements.
Table of Contents
- I. STATEMENTS OF USER AND SYSTEM REQUIREMENTS
- Statements of user
- System Requirement Specification
- II. DESIGN THE RELATIONAL DATABASE SYSTEM
- Logical design (ERD)
- ER diagram
- III. DATA VALIDATION AND NORMALIZATION
- Data validation:
- Nomalization:
- Database Diagram:
- IV. IMPLEMENTATION..................................................................................................................................
- Code snippets to create database and each table:
- Code snippets to insert some sample data for each table:....................................................................
- Query Command:
- Test Plan:
- REFERENCES
5 OrderDetail Contains detail of order information
- Identify relationships : Entity Multiplicity Relationship Multiplicity Entity Customer 1 Order n Orders Orders 1 Has n OrderDetail Staff 1 Manage n Orders Games 1 Has n OrderDetail
- Identify and associate attributes with entities : Customer Entity No. Attribute Description (^1) CustomerID Contains customer ID 2 CustomerName Contains customer name 3 CustomerPhone Contains customer phone 4 CustomerAddress Contains customer address Primary Key : CustomerID Orders Entity No. Attribute Description 1 CustomerID Contains customer ID 2 OrderID Contains order ID 3 StaffID Contains staff ID 4 OrderDate Contains order date
5 DeliveryDate Contais delivery date Primary Key : OrderID Staff Entity No. Attribute Description 1 StaffID Contains staff ID 2 StaffName Contains staff name 3 StaffPhone Contains staff phone Primary Key : StaffID OrderDetail Entity No. Attribute Description 1 GameID Contains game ID 2 OrderID Contains order ID 3 Quantity Contains quantity of order Primary Key : OrderID and GameID Games Entity No. Attribute Description 1 GameID Contains game ID 2 GameName Contains order ID 3 Price Contains game price 4 Description Contains description about game 5 Quantity Contains game quantity Primary Key : GameID
III. DATA VALIDATION AND NORMALIZATION
1. Data validation:
Customer Table No. Field name Data type Constraint Description 1 CustomerID char(10) Primary Key Customer unique ID 2 CustomerName varchar(30) Not Null Customer name 3 CustomerPhone int Not Null Customer phone number 4 CustomerAddress varchar(100) Customer address Games Table No. Field name Data type Constraint Description 1 GameID char(10) Primary Key Game unique ID 2 GamerName varchar(50) Not Null Game name 3 Price int Not Null Price of game 4 Quantity int Not Null Game quantity 5 Description varchar(500) Description about game Staff Table No. Field name Data type Constraint Description 1 StaffID char(10) Primary Key Staff unique ID 2 StaffName Varchar(30) Not Null Staff name 3 StaffPhone int Not Null Staff phone number
Orders Table No. Field name Data type Constraint Description 1 OrderID char(10) Primary Key Order unique ID 2 CustomerID char(10) Foreign Key of Customer Table Customer unique ID 3 StaffID char(10) Foreign Key of Staff Table Staff unique ID 4 OrderDate datetime Not Null Order Date 5 DeliveryDate datetime Not Null Delivery Date OrderDetail Table No. Field name Data type Constraint Description 1 OrderID char(10) Primary Key Order unique ID 2 GameID char(10) Primary Key Game unique ID 3 Quantity int Not Null Order quantity
2. Nomalization:
1NF (First Normal Form) Rules
3. Database Diagram:
IV. IMPLEMENTATION
1. Code snippets to create database and each table:
- Create database:
- Create Customer table:
- Create Games table: