Computer Programming Python Sql Php C

DOWNLOAD
Download Computer Programming Python Sql Php C PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Computer Programming Python Sql Php C book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages. If the content not found or just blank you must refresh this page
Computer Programming Python Sql Php C
DOWNLOAD
Author : Computer Programming Academy Us
language : en
Publisher:
Release Date : 2020-05-04
Computer Programming Python Sql Php C written by Computer Programming Academy Us and has been published by this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020-05-04 with categories.
✵55% SPECIAL DISCOUNT FOR BOOKSTORE! NOW AT 49.99$ INSTEAD OF 59.99$ ✵No matter what kind of coding or programming your customers are interested in or how new they are to the space, this book will get them from zero to hero!Look no further! These are all the computer programming learning materials you need to know. All you need to learn about the fundamentals of 4 of the most popular programming languages are here, all in 1! Computer Programming Academy is offering you this 4 in 1 (Python, Structured Query Language (SQL), PHP and C++) bundle. Today computer programs are being used in almost every field. Using programming, you can create your own games, your personal blog/profile page, a social networking site like Facebook, a search engine like Google or an e-commerce platform like Amazon. The backbones of today's technology companies like Google, Facebook, Microsoft, Apple, Amazon, and many others, are giant computer programs written by a collaboration of thousands of skilled programmers. Not only have companies and non-profits introduced initiatives to get a more diverse range of people into programming, but the number of resources available to learn to code has dramatically increased. It obviously helps to have a college degree, but it isn't necessary when learning to program. Computer programming is definitely a skill to earn a higher salary. In this bundle, you'd learn the fundamentals of 4 of the most popular programming languages at the moment in this world: Python Structured Query Language (SQL) PHP C++ You may already have used software, perhaps for word processing or spreadsheets to solve problems. Perhaps now you are curious to learn how programmers write software. Let learning some of the most popular computer programming languages to become your advantage and push your career to the next level! Hit that BUY NOW button and let yourself display this book in pride!
Computer Programming Academy
DOWNLOAD
Author : Computer Programming Academy
language : en
Publisher:
Release Date : 2020-05-04
Computer Programming Academy written by Computer Programming Academy and has been published by this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020-05-04 with categories.
Look no further! These are all the computer programming learning materials you need to know. All you need to learn about the fundamentals of 4 of the most popular programming languages are here, all in 1! Computer Programming Academy is offering you this 4 in 1 (Python, Structured Query Language (SQL), PHP and C++) bundle. Today computer programs are being used in almost every field. Using programming, you can create your own games, your personal blog/profile page, a social networking site like Facebook, a search engine like Google or an e-commerce platform like Amazon. The backbones of today's technology companies like Google, Facebook, Microsoft, Apple, Amazon, and many others, are giant computer programs written by a collaboration of thousands of skilled programmers. Not only have companies and non-profits introduced initiatives to get a more diverse range of people into programming, but the number of resources available to learn to code has dramatically increased. It obviously helps to have a college degree, but it isn't necessary when learning to program. Computer programming is definitely a skill to earn a higher salary. In this bundle, you'd learn the fundamentals of 4 of the most popular programming languages at the moment in this world: Python Structured Query Language (SQL) PHP C++ You may already have used software, perhaps for word processing or spreadsheets to solve problems. Perhaps now you are curious to learn how programmers write software. Let learning some of the most popular computer programming languages to become your advantage and push your career to the next level! WHAT ARE YOU WAITING FOR? A FEW DOLLARS SPENT ARE THE VALUE OF YOUR SKILL IMPROVEMENT? It's definitely possible to learn computer programming on your own. To learn it steps by steps by pressing the BUY NOW BUTTOM!
Computer Programming
DOWNLOAD
Author : Computer Programming Academy
language : en
Publisher:
Release Date : 2020
Computer Programming written by Computer Programming Academy and has been published by this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020 with Computer programming categories.
Computer Programming
DOWNLOAD
Author : Computer Programming Academy
language : en
Publisher:
Release Date : 2020-05-04
Computer Programming written by Computer Programming Academy and has been published by this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020-05-04 with categories.
Look no further! These are all the computer programming learning materials you need to know. All you need to learn about the fundamentals of 4 of the most popular programming languages are here, all in 1! Computer Programming Academy is offering you this 4 in 1 (Python, Structured Query Language (SQL), PHP and C++) bundle. Today computer programs are being used in almost every field. Using programming, you can create your own games, your personal blog/profile page, a social networking site like Facebook, a search engine like Google or an e-commerce platform like Amazon. The backbones of today's technology companies like Google, Facebook, Microsoft, Apple, Amazon, and many others, are giant computer programs written by a collaboration of thousands of skilled programmers. Not only have companies and non-profits introduced initiatives to get a more diverse range of people into programming, but the number of resources available to learn to code has dramatically increased. It obviously helps to have a college degree, but it isn't necessary when learning to program. Computer programming is definitely a skill to earn a higher salary. In this bundle, you'd learn the fundamentals of 4 of the most popular programming languages at the moment in this world: Python Structured Query Language (SQL) PHP C++ You may already have used software, perhaps for word processing or spreadsheets to solve problems. Perhaps now you are curious to learn how programmers write software. Let learning some of the most popular computer programming languages to become your advantage and push your career to the next level! WHAT ARE YOU WAITING FOR? A FEW DOLLARS SPENT ARE THE VALUE OF YOUR SKILL IMPROVEMENT? It's definitely possible to learn computer programming on your own. To learn it steps by steps by pressing the BUY NOW BUTTOM!
Mariadb With Python Gui
DOWNLOAD
Author : Vivian Siahaan
language : en
Publisher: SPARTA PUBLISHING
Release Date : 2019-08-17
Mariadb With Python Gui written by Vivian Siahaan and has been published by SPARTA PUBLISHING this book supported file pdf, txt, epub, kindle and other format this book has been release on 2019-08-17 with Computers categories.
This is a computer programming book using Python that is focused on effective learning. Intentionally designed for various levels of interest and ability of learners, this book is suitable for students, engineers, and even researchers in a variety of disciplines. No advanced programming experience is needed, and only a few school-level programming skill are needed. The step-by-step guide in this book is expected to help the reader's confidence to become a programmer who can solve database programming problems. A progressive project is provided to demonstrate how to apply the concepts of MariaDB using Python. In second chapter, you will learn PyQt that consists of a number of Python bindings for cross-platform applications that combine all the strengths of Qt and Python. By using PyQt, you can include all Qt libraries in Python code, so you can write GUI applications in Python. In other words, you can use PyQt to access all the features provided by Qt through Python code. Because PyQt depends on the Qt libraries at run time, you need to install PyQt. 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.
Database Management System Using Visual C Net Mysql Sql Server And Access
DOWNLOAD
Author : Vivian Siahaan
language : en
Publisher: BALIGE PUBLISHING
Release Date : 2020-09-14
Database Management System Using Visual C Net Mysql Sql Server And Access written by Vivian Siahaan and has been published by BALIGE PUBLISHING this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020-09-14 with Computers categories.
Book 1: VISUAL C# .NET WITH MYSQL: A Definitive Guide to Develop Database-Oriented Desktop Applications In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be more familiar when applying them to some applications in this book. In chapter two, you will go through step by step to build a SALES database using MySQL. You will build each table and add associated data fields (along with the necessary keys and indexes). The first field in the Client table is ClientID. Enter the clien ID in the Name Field and select AutoNumber in the Data Type. You define primary key and other indexes which are useful for quick searching. ClientID is a primary field. You will define FamilyName as an index. You then will create Ordering table with three fields: OrderID, ClientID, and OrderDate. You then will create Purchase table with three fields: OrderID, ProductID, and Quantity. And you will create Product table with four fields: ProductID, Description, Price, and QtySold. Before designing Visual C# interface, you will build the relationships between four tables. The interface will be used to enter new orders into the database. The order form will be used to enter the following information into the database: order ID, order date, client ID, client’s first name and family name, client’s address, product information ordered. The form will have the ability to add new orders, find clients, add new clients. The completed order invoice will be provided in a printed report. In chapter three, you will build a database management system where you can store information about valuables in your warehouse. The table will have seven fields: Item (description of the item), Location (where the item was placed), Shop (where the item was purchased), DatePurchased (when the item was purchased), Cost (how much the item cost), SerialNumber (serial number of the item), PhotoFile (path of the photo file of the item), and Fragile (indicates whether a particular item is fragile or not). The development of this Warehouse Inventory Project will be performed, as usual, in a step-by-step manner. You will first create the database. Furthermore, the interface will be built so that the user can view, edit, add, or add data records from the database. Finally, you add code to create a printable list of information from the database. In chapter four, you will build an application that can be used to track daily high and low pollutant PM2.5 and air quality level. The steps that need to be taken in building Siantar Air Quality Index (SAQI) database project are: Build and test a Visual C# interface; Create an empty database using code; and Report database. The designed interface will allow the user to enter max pollutant, min pollutant, and air quality for any date that the user chooses in a particular year. This information will be stored in a database. Graphical result of the data will be provided, along with summary information relating to the maximum value, minimum value, and mean value. You will use a tab control as the main component of the interface. The control has three tabs: one for viewing and editing data, one for viewing graph of pollutant data, and another for viewing graph of air quality data. Each tab on this control operates like a Visual C# control panel. In chapter five, you will perform the steps necessary to build a MySQL book inventory database that contains 4 tables. You will build each table and add the associated fields as needed. You will have four tables in the database and define the relationship between the primary key and foreign key. You will associate AuthorID (foreign key) field in the Title_Author table with AuthorID (primary key) in the Author table. Then, you want to associate the ISBN (foreign key) field in Title_Author table with ISBN (primary key) in the Title table. Book 2: Visual C# .NET For Programmers: A Progressive Tutorial to Develop Desktop Applications In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be more familiar when applying them to some applications in this book. In chapter two, you will go through step by step to build a SALES database using Microsoft Access and SQL Server. You will build each table and add associated data fields (along with the necessary keys and indexes). The first field in the Client table is ClientID. Enter the clien ID in the Name Field and select AutoNumber in the Data Type. You define primary key and other indexes which are useful for quick searching. ClientID is a primary field. If the small lock symbol is not displayed next to the ClientID row, then you need to place it there. Right click on ClientID row and select Primary Key. A small key is now displayed next to the entry indicating it is the primary key. You will define FamilyName as an index. Select the FamilyName line. On the General tab, set the Indexed property to Yes (Duplicates OK). You then will create Ordering table with three fields: OrderID, ClientID, and OrderDate. You then will create Purchase table with three fields: OrderID, ProductID, and Quantity. And you will create Product table with four fields: ProductID, Description, Price, and QtySold. Before designing Visual C# interface, you will build the relationships between four tables. In chapter three, you will build a Visual C# interface for the database. The interface will be used to enter new orders into the database. The order form will be used to enter the following information into the database: order ID, order date, client ID, client’s first name and family name, client’s address, product information ordered. The form will have the ability to add new orders, find clients, add new clients. The completed order invoice will be provided in a printed report. In chapter four, you will build a database management system where you can store information about valuables in your warehouse. The table will have seven fields: Item (description of the item), Location (where the item was placed), Shop (where the item was purchased), DatePurchased (when the item was purchased), Cost (how much the item cost), SerialNumber (serial number of the item), PhotoFile (path of the photo file of the item), and Fragile (indicates whether a particular item is fragile or not). The development of this Warehouse Inventory Project will be performed, as usual, in a step-by-step manner. You will first create the database. Furthermore, the interface will be built so that the user can view, edit, add, or add data records from the database. Finally, you add code to create a printable list of information from the database. In chapter five, you will build an application that can be used to track daily high and low pollutant PM2.5 and air quality level. You will do this in stages, from database development to creation of distribution packages. These steps are the same as those used in developing a commercial database application. The steps that need to be taken in building Siantar Air Quality Index (SAQI) database project are: Build and test a Visual C# interface; Create an empty database using code; and Report database. The designed interface will allow the user to enter max pollutant, min pollutant, and air quality for any date that the user chooses in a particular year. This information will be stored in a database. Graphical result of the data will be provided, along with summary information relating to the maximum value, minimum value, and mean value. You will use a tab control as the main component of the interface. The control has three tabs: one for viewing and editing data, one for viewing graph of pollutant data, and another for viewing graph of air quality data. Each tab on this control operates like a Visual C# control panel. In chapter six, you will perform the steps necessary to build a SQL Server book inventory database that contains 4 tables using Microsoft Visual Studio 2019. You will build each table and add the associated fields as needed. You will have four tables in the database and define the relationship between the primary key and foreign key. You will associate AuthorID (foreign key) field in the Title_Author table with AuthorID (primary key) in the Author table. Then, you want to associate the ISBN (foreign key) field in Title_Author table with ISBN (primary key) in the Title table.
Step By Step Database Programming With Jdbc And Postgresql
DOWNLOAD
Author : Vivian Siahaan
language : en
Publisher: SPARTA Publishing
Release Date : 2019-04-08
Step By Step Database Programming With Jdbc And Postgresql written by Vivian Siahaan and has been published by SPARTA Publishing this book supported file pdf, txt, epub, kindle and other format this book has been release on 2019-04-08 with Computers categories.
PostgreSQL was designed to run on UNIX-like platforms. However, PostgreSQL was then also designed to be portable so that it could run on various platforms such as Mac OS X, Solaris, and Windows. PostgreSQL is free and open source software. Its source code is available under PostgreSQL license, a liberal open source license. You are free to use, modify and distribute PostgreSQL in any form. PostgreSQL requires very minimum maintained efforts because of its stability. Therefore, if you develop applications based on PostgreSQL, the total cost of ownership is low in comparison with other database management systems. In Chapter 2, you will learn querying data from the postgresql using jdbc 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 jdbc, updating data in postgresql database using jdbc, calling postgresql stored function using jdbc, deleting data from a postgresql table using jdbc, and postgresql jdbc transaction. In Chapter 3, you will learn managing table structure and views including postgresql data types, postgresql create table, postgresql select into statement, postgresql create table as, using postgresql serial to create auto-increment column, identity column, alter table, drop table, truncate table, check constraint, not-null constraint, foreign key, primary key, unique constraint, managing postgresql views, creating updatable views, materialized views, creating updatable views using the with check option clause, and recursive view. In Chapter 4, you will learn statements, operators, and clauses including select, order by, select distinct, limit, fetch, in, between, postgresql like, is null, alias, joins, inner join, postgresql left join, self-join, full outer join, cross join, natural join, group by, having, intersect operator, except operator, grouping sets, cube, and rollup. In Chapter 5, you will learn postgresql trigger, aggregate, and string functions including creating the first trigger in postgresql, managing postgresql trigger, aggregate functions, avg function, max function, min function, sum function, postgresql concat function, ascii function, trim function, length function, substring function, regexp_matches function, regexp_replace function, replace function, to_number function, and to_char function.
A Pragmatic Approach To Database Programming With Jdbc And Mysql
DOWNLOAD
Author : Vivian Siahaan
language : en
Publisher: SPARTA Publishing
Release Date : 2019-03-04
A Pragmatic Approach To Database Programming With Jdbc And Mysql written by Vivian Siahaan and has been published by SPARTA Publishing this book supported file pdf, txt, epub, kindle and other format this book has been release on 2019-03-04 with Computers categories.
You will learn Java/MySQL fast, easy and fun. This book provides you with a complete MySQL guidance presented in an easy-to-follow manner. Each chapter has practical examples with SQL script and screenshots available. If you go through the entire chapters, you will know how to manage MySQL databases and manipulate data using various techniques such as MySQL queries, MySQL stored procedures, database views, triggers. In the first part of the book, 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 next chapter, we will discuss the database views, how they are implemented in MySQL, and how to use them more effectively. After that, you will learn how to work with the MySQL triggers. By definition, a trigger or database trigger is a stored program executed automatically to respond to a specific event e.g., insert, update or delete occurred in a table. The database trigger is powerful tool for protecting the integrity of the data in your MySQL databases. In addition, it is useful to automate some database operations such as logging, auditing, etc. Then, you will learn about MySQL index including creating indexes, removing indexes, listing all indexes of a table and other important features of indexes in MySQL. MySQL uses indexes to quickly find rows with specific column values. Without an index, MySQL must scan the whole table to locate the relevant rows. The larger table, the slower it searches. After that, you will find a lot of useful MySQL administration techniques including MySQL server startup and shutdown, MySQL server security, MySQL database maintenance, and backup. The last chapter gives you the most commonly used MySQL functions including aggregate functions, string functions, date time functions, control flow functions, etc.
Mysql For Java Gui Database Cryptography And Image Processing
DOWNLOAD
Author : Vivian Siahaan
language : en
Publisher: SPARTA PUBLISHING
Release Date : 2019-08-01
Mysql For Java Gui Database Cryptography And Image Processing written by Vivian Siahaan and has been published by SPARTA PUBLISHING this book supported file pdf, txt, epub, kindle and other format this book has been release on 2019-08-01 with Computers categories.
In this book, you will learn how to build from scratch a criminal records management database system using Java / MySQL. All Java code for digital image processing in this book is Native Java. Intentionally not to rely on external libraries, so that readers know in detail the process of extracting digital images from scratch in Java. There are only three external libraries used in this book: Connector / J to facilitate Java to MySQL connections, JCalendar to display calendar controls, and JFreeChart to display graphics. Digital image techniques to extract image features used in this book are grascaling, sharpening, invertering, blurring, dilation, erosion, closing, opening, vertical prewitt, horizontal prewitt, Laplacian, horizontal sobel, and vertical sobel. For readers, you can develop it to store other advanced image features based on descriptors such as SIFT and others for developing descriptor based matching. In the first chapter, you will be shown the number of devices needed to be downloaded and installed. You need to know how to add external libraries to the NetBeans environment. These tools are needed so that you can run the Java scripts. In the second chapter, you will learn the basics of cryptography using Java. Here, you will learn how to write a Java program to count Hash, MAC (Message Authentication Code), store keys in a KeyStore, generate PrivateKey and PublicKey, encrypt / decrypt data, and generate and verify digital prints. In the third chapter, you will learn how to create and store salt passwords and verify them. You will create a Login table. In this case, you will see how to create a Java GUI using NetBeans to implement it. In addition to the Login table, in this chapter you will also create a Client table. In the case of the Client table, you will learn how to generate and save public and private keys into a database. You will also learn how to encrypt / decrypt data and save the results into a database. In the fourth chapter, you will create an Account table. This account table has the following ten fields: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In this case, you will learn how to implement generating and verifying digital prints and storing the results into a database. In the fifth chapter, You create a table with the name of the Account, which has ten columns: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In the sixth chapter, you will create a Client_Data table, which has the following seven fields: client_data_id (primary key), account_id (primary_key), birth_date, address, mother_name, telephone, and photo_path. In the seventh chapter, you will be taught to create Java GUI to view, edit, insert, and delete Suspect table data. 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. In the eighth chapter, you will be taught how to create Crime database and its tables. In nineth chapter, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In the tenth chapter, you will be taught to create Java GUI to view, edit, insert, and delete Feature_Extraction table data. This table has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. All six fields (except keys) will have a BLOB data type, so that the image of the feature will be directly saved into this table. In the eleventh chapter, you will add two tables: Police_Station and Investigator. These two tables will later be joined to Suspect table through another table, File_Case, which will be built in the seventh chapter. The Police_Station has six columns: police_station_id (primary key), location, city, province, telephone, and photo. The Investigator has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. Here, you will design a Java GUI to display, edit, fill, and delete data in both tables. In the twelfth chapter, you will add two tables: Victim and File_Case. The File_Case table will connect four other tables: Suspect, Police_Station, Investigator and Victim. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The File_Case has seven columns: file_case_id (primary key), suspect_id (foreign key), police_station_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. Here, you will also design a Java GUI to display, edit, fill, and delete data in both tables.
Java Gui With Mysql Database And Image Processing
DOWNLOAD
Author : Vivian Siahaan
language : en
Publisher: SPARTA PUBLISHING
Release Date : 2019-08-26
Java Gui With Mysql Database And Image Processing written by Vivian Siahaan and has been published by SPARTA PUBLISHING this book supported file pdf, txt, epub, kindle and other format this book has been release on 2019-08-26 with Computers categories.
In this book, you will learn how to build from scratch a criminal records management database system using Java / MySQL. All Java code for digital image processing in this book is Native Java. Intentionally not to rely on external libraries, so that readers know in detail the process of extracting digital images from scratch in Java. There are only three external libraries used in this book: Connector / J to facilitate Java to MySQL connections, JCalendar to display calendar controls, and JFreeChart to display graphics. Digital image techniques to extract image features used in this book are grascaling, sharpening, invertering, blurring, dilation, erosion, closing, opening, vertical prewitt, horizontal prewitt, Laplacian, horizontal sobel, and vertical sobel. For readers, you can develop it to store other advanced image features based on descriptors such as SIFT and others for developing descriptor based matching. In the first chapter, you will be shown the number of devices needed to be downloaded and installed. You need to know how to add external libraries to the NetBeans environment. These tools are needed so that you can run the Java scripts. In the second chapter, you will be taught how to create Crime database and its tables. In third chapter, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In the fourth chapter, you will be taught to create Java GUI to view, edit, insert, and delete Suspect table data. 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. In the fifth chapter, you will be taught to create Java GUI to view, edit, insert, and delete Feature_Extraction table data. This table has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. All six fields (except keys) will have a BLOB data type, so that the image of the feature will be directly saved into this table. In the sixth chapter, you will add two tables: Police_Station and Investigator. These two tables will later be joined to Suspect table through another table, File_Case, which will be built in the seventh chapter. The Police_Station has six columns: police_station_id (primary key), location, city, province, telephone, and photo. The Investigator has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. Here, you will design a Java GUI to display, edit, fill, and delete data in both tables. In the seventh chapter, you will add two tables: Victim and File_Case. The File_Case table will connect four other tables: Suspect, Police_Station, Investigator and Victim. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The File_Case has seven columns: file_case_id (primary key), suspect_id (foreign key), police_station_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. Here, you will also design a Java GUI to display, edit, fill, and delete data in both tables. Finally, this book is hopefully useful for you.