Computer Science Projects

Scenario: You are the database designer and developer for a donut shop that wants to create a smartphone application where customers an order donuts. First, you will design a normalized entityrelationship (E-R) logical database model to store data related to the customer, donuts, and donut order. Next, you will create four tables with primary and foreign keys that are derived from your ER model. Once the tables have been built, then you will create views and indexes to protect and fine-tune query performance. You will populate each of the tables with sample data. Finally, you will create both a simple “select-from-where” (sfw) query and a complex join query to produce meaningful reports on individual donut orders and summaries to determine which donuts sell the best. Requirements: A. Construct a normalized model to represent the donut shop smartphone application database that supports the scenario above by doing the following: Using the attached “Sales Order Form” (unnormalized ...

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 t...

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...