Computer Science - Java Programming

How do you read a text file and store three different pieces of information in the database when the given text file contains this info.:

12345 Computer Science Bob Stone

23456 Art James G. Ocean?

These are written in the format as

ID Class Name.

I was going to take the three different pieces of information by separating them by spaces, but the number of spaces is random and I don't know how to adjust it accordingly.

How should I do this? Is it even possible?

Answer these theory questions:

a. Explain the referential integrity rule. Provide a suitable situation when the referential integrity constraint is violated.

b. Consider a relation named STUDENT_ ACCOMMODATION (StudentID, Buidling, AccommodationFee) as shown in the figure below. Explain why this relation is in 2NF but not in 3NF.             

c. Explain the purpose of transaction logs and checkpoints.

d. Compare and contrast Data Warehousing against Database.

With respect to selection reliability, selection procedures need to be reliable across ______.

Question 2 (2.5 points)

A(n) ______ is a searchable database that can be used to identify employees who meet certain job requirements.

Question 3 (2.5 points)

A company should carefully consider the balance between its external and internal recruiting and decide how that balance affects the _______ of the organization.

I need to draw an ER diagram for a future database necessary to hold application data for students wishing to apply for an internship at a tech company.

The students will provide the following information on the application:

first name, last name, email, phone number, address, city, state, postal code, major, currently enrolled in school?, expected date of graduation, web framework of choice, list of programming languages in which the student is proficient, SAT score, ACT score, GPA, 4 character references, list of previous employments.

40. suppose I am modeling a bank. For a CUSTOMER entity, explain why a customer's social security number is a better identifier than (LastName, FirstName).

39. Suppose I want to model an online retailer. Customers may choose to have the order delivered to one of multiple addresses which are saved in the database.

What type of attribute does "Address" represent and how should I handle it in my model. You do not need to include any discussion of cardinalities as part of your answer.

ASSIGNMENT:

• Research a current or previous year article on any of the topics listed below or topics related to week the materials. Narrow down your topics if possible.
• Then, in a 2-3 page paper, write an applied summary paper. Applied means what you write from the viewpoint of a project manager in a work or project setting.

Suggested topics for the assignment include:

• Leadership
• Cybersecurity Project Management
• Software Development Management
• Database Project Management
• Cybersecurity
• IT Security
• IT Project Management
• Information Security Management
• Business Analytics

Activity 2: Injection Basics Injection attacks trick an application into including unintended commands in the data send to an interpreter.

Interpreters Interpret strings as commands such as SQL, shell (cmd.exe, bash)

Critical Thinking Questions: 1. What does a user/attacker see at the webpage? Where can an attacker enter exploit data/input? 2. Which entity builds user string input and send SQL query to Database server? 3. Which entity executes query including exploit and send back to web server and then user?  

Oriole, Inc. began work in 2018 on a contract for $21420000.

Other data are as follows:

   2018    2019

Costs incurred to date $9180000 $14150000

Estimated costs to complete    $6120000    0

Billings to date    $7060000 $21300000

Collections to date $5060000 $18150000

If Oriole uses the percentage-of-completion method, the gross profit to be recognized in 2018 is