Download SQL Database Creation and Management: A Student's Grading Document and more Study Guides, Projects, Research 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 10/03/20 22 Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Phan Nhat Linh Student ID GCD Class GCD0905 Assessor name Do Duy Thao 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 Linh Grading grid
P2 P3 P4 P5 M2 M3 M4 M5 D2 D
Table of Contents
- ASSIGNMENT
- CHAPTER I: DEVELOP THE DATABASE SYSTEM
- Final Mock-up of the application
- Queries to create database and table with result
- 2.1 Database
- 2.2 Tables
- 2.3 The tables have been created based on the design
- CHAPTER II: PRODUCE QUERIES
- Queries to INSERT data with illustrations of final result
- Queries to UPDATE data with illustrations of final result
- Queries to DELETE data with illustrations of final result
- Queries to SELECT data with illustrations of final result
- Advanced Statistics Actions
- CHAPTER III: TEST THE SYSTEM
- TEST PLAN......................................................................................................................................................................................
- TEST RESULT
- CHAPTER IV: DOCUMENTATION FOR TECHNICAL AND USER APPLICATIONS
- User requirements
- Entity Relationship Diagram (ERD) of Football management
- Data validation
- 3.1 Data type
- 3.2 Presence
- User document
- References
- Figure 1: Home interface of the system Table of Figures
- Figure 2: The create interface of the system
- Figure 3: Create new footballer (example of create function)
- Figure 4: The view interface of the system
- Figure 5: View stadium (example of view function)
- Figure 6: The update interface of the system
- Figure 7: Update stadium information (example of update function)
- Figure 8: Top goal score in statistic function............................................................................................................................................
- Figure 9: Create database FootballManagement.......................................................................................................................................
- Figure 10: Database FootballManagement
- Figure 11: Create Coach table...................................................................................................................................................................
- Figure 12: The result of creating Coach table
- Figure 13: Create Tournament table
- Figure 14: The result of creating Tournament table
- Figure 15: Create Stadium table
- Figure 16: The result of creating Stadium table........................................................................................................................................
- Figure 17: Create Team table
- Figure 18: The result creating Team table
- Figure 19: Create Footballer table
- Figure 20: The result of creating Footballer table
- Figure 21: Create Enrollment table
- Figure 22: The result of creating Enrollment table
- Figure 23: Create Contract table
- Figure 24:The result of creating Contract table
- Figure 25:The tables have been created based on the design
- Figure 26: Entity Relationship Diagram (ERD) of Football management
- Figure 27: Example of INT data type
- Figure 28: Example of NVARCHAR data type
- Figure 29: Example of DATE data type
- Figure 30: Example of CONSTRAINT
- Figure 31: Example of NOT NULL..........................................................................................................................................................
- Figure 32: Example of IDENTITY
- Figure 33: User doc
- Figure 34: : User doc 2..............................................................................................................................................................................
- Figure 35: User doc
- Figure 36: User doc
- Figure 37: User doc
- Figure 38: User doc
- Figure 39: User doc
- Figure 40: User doc
Figure 1 : Home interface of the system
➢ Function to create new objects when clicking the CREATE button. User can create new player, coach, team, league and stadium information Figure 2 : The create interface of the system
➢ When the user hits the View button, the user is presented with the following interface. Users may read information on footballers, coaches, stadiums, tournaments, and clubs by clicking on the appropriate item. Figure 4 : The view interface of the system
➢ When the user selects View Stadium information, the interface will appear as follows. Users search for information via Stadium_ID, helping users search quickly and accurately. Figure 5 : View stadium (example of view function)
➢ Management can search the stadium by its ID, different from viewing the stadium information, now they can update the information of that stadium. Figure 7 : Update stadium information (example of update function)
➢ When the user hits the Statistic button, the user is presented with the following interface. The user will see the information of the top scorers. Figure 8 : Top goal score in statistic function
column2 datatype, column3 datatype, .... ); The column parameters specify the names of the columns of the table. The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.). a. Coach table ➢ Create Figure 11 : Create Coach table
➢ Result Figure 12 : The result of creating Coach table b. Tournament table ➢ Create Figure 13 : Create Tournament table
