Đâ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 DOWNLOAD (TÀI LIỆU VIP MEMBER)



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 DOWNLOAD (TÀI LIỆU VIP MEMBER)

M_tả
M_tả

Không có nhận xét nào: