Computer Science Projects

Background  Real-world databases are typically many orders of magnitude larger, in terms of numbers of relations, and the size of each relation. This impacts a crucial aspect of database usage, ‘performance’ (basically, how fast queries are processed). Your practical task will be to download such a database, and use it to learn more about real databases. You are going to download the ‘Mondial’ database, which carries information about the countries of the world. This is supposed to be based on the CIA’s World Fact Book among other sources. Go to this website: www.dbis.informatik.uni-goettingen.de/Mondial/ Find the paragraph entitled ‘Generating the Database under MySQL’ and click on each of the following links. www.dbis.informatik.uni-goettingen.de/Mondial/OtherDBMSs/mondial-schema-mysql.sql www.dbis.informatik.uni-goettingen.de/Mondial/OtherDBMSs/mondial-inputs-mysql.sql You do not download the data in the database base directly, but rather you download statements in the f

Relational Algebra A database records information about athletes competing at the Olympics. An athlete competes for a particular country in one or more events. Events take place at a scheduled day and time in a particular venue. The result (rank) is recorded for all athletes in the final of the event. The medal (gold, silver or bronze) is also recorded for the medal winners in the event. Note that we are not considering team sports or heats in this example – only individuals competing in the finals. The schema for this database is as follows: (Note that primary keys are shown underlined, foreign keys in bold). ATHLETE (AthleteNo, AthleteName, CountryName) COUNTRY (CountryName, NumberOfCompetitors) EVENT (EventName, ScheduledStart, VenueName) VENUE (VenueName, City, Capacity) FINAL (AthleteNo, EventName, Rank, Medal) Provide relational algebra (NOT SQL) queries to find the following informaList the name and country of all athletes. List the event name and scheduled start

Rot13 Rot-13 - this rotate 13 characters in the alphabet and wrap back around. "abcdefghijklmnopqrstuvwxyz" "cat" "png" - encrypted using rot13 Implement the ability to read in the contents of a file, encrypt it using rot13, then write the encrypted version to a new file called encrypt.txt.  You should be able to test the accuracy, by copying the contents of encrypt.txt into your source file and running encrypt again and see you original message in encrypt.txt. Download Now Buy now

Tables Identify the tables contained in your database and describe the contents of each table(need 6 tables), including the data fields in each table, the primary key, and any foreign key(s). Please also include a relationships diagram, using Access’s Documentor tool for this. A minimum is twenty (20) records per table. Projects with at least ten data fields for each table will receive more credit than those with less than these amounts. Need one-to-many relationships within tables. Queries Document the twelve (12) separate queries you created, as identified above. For each query, indicate in your report why you created the query, what information it selects, and how it helps your business. It is not necessary to screen capture the outputs from each query, but a screen capture of each query in design view with full formulas showing would be helpful. Also, please create a two-column table that lists the special requirements by number, and which one of your queries satisfies it. F

On February 18, 2001, Robert Philip Hanssen was arrested and charged with committing espionage on behalf of the intelligence services of the former Soviet Union and its successors. He pled guilty to 15 counts of espionage on July 6, 2001 and was sentenced to prison without the possibility of parole. Hanssen is considered the most damaging spy in FBI history. At the time of the arrest at a park in Vienna, Virginia, Robert Philip Hanssen, age 56, was clandestinely placing a package containing highly classified information at a pre-arranged, or “dead drop,” site for pick-up by his Russian handlers. Hanssen had previously received substantial sums of money from the Russians for the information he disclosed to them. Hanssen was charged in a criminal complaint filed in Federal court in Alexandria, Virginia, with espionage and conspiracy to commit espionage, violations that carry a possible punishment of life in prison, and under certain circumstances, the death penalty. Following the arr

United Community Bank Database Requirements The Project The United Community Bank (UCB) is a well established regional bank operating primarily in South England, but with several branches in key cities and towns in the North. The last 5 years saw the bank transform into a fully computerised bank. Keeping in pace with its philosophy of responsive customer service, UCB decided to offer online banking services to its customers. The new online banking service would fully integrate with the core banking solution already implemented at the bank. The online banking service is open to savings account customers and current account holders. The basic entity for explaining all operations in the bank is the customer. A customer may have one or more accounts in the bank spread across one or more branches. Customers open bank accounts with a specified opening balance and thereafter may either deposit funds into the account or withdraw amounts from them. For each customer the system wants to reco

ABC company is a small computer security contractor that provides computer security analysis, design, and software implementation for the U.S. Government and commercial clients. ABC company competes for both private and U.S. Government computer security work by submitting detailed bids outlining the work the company will perform if awarded the contracts. Because all of the work involved computer security, a highly sensitive area, almost all of ABC company’ tasks require access to classified material or company confidential documents. Consequently, all of the security engineers (simply known as “engineers” within the company), have U.S. government clearances of either Secret or Top Secret. Some have even higher clearances for the 2% of ABC company’ work that involves so called black box security work. Most of the employees also hold clearances because they must handle classified documents. Leslie is ABC company’ human resources (HR) manager. She maintains all employee records and is r

Database Requirements You have been hired by a nation-wide fitness company named Fitness4All. Fitness4All has gyms in different locations and offers different types of memberships to customers. Customers can also purchase different fitness lessons and personal training sessions. The company wants to utilize a DBMS to track the sales of classes and memberships. In addition, Firtness4All would like to start a customer loyalty program called the SuperFitRewards. Members who sign-up to SuperFitRewards can get offers on free classes! This also will allow Fitness4All to store data on customer purchases for his Data Science team to analyze. Here are the specifications for the database requirements: Fitness4All has gyms in different locations across the country. All of these gyms have a gym suite and they may have a swimming pool. Each gym has a unique identifier and the date in which the gym opened. Customers can become members of any of these gyms. In particular, there are three types

Bounds Job Opportunities (BJO) Bounds Job Opportunities (BJO) is an organisation which tries to match people seeking new job opportunities with companies offering employment prospects. BJO have several offices in major cities in the Midlands. Many companies prefer not to advertise vacancies themselves, instead using an agency for the major part of their recruitment. Thus such agencies as BJO place advertisements in the most appropriate websites and newspapers. Each advertisement includes details of one or more jobs. Where a number of jobs are listed in a single advertisement, the vacancies are with a range of companies, rather than each advertisement listing the opportunities available with a single company. BJO operates in a variety of ways. Companies register with BJO (including their name address etc.), notify them of job vacancies and supply a job description for each. Each job description is analysed and the key requirements, such as preferred age range of applicant, skill and

Task A: Use the following program: Program or Class Name: Description of program or class: What does it do? How do you use it? Author: [your name] Date: */ import java.util.Scanner; public class TaskA { public static void main(String[ ] args) { System.out.print("Enter a word: "); // declare Scanner objects that accept standard input // https://docs.oracle.com/javase/8/docs/api/java/util/Scanner.html Scanner so = new Scanner(System.in); String word = so.nextLine(); String[] chars = word.split(""); System.out.println("The word entered is: " + word); } } Edit, compile, and run the program. Then modify the program to print out only the first and last letters of the entered word. Task B: Modify the program in task 1 by adding specialized methods to accomplish each of the following on the word input by the user: 1. Converts each character of the entered word into an array of Unicode decimal numbers (See: http://unicodelookup.com )