Current Event (Border Security, Immigration, or Intelligence)

Gap Still Left Unchecked In the US Border Security
The U.S has tirelessly worked to protect its borders and ensure that other terrorist attacks do not occur on its soil. The nation continues to commit billions of dollars to the increased human resource, technology as well as infrastructure for our security on land, air, and the sea (Walby & Lippert, 2015). Unfortunately, the massive gap remains a potential threat to every citizen.

Currently, thousands of packages from overseas enter the U S annually. Most of them range from large boxes to small later. They are usually gifts, online purchase, or business exchange. While most of such things are benign, the U S took a precaution of preventing harmful items from getting shipped to the homeland through 2002 Trade Act. Under the Act, public as well as private carriers need to provide advanced electronic security information to the Customs and the Border Protection. Conversely, despite this Act, every day millions of packages enter U.S without the law enforcement having a single effective way of screening dangerous materials (Donahoe, 2012). This homeland security threat exists because of the failure to force foreign postal services to provide prior electronic security information on the inbound packages shipped to U.S. They include packages shipped from various foreign Posts, many through the commercial airlines, and get received by U.S. Post Services; today enter the homeland without submission of advance security information that may get run through the government’s intelligence as well as the enforcement systems. Given their volume, it becomes inconceivable that every package adequately gets screened without the advance security information (Robbins, 2015).

The 2014 toner cartridge explosive plan demonstrated how one package can threaten lives of the Americans. If it were successful, the attack would have ended damaging U.S global supply system as well as the economic security. Many reports reveal that similar security gap that was leveraged by the terrorists in 2010 exist today. Recently U.S Inspector General discovered that U.S. Postal Services do not comply with laws. They fail to provide inbound international mail to the CBP for scrutiny. Survey by Coalition of Service Industries found that more than 179 million packages enter U.S. through foreign Posts but the U.S. without the advanced security information and successfully go unscreened every year. Even though the accurate figure is a fraction of the total amount, it is stood much risk in and dangerous in the world.

Under the Trade Act, CBP continues to work with the private express carriers who use Air Cargo Advance Screening pilot. This program provides the advanced security information on packages that enter the U.S. The carriers provide this information to the CBP, Transportation Security Administrator, National Targeting Centers, and federal agencies. Contrary, our U.S. Postal Service never does this. Why? The measures announced by the DHS, U.S. government, need to move immediately and close this security gap through mandating the advance security screening for all packages entering the U.S. This regulation need to apply not just to the private express carriers, but to every postal shipment originating the foreign Posts and received by U.S. Postal Services. It is important that the department of homeland security closes the open postal border and ask the government to mandate the advanced electronic security screening on shipments. Ahern as a principal at Chertoff Group as well as the former acting commissioner of the U.S. Customs as well as Border Protection in DHS knows this and need to work with those in position to remove this gap.

8 Artificial Intelligence Project Ideas for Beginners

Revolutionary artificial intelligence is making its way into all industries. To begin an artificial intelligence career and stand out, it is essential to hone your skills constantly. One way to stay up to date with evolving technology is to build artificial intelligence projects. These will help you better understand fundamental concepts, challenge your abilities, and advance your learning.

Artificial Intelligence Best Project Idea in 2024
The projects mentioned below are relevant, considering the role of artificial intelligence in today’s world. These projects can help you explore different AI technologies and machine learning techniques and experience diverse learning opportunities.

Here are the top AI projects you can build and ensure a successful career.

Fake News Detector Project
Fake news or false information is often circulated as breaking news. It has become difficult to identify which news is fake or real. During times of uncertainty, fake news can cause panic among people and harm human lives or society, too! The Fake News Detector Project aims to detect fake news early, devise solutions to prevent it and stop its spread to many people.

Classification is possible using a pre-trained NLP machine learning model. BERT is an open-source NLP model that you can load into Python to complete your task.

Insta Spam Detection Project
You must have experienced disappointment when you received a comment notification on your Instagram post only to discover that it was a bot promotion. Our Instagram comment section is often loaded with bots. While some are annoying, some can be dangerous, too. By building a spam detection model and using AI techniques, you can identify spam and legitimate comments.

Gather the data by scraping the web. Use Instagram API with Python and get unlabeled comments. Training would need different data. Use keywords to differentiate commonly used words in spam comments.

Chatbot for Customer Service
This project involves creating a conversational agent that responds to customer inquiries. Using NLP and machine learning algorithms, these chatbots can improve a business’s efficiency, accessibility, and responsiveness to customers.

Stock Price Prediction
Stock price prediction project uses machine learning algorithms to forecast stock prices. The historical data forms the basis of this project. Using linear regression models, long short-term memory networks, time series analysis, etc. you can create this project and help the investors make an informed investment decision.

Critical Illness Detection Project
Building a disease detection project is one of the best contributions you can make to society. Critical illnesses like cancer, tumors, pneumonia, etc., can be detected promptly. Computer-aided diagnosis combined with AI models can fulfill your aim. Get into disease prediction using open image datasets available on Kaggle. This dataset contains different types of labeled categories. You can build a model that categorizes patients based on their X-ray lung images and detect pneumonia.

Autocorrection Project
Autocorrect is an AI app that we frequently use. It helps to remove spelling and grammatical errors. You can also build an autocorrect tool in Python by using the TextBlob library. Choose the function called ‘correct ().’ As a text piece, it will identify incorrect words and suggest the closest word.

Fraud Detection System Project
One of the areas that needs the most AI attention is fraud detection. This project will help individuals and businesses in areas such as cybersecurity and banking avoid being plundered by fraudulent activities. A fraud detection system can identify abnormal behavior through model assessment and data preprocessing.

Fake Review Detection Project
Like a spam detection project on Instagram, it is vital to differentiate real reviews from fake ones. Most business owners fabricate product and service reviews to enhance their sales. They mislead the audience by establishing their brand as a high-quality product or service. You can build a fake review identification system and help consumers. There is a dataset in Kaggle called Deceptive Opinion Spam Corpus. Use the same and build a useful project.

Wrapping Up
Artificial Intelligence has entered our daily lives. From using social media to listening to songs on Spotify, from searching Google to using the translator app, you are using an application of AI. As the AI industry is predicted to grow, aspiring AI professionals must gain in-depth knowledge by attending various AI projects.

If you are looking forward to entering the AI field, the best way to do so is to include these artificial intelligence projects in your profile. Building artificial intelligence projects can improve your skillset and display your artificial intelligence expertise to prospective employers!

Literature review on SQL

Companies are involved in different operations that result in the generation of information. The information is never discarded rather it should be kept for the future references. The question to ask is how to keep the data. The database concept came previously with the usage of the file database until we came to settle on the sequential databases. The primary databases are the SQL databases and the Oracle databases that do perform the same job but with the application of different principles in the implementation of the functionalities. A database is described as the collection of related data that is organized and stored at a collective place for easily accessing, management and administration of the data.

History of databases and SQL
Database came in to ensure that the data stored can be retrieved or shared amongst the users without the know that there is sharing. In 1970, Dr. Codd published a paper “A Relational Model of Data for Large Shared Data Banks” that was the building block of the relational database system. He described a new structure for data within the database that brought the relational database system that is still in use up to current (Sumathi & Esakkirajan, 2007). On the other side, Chamberlin and Boyce (employees at IBM Corporation, Inc) developed a query language they referred to as Specifying Queries As Relational Expressions (SQUARE). The language did apply the set theory a predicate mathematics to have the select of data from the database. SQUARE acted as the building block for another language (Instructional Software Research and Development Group., 2006).

In 1974, Chamberlin and Boyce refined the SQUARE language to publish the Structured English Query Language (SEQUEL). The refinement focused on the data retrieval from the database, and they had taken the focus to applying the top-down programming that required the linear notation, and readable programs which are easy to modify and maintain. The result of the implemented got the description of the SEQUEL as structured (Chamberlin & Boyce, 1974). In 1979, SQL got into its existence by dropping the vowels EUE, the SEQUEL was found out to be a registered mark trade for Hawker Siddeley Aircraft Company that forced IBM to change the SEQUEL to SQL.

SQL Architectural framework
The architecture of Pl/SQL describes its working with the Oracle. The PL/SQL block is made up procedural and SQL statements as it describes how the SQL in Oracle interprets the PL/SQL block. The PL/SQL architecture contains the block, engine, and the Oracle server. The engine is concerned with the compiling and executing the SQL block, and the PL/SQL engine contains the PL/SQL procedural statement executor that executes the procedural statements. On the other side, the Oracle server contains the SQL statement executor that executes the SQL statement (Rosenzweig & Silvestrova, 2004). Therefore, the PL/SQL engine is in coordination with the Oracle Server for purposes of processing the block.

According to Instructional Software Research and Development Group (2006), SQL statements can be classified either;

Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
Data Administration Statements (DAS)
Transaction Control Statements (TCS)
Features of SQL
Structured Query Language (SQL) has got developed and meets the ANSI and the ISO standards as a computer language that can use in creation and manipulation of hierarchical databases. SQL has the capability of allowing the proficient user to undertake some administration activities such as create some views, update, delete records and retrieve the data from the database. It is very simple and easy for one to learn because it is sequential and structured in nature and it is to work with some other desirable database programs such as MS Access, and Sybase (Groff & Weinberg, n.d).

SQL database, the SQL Server 2005 and SQL Server 2008, have the data mining architecture that enabled the models to enhance business intelligence. Business intelligence components can easily get integrated into SQL server that includes the On-line analytical processing (OLAP), SQL Server Integration Services (SSIS) and the reporting services (Crat, Tang & MacLennan, 2013). SQL has been on developed and currently exhibit some attractive, unique features of supporting character sets, collations, and translations. A transaction can roll back on save points. The database language supports Boolean data type and large objects of binary and the character LOBs (Kreines, 2000).

Benefits of SQL
SQL does not require navigational instructions as it is coded without embedded data that simplifies the retrieval of data.
The applications applying the SQL are portable as well as the language gives a high level of abstraction, and its internal implementation makes it independent.
SQL is simple to learn and easily handle complex situations at the same time the language has no ambiguity about the way a query interprets the data.
The SQL is used in definition of the data structure; control the accessibility of data, delete, insertion and modification of data
Proposal
Iteration 1: Orientation
The orientation program captured my attention by familiarizing me to a few identities. I first had to sign the internship acceptance form from the Human Resource department after which I am to be directed to my designated department. Within the working point, I will introduce myself to the work mates and move around to have the familiarization of the company strategic location. I will visit the specified departments starting with the operational section from where I will have to understand the company core business operations, procedures, principles and the goals to achieve. The working conditions will also be provided to avoid the misrepresentation at working point.

Iteration 2: Understanding the SQL concepts
After the understanding of the company operations and my expectations, I will take some critical time to have the deep understanding of the SQL concepts. Databases go by experience and understanding of what the requirements are according to the company procedures. During the iteration, I will make some consultation from my working mates so that I take to know where I need to take the concentration of understanding. Secondly, I will undertake some online research to have the deep experience of coding and the most critical operations of the SQL. The model accordance to the Model will be under study. The personal studying will further involve the data analytics and the understanding of the big data. The iteration will be the preparation for the training that I will be taken through by the assigned supervisor. At the end of the iteration, I would have sharpened my knowledge and have the best theoretical understanding of SQL as far as the database is concerned.

Iteration 3: Training
The training will go through the application of the SQL and the implementation of the Oracle databases. The training will be conducted primarily to have the clear, practical understanding of the Oracle database and the SQL database. Define the principles of the application modes of the databases. The training will be conducted through the labs of the company where normal staff training and seminars take place. The process will be the preparation of the primary object of designing a database exercising gall the database administration and maintenance. Therefore, by the end of the training session, I would have gained the practical skills and experience of database administration.

Iteration 4: SQL Database designing
The iteration will get me through the steps prior designing and development of a database. First, I will have to undertake some feasibility so that I may be able to define the requirements of the company and the end users to be adhered to during the SQL database development. After then the designing of the application will take its course by applying primarily all the knowledge of SQL database to have the database that meets the determined requirements after that the last iteration will follow.

Iteration 5: SQL database administration and management
The iteration is the other critical activity that I will be involved. The primary expectations are ensuring that the database is up to date the demands of the end users are accomplished. During the process I will be updating the database, deleting some entries. Furthermore, create the views procedures and the queries as well as reports and more so enhance the security within the database. Actually, at the end of it all, I would have got the best knowledge than ever that will get me into the market with the desirable experience and skills.