Computer Science Projects

Recently it was announced by the Government of Cicada that Tulips would be legalized for consumers and businesses. Your company has been hired by the Government of Cicada to design the database to be used for monitoring this new industry. As the resident database designer at your company, you have been assigned to interviewing Mr. Colin Mochrie, the Government of Cicada’s representative in charge of the information infrastructure projects surrounding the new legal Tulips industry. Based on the transcript below, develop the complete ERD for this database with all relevant labels. Using the attached excel file, perform a full normalization of the sample data with all steps and relevant labels. Note: the flat file may be incomplete, so not all the data is represented in it.  Interview Transcript Nice to meet you Mr. Mochrie, thank you for taking the time to do this interview with me. It will really clarify things and help gain an understanding of the functional requiremen...

Modify your existing file server to support sockets and accept an infinite number of incoming connections. Get Project Solution by contacting us - via WhatsApp: +92-324-7042178 - via email: codelogixstudio@gmail.com Download Now Buy now

The Voice London Show Setup. In Part 2, based on a given ER diagram and a set of requirements, you will implement a relational model for a television talent show named TheVoiceLondon. Then, you will have to perform different data manipulation and retrieval operations on the database. On KEATs you will find a .zip containing template SQL files to edit for your Part 2 submission. Requirements. A television channel has decided to create a simple database to register payment information about its most successful show ‘TheVoiceLondon’. In this show, there are contenders that compete to represent the UK in Eurovision. These contenders are coached by famous artists (namely the coaches). Contenders can be formed by a group of participants or a single participant. Both coaches and participants are paid based on the number of shows they attend. For each coach and participant, the database sores their id, name surname, date of birth, phone, gender and daily salary. For each contender, the d...

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

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

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

MediRAY Chain of Pharmacies The MediRAY chain of pharmacies has decided to develop a database system to store information of their prescriptions, patients, doctors and related details . They have given the development to your company and your manager has handed over the task to you. Below are the requirements Patients and doctors are persons identified by the personal identification number. The person has address, email and phone number. Patients have patient number (the hospital and the patient number used here ), and their names, addresses, and ages must be recorded. Doctors have doctors registration number. For each doctor, the name, specialty, and years of experience must be recorded. Each pharmaceutical company is identified by name, address, email and has a phone number. For each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If...

There are the following tasks for this project Database general concepts In your presentation/report explain the followings: What is a database? Flat file database, its advantages and disadvantages and the circumstances in which flat file database may be used giving an example Relational database, its advantages and disadvantages and the circumstances in which relational database may be used giving an example Differences between flat file and relational database Entity type and entity giving examples Attributes giving examples Types of relationships giving examples Trust dental orthodontics database design ERD & implementation The table below lists a part of dentist/patient appointment data of Trust dental orthodontics. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of patient appointments, a dentist is allocated to a specific surgery for that day. There are 5 surgeries under the management ...