Download Database Design and Development - Prof. Pham and more Cheat Sheet Information Technology in PDF only on Docsity!
ASSIGNMENT 2 FRONT SHEET
Qualification BTEC Level 5 HND Diploma in Computing Unit number and title Unit 3 : Database Design & Development Submission date 05/12/ Date Received 1st submission
Re-submission Date 12/12/^ Date Received 2nd submission
Student Name Pham Minh Thong Student ID BDAF Class SE06202 Assessor name Nguyen Hoang Anh Vu 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 Thong Grading grid P2 P3 P4 P5 M2 M 3 M 4 M5 D 2 D
❒ Summative Feedback: ❒ Resubmission Feedback:
Grade: Assessor Signature: Date: Signature & Date:
- TABLE OF CONTENT
- INTRODUCTION
- BASED ON AN EXISTING SYSTEM DESIGN (LO2) I. DEVELOP A FULLY FUNCTIONAL RELATIONAL DATABASE SYSTEM,
- Validations, And Querying Across Multiple Tables (P2) 1. Develop The Database System With Evidence Of User Interface, Output And Data
- 1.1. User Interface
- 1.2. Using Query To Create Database And Table
- 1.3 Generate A Database Diagram
- Implement A Query Language Into The Relational Database System (P3)
- 2.1 Queries To Insert Data With Illustrations Of Final Result................................
- 2.2 Queries To Update Data With Illustrations Of Final Result
- 2.3. Queries To Delete Data With Illustrations Of Final Result
- 2.4. Queries To Select Data With Illustrations Of Final Result
- II. TEST THE SYSTEM AGAINST USER AND SYSTEM REQUIREMENTS (LO3)
- Test The System Against User And System Requirements (P4)
- 3.1. Definition Of system testing
- 3.2. Types of System Testing
- 3.3. Test Cases
- 3.4. Test case Expected Result
- III. PRODUCE TECHNICAL AND USER DOCUMENTATION (LO4)
- Produce Technical And User Documentation (P5)
- 4.1. Technical Documentation
- 4.2. User Documentation
- base............................................................................................................................. 4.3. The Instruction Of Installation, Attach Database And Connect To The Data-
- 4.4. The Instruction Of User System
- CONCLUSION
- REFERENCES
INTRODUCTION To begin with, I want to express my profound gratitude to my family for their unwavering support, affection, and timely assistance. It is no exaggeration to say that their encouragement is the cornerstone of my successful completion of this report. Additionally, I would like to extend my sincere appreciation to Mr. Nguyen Hoang Anh Vu for his insightful lectures and guidance, which have served as a valuable source of knowledge for me. Thirdly, I am immensely thankful to all my BTEC friends for the memorable experiences we have shared during this journey. Last but certainly not least, I want to convey my heartfelt thanks to all the authors whose extensive wisdom has been used as reference materials throughout this document. This assignment has been enriched by their contributions.
Next we will come to the personal information UI, the layout is divided into two parts. On the left will be the user's avatar, along with other functions such as information about cources, schedule, and attendance right below the avatar. On the right we have the user's personal information, by clicking on the "change Information" button they can edit the information if it is incorrect. In addition, users can log out of the system using the "log Out" button at the bottom.
And finally, the student information management interface. Only users with the Admin role can access this part of the system. With this interface design, the administrator will be able to easily view, and edit the information of all students in the school system. 1.2. Using Query To Create Database And Table Initially, it is essential to establish a database, and for the first stage, I will undertake manual creation. Once the database has been successfully created, we can proceed to employ
Create Enrollments table: Result: Create Grades table: Result:
Create Teachers table: Result: Create Classes table:
Result: Create LibraryBorrowings table: Result: Create Scores table:
Result: Create CMS table: Result:
Result: Additionally, there are several other tables; presenting all of them in this section would be overwhelming. Therefore, I will showcase only a select few tables. The following is the database generated using the query we just executed.
1.3 Generate A Database Diagram Upon establishing the foundational elements of the database and integrating tables through primary and foreign keys, along with constraints generated concurrently with the table creation, the resulting representation of the database will take the form of the following diagram
Result: Similar to the students table, I also insert 10 rows of data into the teacher table as follows: Insert data into Teachers table: Result:
In this courses table, I also add 10 lines of data about the subject as below: Insert data into Coures table: Result: Similar to other tables, the scores table will be inserted with 10 rows of data. The data is mainly id from other tables and its score. Insert data into Scores table:
