Title DDD Guide Final ✅

ASSIGNMENT FINAL REPORT Qualification Pearson BTEC Level 5 Higher National Diploma in Computing Unit number and title Unit 4: Database Design & Development Submission date Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Student ID Class SE08101 Assessor name Bui Thi Trang Plagiarism Plagiarism is a particular form of cheating. Plagiarism must be avoided at all costs and students who break the rules, however innocently, may be penalised. It is your responsibility to ensure that you understand correct referencing practices. As a university level student, you are expected to use appropriate references throughout and keep carefully detailed notes of all your sources of materials for material you have used in your work, including any material downloaded from the Internet. Please consult the relevant unit lecturer or your course tutor if you need any further advice. Student Declaration I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I declare that the work submitted for assessment has been carried out without assistance other than that which is acceptable according to the rules of the specification. I certify I have clearly referenced any sources and any artificial intelligence (AI) tools used in the work. I understand that making a false declaration is a form of malpractice.


Table of Contents A. Introduction....................................................................................................................................................8 B. Contents......................................................................................................................................................... 8 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........................................ 8 1. Scenario.................................................................................................................................................. 8 1.1. User requirements...........................................................................................................................8 1.2. System requirements.......................................................................................................................8 1.2.1. General requirements...............................................................................................................8 1.2.2. Functional requirements.......................................................................................................... 9 1.3. Security requirements..................................................................................................................... 9 2. Identify the problem to be solved by the relational database management system........................... 10 2.1. Relational database management system..................................................................................... 10 2.2. Identify the problem to be solved by the relational database management system in Store X's Sales Management System...................................................................................................................10 2.2.1. Core function requirements................................................................................................... 10 2.2.1. Storage data requirements..................................................................................................... 10 3. Design the relational database system................................................................................................. 10 3.1. Conceptual design......................................................................................................................... 10 3.1.1. Identify entities.......................................................................................................................10 3.1.2. Identify relationships between entities.................................................................................. 10 3.1.3. Identify attributes...................................................................................................................11 3.1.4. Identify attribute domains......................................................................................................11 3.1.5. Identify candidate keys, primary keys, alternate keys............................................................ 12 3.2. Logical design.................................................................................................................................12 3.2.1. Design the tables needed in the database and set up constraints......................................... 12 3.2.2. Normalization......................................................................................................................... 12 3.2.3. Entity-relationship diagram (ERD)...........................................................................................12 3.3. Physical design...............................................................................................................................13 3.3.1. Create database and tables in SQL Server.............................................................................. 13 3.3.2. Insert data into the tables.......................................................................................................13 3.3.3. Database diagram...................................................................................................................13 4. Design the table about user requirements and system requirements for the database...................... 13 4 | Page