Đây là ASM về môn Database Design & Development bao gồm các lệnh trong Database, Assignments of Information Technology (Tran Thanh Dat)
A. Introduction
In this assignment I will create a attendance program using the winform application and connect to the database. It allows users to add, edit, delete student information, view information of all students. In addition, I also give the basic concept of some statements in the database like inset , update , delete , select , ....
B. Content
I. Develop the database system with evidence of user interface, output and datavalidations, and querying across multiple tables (P2)
1. ERD
Contents
A. Introduction.............................................................................................................................................................................................................5
B. Content.................................................................................................................................................................................................................... 5
I. Develop the database system with evidence of user interface, output and datavalidations, and querying across multiple tables (P2) ..............5
1. ERD...................................................................................................................................................................................................................5
2. Commands to create tables.............................................................................................................................................................................6
2.1. Create and Use database..............................................................................................................................................................................6
2.2. Create table Student.....................................................................................................................................................................................6
2.3. Create table Subjects....................................................................................................................................................................................7
2.4. Create table Teacher.....................................................................................................................................................................................8
2.5. Create table Class.......................................................................................................................................................................................... 8
2.6. Create table StudentClass.............................................................................................................................................................................9
2.7. Create table StudentSubjects........................................................................................................................................................................9
2.8. Create table TeacherClass...........................................................................................................................................................................10
3. Take pictures of the tables.............................................................................................................................................................................10
3.1. Table Students.............................................................................................................................................................................................10
3.2. Table Teacher..............................................................................................................................................................................................10
3.3. Table Subject...............................................................................................................................................................................................11
3.4. Table Class...................................................................................................................................................................................................11
3.5. Table StudentClass......................................................................................................................................................................................12
3.6. Table StudentSubjects.................................................................................................................................................................................12
3.7. Table TeacherClass......................................................................................................................................................................................13
4. Take a picture of the diagram........................................................................................................................................................................13
II. Implement a query language into the relational database system (P3) .............................................................................................................15
Document shared on https://www.docsity.com/en/day-la-asm-ve-mon-database-design-development-bao-gom-cac-lenh-trong-database/9674919/
Downloaded by: ebookbkmt-cong-djong-ky-thuat-co-dj (nguyenphihung1009@gmail.com)
1.1. Insert :.........................................................................................................................................................................................................15
1.2. Update :.......................................................................................................................................................................................................15
1.3. Delete :........................................................................................................................................................................................................16
1.4. Select :.........................................................................................................................................................................................................16
1.5. Join :............................................................................................................................................................................................................17
III. Test the system against user and system requirements. = test plans and test cases (P4).................................................................................17
1. Test Login.......................................................................................................................................................................................................18
2. Test login with wrong account and password................................................................................................................................................19
3. Show/Hide Password.....................................................................................................................................................................................20
4. Add Students..................................................................................................................................................................................................21
5. Register..........................................................................................................................................................................................................22
IV. Produce technical and user documentation (P5 + M5).....................................................................................................................................23
1. User manual..................................................................................................................................................................................................23
If you click on Teacher, the system will redirect you to the Teacher form.........................................................................................................31
........................................................................................................................................................................................................................... 31
If you click on Class, the system will take you to the class form.........................................................................................................................32
........................................................................................................................................................................................................................... 32
2. Code explanation...........................................................................................................................................................................................33
C. Conclusion..............................................................................................................................................................................................................45
D. Refrence.
LINK 3 - TÌM KIẾM SÁCH/TÀI LIỆU ONLINE (GIÁ ƯU ĐÃI NHẤT)
LINK 4 - TÌM KIẾM SÁCH/TÀI LIỆU ONLINE (GIÁ ƯU ĐÃI NHẤT)
A. Introduction
In this assignment I will create a attendance program using the winform application and connect to the database. It allows users to add, edit, delete student information, view information of all students. In addition, I also give the basic concept of some statements in the database like inset , update , delete , select , ....
B. Content
I. Develop the database system with evidence of user interface, output and datavalidations, and querying across multiple tables (P2)
1. ERD
Contents
A. Introduction.............................................................................................................................................................................................................5
B. Content.................................................................................................................................................................................................................... 5
I. Develop the database system with evidence of user interface, output and datavalidations, and querying across multiple tables (P2) ..............5
1. ERD...................................................................................................................................................................................................................5
2. Commands to create tables.............................................................................................................................................................................6
2.1. Create and Use database..............................................................................................................................................................................6
2.2. Create table Student.....................................................................................................................................................................................6
2.3. Create table Subjects....................................................................................................................................................................................7
2.4. Create table Teacher.....................................................................................................................................................................................8
2.5. Create table Class.......................................................................................................................................................................................... 8
2.6. Create table StudentClass.............................................................................................................................................................................9
2.7. Create table StudentSubjects........................................................................................................................................................................9
2.8. Create table TeacherClass...........................................................................................................................................................................10
3. Take pictures of the tables.............................................................................................................................................................................10
3.1. Table Students.............................................................................................................................................................................................10
3.2. Table Teacher..............................................................................................................................................................................................10
3.3. Table Subject...............................................................................................................................................................................................11
3.4. Table Class...................................................................................................................................................................................................11
3.5. Table StudentClass......................................................................................................................................................................................12
3.6. Table StudentSubjects.................................................................................................................................................................................12
3.7. Table TeacherClass......................................................................................................................................................................................13
4. Take a picture of the diagram........................................................................................................................................................................13
II. Implement a query language into the relational database system (P3) .............................................................................................................15
Document shared on https://www.docsity.com/en/day-la-asm-ve-mon-database-design-development-bao-gom-cac-lenh-trong-database/9674919/
Downloaded by: ebookbkmt-cong-djong-ky-thuat-co-dj (nguyenphihung1009@gmail.com)
1.1. Insert :.........................................................................................................................................................................................................15
1.2. Update :.......................................................................................................................................................................................................15
1.3. Delete :........................................................................................................................................................................................................16
1.4. Select :.........................................................................................................................................................................................................16
1.5. Join :............................................................................................................................................................................................................17
III. Test the system against user and system requirements. = test plans and test cases (P4).................................................................................17
1. Test Login.......................................................................................................................................................................................................18
2. Test login with wrong account and password................................................................................................................................................19
3. Show/Hide Password.....................................................................................................................................................................................20
4. Add Students..................................................................................................................................................................................................21
5. Register..........................................................................................................................................................................................................22
IV. Produce technical and user documentation (P5 + M5).....................................................................................................................................23
1. User manual..................................................................................................................................................................................................23
If you click on Teacher, the system will redirect you to the Teacher form.........................................................................................................31
........................................................................................................................................................................................................................... 31
If you click on Class, the system will take you to the class form.........................................................................................................................32
........................................................................................................................................................................................................................... 32
2. Code explanation...........................................................................................................................................................................................33
C. Conclusion..............................................................................................................................................................................................................45
D. Refrence.
LINK 3 - TÌM KIẾM SÁCH/TÀI LIỆU ONLINE (GIÁ ƯU ĐÃI NHẤT)
LINK 4 - TÌM KIẾM SÁCH/TÀI LIỆU ONLINE (GIÁ ƯU ĐÃI NHẤT)
Không có nhận xét nào: