Computer Science Projects

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

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

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

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

Context A tour management agency runs concert tours.  It sets up tours by bands.  On a tour, a band gives concerts at venues on various dates. Only one band goes on a tour, and a band goes on only one tour at a time.  Tours have names. A band has musicians as members.   A band also has a music style, such as “heavy metal” or “folk”. There are several tour dates on a tour.  Each occurs at a venue, on a particular date. At each date, a certain amount of money is received in ticket sales. Each venue has a cost for hiring it.  Each concert yields a certain amount from ticket sales.  The difference between the cost and the ticket sales is the profit on the concert. What a Database will be used for? The management agency wants a database about its business.  It wants to be able to find out such things as which tours it has arranged.  (Assume that all tours have finished - covering tours that are still going on is an easy extension, b...

Project Introduction Thank you for your application for the role of Database Administrator (DBA) at OurCompany Inc.! We are currently reviewing applicants and would like to congratulate you on making it past the first round of screening. As part of our company’s hiring policies, we require that applicants for this role submit an assessment of their competencies. The assessment will comprise of the following deliverables, to be produced and returned to OurCompany within 48 hours of issuance; Database Analysis and Design - ERD During your role as DBA you will be required to perform requirements analysis to determine what type of information needs to be stored, and understand the operational needs of the database. For this assessment we have provided you with a transcript of an interview with a client, found in Appendix A. You will need to read this transcript and synthesize the needs of the database based on the client’s responses to the interview questions. Based on your underst...

Trace Table with algorithm Test the following algorithm using the trace table technique. The given variables values are: x = 3, y = 5. Declare the integer variables x, y, z Ask the user to Enter the first integer number Input x by the user. Ask the user to Enter the second integer number Input y by the user. Compute x*2+y*3 and assign the result to the variable z. Display the value of the variable z. Finding Odd numbers from an array Write a C program to print the odd elements of the following array on the screen ar[] = { 2, 1, 8, 5, 9, 6}; Get it now! Buy now