Building Two Desktop Applications Using Python GUI and MySQL
Building Two Desktop Applications Using Python GUI and MySQL

Author: Vivian Siahaan

Publisher: SPARTA PUBLISHING

Published: 2019-11-07

Total Pages: 541

ISBN-13:

DOWNLOAD EBOOK

In this book, you will create two desktop applications using Python GUI and MySQL. In this book, you will learn how to build from scratch a MySQL database management system using PyQt. In designing a GUI, you will make use of the Qt Designer tool. Gradually and step by step, you will be taught how to use MySQL in Python. In the first three chapters, you will learn Basic MySQL statements including how to implement querying data, sorting data, filtering data, joining tables, grouping data, subquerying data, dan setting operators. Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters. In the fourth chapter, you will learn: How PyQt and Qt Designer are used to create Python GUIs; How to create a basic Python GUI that utilizes a Line Edit and a Push Button. In the fifth chapter, you will study: Creating the initial three table in the School database project: Teacher table, Class table, and Subject table; Creating database configuration files; Creating a Python GUI for viewing and navigating the contents of each table. Creating a Python GUI for inserting and editing tables; and Creating a Python GUI to merge and query the three tables. In chapter six, you will learn: Creating the main form to connect all forms; Creating a project that will add three more tables to the school database: the Student table, the Parent table, and the Tuition table; Creating a Python GUI to view and navigate the contents of each table; Creating a Python GUI for editing, inserting, and deleting records in each table; Create a Python GUI to merge and query the three tables and all six tables. In chapter seven, you will create new database dan configure it. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table. In chapter nine, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In chapter ten, you will create two tables, Victim and Case_File. The Vicbtim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

BUILDING TWO DESKTOP APPLICATIONS USING PYTHON GUI AND POSTGRESQL
BUILDING TWO DESKTOP APPLICATIONS USING PYTHON GUI AND POSTGRESQL

Author: Vivian Siahaan

Publisher: SPARTA PUBLISHING

Published: 2019-11-07

Total Pages: 537

ISBN-13:

DOWNLOAD EBOOK

In this book, you will create two desktop applications using Python GUI and PostgreSQL. This book is a Python/PostgreSQL version of the Python/MySQL book which was written by the author. What underlies the writing of this book is the growing popularity of the PostgreSQL database server lately and more and more programmers migrating from MySQL to PostgreSQL. In this book, you will learn to build a school database project, step by step. A number of widgets from PyQt will be used for the user interface. In the first and second chapter, you will get introduction of postgresql. And then, you will learn querying data from the postgresql using Python including establishing a database connection, creating a statement object, executing the query, processing the resultset object, querying data using a statement that returns multiple rows, querying data using a statement that has parameters, inserting data into a table using Python, updating data in postgresql database using Python, calling postgresql stored function using Python, deleting data from a postgresql table using Python, and postgresql Python transaction. In the fourth chapter, you will study: Creating the initial three table in the School database project: Teacher table, Class table, and Subject table; Creating database configuration files; Creating a Python GUI for viewing and navigating the contents of each table. Creating a Python GUI for inserting and editing tables; and Creating a Python GUI to merge and query the three tables. In chapter five, you will learn: Creating the main form to connect all forms; Creating a project that will add three more tables to the school database: the Student table, the Parent table, and the Tuition table; Creating a Python GUI to view and navigate the contents of each table; Creating a Python GUI for editing, inserting, and deleting records in each table; Create a Python GUI to merge and query the three tables and all six tables. In chapter six, you will create dan configure PotgreSQL database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In chapter nine, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

A Guide to Python GUI Programming with MySQL
A Guide to Python GUI Programming with MySQL

Author: Vivian Siahaan

Publisher: SPARTA PUBLISHING

Published: 2020-01-14

Total Pages: 541

ISBN-13:

DOWNLOAD EBOOK

In this book, you will create two desktop applications using Python GUI and MySQL. In this book, you will learn how to build from scratch a MySQL database management system using PyQt. In designing a GUI, you will make use of the Qt Designer tool. Gradually and step by step, you will be taught how to use MySQL in Python. In the first three chapters, you will learn Basic MySQL statements including how to implement querying data, sorting data, filtering data, joining tables, grouping data, subquerying data, dan setting operators. Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters. In the fourth chapter, you will learn: How PyQt and Qt Designer are used to create Python GUIs; How to create a basic Python GUI that utilizes a Line Edit and a Push Button. In the fifth chapter, you will study: Creating the initial three table in the School database project: Teacher table, Class table, and Subject table; Creating database configuration files; Creating a Python GUI for viewing and navigating the contents of each table. Creating a Python GUI for inserting and editing tables; and Creating a Python GUI to merge and query the three tables. In chapter six, you will learn: Creating the main form to connect all forms; Creating a project that will add three more tables to the school database: the Student table, the Parent table, and the Tuition table; Creating a Python GUI to view and navigate the contents of each table; Creating a Python GUI for editing, inserting, and deleting records in each table; Create a Python GUI to merge and query the three tables and all six tables. In chapter seven, you will create new database dan configure it. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table. In chapter nine, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In chapter ten, you will create two tables, Victim and Case_File. The Vicbtim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL
A PROGRESSIVE TUTORIAL TO DATABASE PROGRAMMING WITH PYTHON GUI AND POSTGRESQL

Author: Vivian Siahaan

Publisher: SPARTA PUBLISHING

Published: 2020-01-03

Total Pages: 537

ISBN-13:

DOWNLOAD EBOOK

In this book, you will create two desktop applications using Python GUI and PostgreSQL. This book is a Python/PostgreSQL version of the Python/MySQL book which was written by the author. What underlies the writing of this book is the growing popularity of the PostgreSQL database server lately and more and more programmers migrating from MySQL to PostgreSQL. In this book, you will learn to build a school database project, step by step. A number of widgets from PyQt will be used for the user interface. In the first and second chapter, you will get introduction of postgresql. And then, you will learn querying data from the postgresql using Python including establishing a database connection, creating a statement object, executing the query, processing the resultset object, querying data using a statement that returns multiple rows, querying data using a statement that has parameters, inserting data into a table using Python, updating data in postgresql database using Python, calling postgresql stored function using Python, deleting data from a postgresql table using Python, and postgresql Python transaction. In the fourth chapter, you will study: Creating the initial three table in the School database project: Teacher table, Class table, and Subject table; Creating database configuration files; Creating a Python GUI for viewing and navigating the contents of each table. Creating a Python GUI for inserting and editing tables; and Creating a Python GUI to merge and query the three tables. In chapter five, you will learn: Creating the main form to connect all forms; Creating a project that will add three more tables to the school database: the Student table, the Parent table, and the Tuition table; Creating a Python GUI to view and navigate the contents of each table; Creating a Python GUI for editing, inserting, and deleting records in each table; Create a Python GUI to merge and query the three tables and all six tables. In chapter six, you will create dan configure PotgreSQL database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In chapter nine, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

Step By Step Database Programming using Python GUI & MySQL
Step By Step Database Programming using Python GUI & MySQL

Author: Hamzan Wadi

Publisher: TURIDA Publisher

Published:

Total Pages: 384

ISBN-13:

DOWNLOAD EBOOK

This book provides a practical explanation of database programming using Python GUI & MySQL. The discussion in this book is presented in step by step so that it will help readers understand each material and also will make it easier for the readers to follow all of the instructions. This book is very suitable for students, programmers, and anyone who want to learn database programming using Python GUI & MySQL from scratch. This book is divided into two parts: The first part of this book will discuss about the fundamentals of database programming using Python GUI & MySQL. This part will discuss in detail about how to setup your working environment and how to understand GUI programming using Python. This part will also discuss in detail about how to start your database programming using Python GUI & MySQL. This part will discuss in detail about the basic of database programming using Python GUI & MySQL. The second part of this book will discuss about how to build database application using Python GUI & MySQL. This part will discuss in detail about how to build Multiple Document Interface (MDI) database application through real project-based example. This part will discuss in detail about how to design and create database for Library Management System application, and how to create all forms for the application. The final objective of this book is that the readers are able to create real database application using Python GUI & MySQL. Here are the materials that you will learn in this book. PART I: THE FUNDAMENTAL OF DATABASE PROGRAMMING USING PYTHON GUI & MySQL CHAPTER 1: The discussion in this chapter will guide you in preparing what software are needed to start your database programming using Python GUI. This chapter will guide you to install all software including Python, MySQL, and Qt Designer. In addition, this chapter also will discuss about how to understand and use Qt Designer for user interface design, and how to create a GUI application using Python and Qt Designer. CHAPTER 2: The discussion in this chapter will guide you to start your database programming using Python GUI & MySQL. This chapter will discuss in detail about the basic of database programming using Python GUI & MySQL. The discussion in this chapter will talk about how to create and drop database, how to create and drop table, how to insert data into table, how to display data from table, how to update data in table, and how to delete data in table. All discussions in this chapter will give you deep understanding of database programming using Python GUI & MySQL. PART II: BUILDING DATABASE APPLICATION USING PYTHON GUI & MySQL, CASE STUDY: LIBRARY MANAGEMENT SYSTEM APPLICATION CHAPTER 3: The discussion in this chapter will guide you to design and create database for library management system application. This is the first step that must be taken to create database application using Python GUI & MySQL. This chapter will discuss in detail about how to design the Entity Relationship Diagram (ERD) for library management system application. The discussion in this chapter will also talk about how to create database and its tables based on the ERD design using MySQL server. CHAPTER 4: The discussion in this chapter will guide you to create main form and login form for the application. This chapter will discuss in detail about how to create these two forms. These forms are the first two forms that we will create in building library management system application. This chapter will also discuss about how to run the application. CHAPTER 5: The discussion in this chapter will guide you to create user accounts form and members form for Library Management System application. This chapter will discuss in detail about how to create these two forms. This chapter will also discuss about how to add these two forms as MDI sub windows of the main form. And the final discussion of this chapter will guide you to use the forms to manage user accounts and members data of Library Management System application. CHAPTER 6: The discussion in this chapter will guide you to create authors form, genres form, and books form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add books form as MDI sub window of the main form. And the final discussion of this chapter will guide you to use the forms to manage authors, genres, and books data in Library Management System application. CHAPTER 7: The discussion in this chapter will guide you to create member search form, book search form, and loan transaction form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add loan transaction form as MDI sub window of the main form. And the final discussion of this chapter will guide you to use the forms to manage loan transactions in Library Management System application. CHAPTER 8: The discussion in this chapter will guide you to create members statistic form, books statistic form, and loan statistic form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add all of the forms as MDI sub windows of the main form. And the final discussion of this chapter will guide you to use all of the forms to display the statistics in the library.

Step By Step Java GUI With JDBC & MySQL : Practical approach to build database desktop application with project based examples
Step By Step Java GUI With JDBC & MySQL : Practical approach to build database desktop application with project based examples

Author: Hamzan Wadi

Publisher: TR Publisher

Published:

Total Pages: 340

ISBN-13:

DOWNLOAD EBOOK

This book comes as an answer for students, lecturers, or the general public who want to learn Java GUI programming starting from scratch. This book is suitable for beginner learners who want to learn Java GUI programming from the basic to the database level. This book is also present for JAVA learners who want to increase their level of making GUI-based database applications for small, medium, or corporate businesses level. The discussion in this book is not wordy and not theoretical. Each discussion in this book is presented in a concise and clear brief, and directly to the example that implements the discussion. Beginner learners who want to learn through this book should not be afraid of losing understanding of the programming concepts, because this book in detail discusses the concepts of Java programming from the basic to the advanced level. By applying the concept of learning by doing, this book will guide you step by step to start Java GUI programming from the basics until you are able to create database applications using JDBC and MySQL. Here are the material that you will learn in this book. CHAPTER 1 : This chapter will give you brief and clear introduction about how to create desktop application using Java GUI starting from how to setup your environments, create your first project, understand various control for your form, and understand how to interact with your form using event handling. CHAPTER 2 : This chapter will discuss clearly about the concept and the implementatiton of data types and variables in Java GUI. CHAPTER 3 : This chapter will discuss in detail about how to make decisions or deal with a condition in the program. This chapter is the first step to deeper understanding of logics in programming. This chapter specifically discusses relational operators and logical operators, if statements, if-else statements, and switch-case statements, and how to implement all of these conditional statements using Java GUI. CHAPTER 4 : This chapter will discuss in detail the looping statements in Java including for statement, while statement, do-while statement, break statement, and continue statement. All of these looping statements will be implemented using Java GUI. CHAPTER 5 : This chapter will discuss how to use methods to group codes based on their funcitonality. This discussion will also be the first step for programmers to learn how to create efficient program code. This chapter will discuss in detail the basics of methods, methods with return values, how to pass parameters to methods, how to overload your methods, and how to make recursive methods. CHAPTER 6 : This chapter will discuss in detail how to create and use arrays, read and write file operations, and how to display data stored in arrays or files in graphical form. CHAPTER 7 : This chapter will discuss in detail the basics of MySQL, how to access databases using JDBC and MySQL, and how to perform CRUD operations using JDBC and MySQL. CHAPTER 8 : In this chapter we will discuss more about Java GUI programming. This chapter will discuss in detail about how to make a program that consists of multi forms, how to create MDI application, and how to create report using iReport with data stored in a database.

Python GUI with SQL Server for Absolute Beginners
Python GUI with SQL Server for Absolute Beginners

Author: Vivian Siahaan

Publisher: SPARTA PUBLISHING

Published: 2019-09-20

Total Pages: 373

ISBN-13:

DOWNLOAD EBOOK

This book is SQL Server-based python programming. Microsoft SQL Server is robust relational database management system used by so many organizations of various sizes including top fortune 100 companies. SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft. As a database server, the primary function of the SQL Server is to store and retrieve data used by other applications. Deliberately designed for various levels of programming skill, this book is suitable for students, engineers, and even researchers in various disciplines. There is no need for advanced programming experience, and school-level programming skills are needed. In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In third chapter, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In fourth chapter, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In the last chapter, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables.

A Practical Guide to Decision Support System With Analytic Hierarchy Process Method Using Python GUI & MySQL, Case Study: Determining Scholarship Recipients
A Practical Guide to Decision Support System With Analytic Hierarchy Process Method Using Python GUI & MySQL, Case Study: Determining Scholarship Recipients

Author: Hamzan Wadi

Publisher: Turida Publisher

Published: 2023-04-26

Total Pages: 246

ISBN-13:

DOWNLOAD EBOOK

This book provides a practical explanation of the Analytic Hierarchy Process (AHP) method and its implementation in a decision support system to determine the scholarship recipients in a university. The discussion in this book is presented step-by-step, gradually, so that it will help readers understand every concept and stage of the AHP method and its implementation in decision support systems. This book is suitable for students, scholars, and researchers who want to implement the AHP method to build decision support systems using Python GUI and MySQL. The discussion in this book will provide readers with an understanding of the AHP method and how it works. Readers will be guided through each step of determining priority order using the AHP method through a case study accompanied by mathematical calculations. In addition, readers will also be guided step-by-step in implementing the AHP method in a decision support system to determine the scholarship recipients using Python GUI and MySQL. Readers will be guided step-by-step in designing a decision support system and realizing each design made using Python GUI and MySQL. The ultimate goal of this book is to enable readers to build a decision support system application independently by applying the AHP method to determine the scholarship recipients in a college using Python GUI and MySQL.

Artificial Intelligence of Things
Artificial Intelligence of Things

Author: Rama Krishna Challa

Publisher: Springer Nature

Published: 2023-12-02

Total Pages: 402

ISBN-13: 3031487745

DOWNLOAD EBOOK

These two volumes constitute the revised selected papers of First International Conference, ICAIoT 2023, held in Chandigarh, India, during March 30–31, 2023. The 47 full papers and the 10 short papers included in this volume were carefully reviewed and selected from 401 submissions. The two books focus on research issues, opportunities and challenges of AI and IoT applications. They present the most recent innovations, trends, and concerns as well as practical challenges encountered and solutions adopted in the fields of AI algorithms implementation in IoT Systems

OpenCV-Python with MySQL for Absolute Beginners
OpenCV-Python with MySQL for Absolute Beginners

Author: Vivian Siahaan

Publisher: SPARTA PUBLISHING

Published: 2019-09-14

Total Pages: 423

ISBN-13:

DOWNLOAD EBOOK

This book consists of a series of step-by-step tutorials for creating mini projects in integrating pyqt, python, opencv, and mysql database. By studying this book, you will understand how to program python GUIs involving opencv and databases in applications. This book is suitable for beginners, students, engineers, and even researchers in a variety of disciplines. No advanced programming experience is needed, and only a few school-level programming skills are needed. In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In chapter three, you will learn Basic MySQL statements including how to implement querying data, sorting data, filtering data, joining tables, grouping data, subquerying data, dan setting operators. Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters. Chapter four will help you get started with MySQL Python connector. You will learn about the MySQL Python connector’s features and how to install MySQL Connector/Python in your local system. Chapter five will help you understand the basics of MySQL data manipulation. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In chapter eight, you will create two tables, Victim and Case_File. The Vicbtim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.