Use the International Stock Market database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict the Nikkei by the DJIA, the Nasdaq, the S&P 500, the Hang Seng, the FTSE 100, and the IPC. Assume a 1% level of significance.

What percent of residuals are within 1 standard error? Write your answer as a number rounded to 1 decimal place. Do not include the % sign in your answer.

Excel Data: https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharing

Listed below is the relational database schema for an online store(SQL/Java):

MEMBER(last_name, first_name, email, password, user,street, city, state, zip, card_type, card_no, expiration, name_on_card)

book_SALE(listing_no, seller, isbn, condition, price)

ORDERS(order_no, buyer, order_date, tot)

ITEMS(order_no, listing_no)

BOOK(isbn, title, author, edition, publisher, keywords)

The bold attribute(s) in a relation is the primary key of that relation. The italized attributes in some relations denote foreign keys.

Create/Define the table.

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.