Question 7 – Data Design Bundoora College has a small book store that opens for students, staff and general public. Currently, they use a manual order system. The manager asked you to build a database for them. You had an interview session with him and you get a general overview about the database requirements. The database should store: • Orders information made by students, staff or general public. The order should have order number, the date and the time it is made. • Customers details, so that the manager can notify the customers with the order status as well as send promotional material. The detail includes customer code, the full name, home address, contact phone number, and email address. • List of the items in each order. The items can be books and/or stationeries. For each book, you should be able to include the details such as the title, the authors, the ISBN, and the price. For stationery, you should have the code, description, and price. • If a book is required for a particular subject offered in Bundoora College, the database should store this data as well. The information includes the subject code, the subject name, the coordinator name, and the semester it is offered.

a) Create an Entity-Relationship Diagram (ERD) for the bookstore database. Make sure you include all required entities, relationships and cardinalities information. [15 marks]

b) Create the table design (schema) for the database. You should indicate clearly the primary and foreign keys for each table. [10 marks]

c) During which phase of the SDLC is ERD used? [5 marks]

We plan to develop customer’s database that stores customer’s number (ID), first name, last name and balance. The program will support three operations: (a) reading and loading customer’s info from the text file, (b) entering new customer’s info, (c) looking up existing customer’s info using customer’s number(ID), (d) deleting the customer’s info and (e) the updated database will be stored in the text file after the program terminate.

Customer’s database is an example of a menu-driven program. When the program begins to execute, it first read the text file and upload customer’s info. Then it presents the user with a list of commands. The user can enter as many commands as desired, in any order. The a command prompts the user to enter customer’s number (ID), first name, last name and balance, which are then stored in the program’s database. The f command prompts the user to enter a customer number and then display the corresponding record on the screen. The q command saves the information in the database to the file specified by the user and terminate program.

Based on the project description, please design classes and their corresponding methods. You need describe each method and write API for each method (Leave method body blank) (Hint: you need design one driver class, one database class and one customer record class). Based on your design, please draw the UML diagram as well.

database.txt

12345 Sebastian vanDelden 123.22
11111 Sarah Smith 45.89
22222 Sue Johnson 7765.98
33333 Billy Hunts 374.99

Consider the following random sample observations on stabilized viscosity of asphalt specimens.

Suppose that for a particular application, it is required that true average viscosity be 2000. Is there evidence this requirement is not satisfied? From previous findings we know that the population standard deviation, σ = 89.3.
State the appropriate hypotheses. (Use α = 0.05.)

H₀: μ ≠ 2000

H_a: μ = 2000

H₀: μ > 2000

H_a: μ < 2000

H₀: μ = 2000

H_a: μ ≠ 2000

H₀: μ < 2000

H_a: μ = 2000

Calculate the sample mean and standard error. (Round your answers to three decimal places.)

Test the appropriate hypotheses. (Round your z test statistic to two decimal places and your p-value to four decimal places.)

What can you conclude?

Do not reject the null hypothesis. There is strong evidence to conclude that the true average viscosity differs from 2000.

Reject the null hypothesis. There is strong evidence to conclude that the true average viscosity differs from 2000.   

Reject the null hypothesis. There is no evidence to conclude that the true average viscosity differs from 2000.

Do not reject the null hypothesis. There is no evidence to conclude that the true average viscosity differs from 2000.

how is database is common in every where in the realworld?
DBMS allows substance and relations among them to frame table , explain.
DBMS supports an agreement that helps the user to keep the integrity of the database, explain
please use simple words to understand to clear and make good examples. thank you

PLEASE SHOW CALCULATIONS

2017 2018

BALANCE SHEETS:

Assets:

Cash 74,181 66,301

Accounts Receivable     35,673 48,995

Inventory 4,855 3,986

Other Current Assets 13,936 12,057

Fixed Assets, net 33,783 41,304

Investments 212,891 233,082

Total Assets    375,319 405,725

Liabilities and Equity:

Accounts Payable    44,242 55,888

Other Current Liabilities     50,226 55,416

Long-Term Debt 103,703 102,519

Other Non-current Liabilities   43,251 48,209

Common Stock 35,567 33,293

Retained Earnings   98,330 110,400

Total Liabilities and Equity   375,319 405,725

INCOME STATEMENT:

FY 2018

Revenue 265,595

Cost of Goods Sold 163,756

General and Administrative 14,793

Depreciation Expense 10,903

Earnings Before Interest and Taxes   76,143

Interest Expense 3,240

Pretax Net Income 72,903

Income Taxes 13,372

Net Income 59,531

Please assist with the following questions based on the above information. Thank you

1.Assuming that all Apple’s sales in fiscal 2018 were on credit, how many days, on average, did it take Apple to sell its inventory in 2018? (For balance sheet accounts, use the average of the beginning and end-of-year balances).

2.. Assuming that all Apple’s sales in fiscal 2018 were on credit, what was the company’s Days Sales Outstanding in 2018? (For balance sheet accounts, use the average of the beginning and end-of-year balances)

3. How much did Apple pay out in dividends during fiscal 2018?

4. What was Apple’s dividend payout ratio during fiscal 2018?

5. What was Apple’s Equity Multiplier for 2018?

Must post first.

Write a short "newsletter" article (3 to 5 paragraphs) for the non-technical managers and employees at Sifers-Grayson to explain the following:

(a) What is Phishing? (Focus on phishing emails and targeted attacks that include spear phishing and whaling.)

(b) What "bad things" can happen when a successful phishing attack gives outsiders access to company networks and computers?

(c) How can employees avoid "biting" on a "phish?"

(d) How should employees report phishing attacks? Why is immediate reporting critical to stopping the attackers?

Since this article is for a newsletter, you may use an informal but professional tone (address the reader as "you," use "we" and "our" to refer to the organization's perspective). The focus of the article should be upon changing how people think about and respond to computer security incidents. Humor is good but should not lessen the severity of the problem.

Provide in-text citations and references for 3 or more authoritative sources. Put the reference list at the end of your article

Bundoora College has a small book store that opens for students, staff and general public. Currently, they use a manual order system. The manager asked you to build a database for them. You had an interview session with him and you get a general overview about the database requirements. The database should store:

• Orders information made by students, staff or general public. The order should have order number, the date and the time it is made.
• Customers details, so that the manager can notify the customers with the order status as well as send promotional material. The detail includes customer code, the full name, home address, contact phone number, and email address.
• List of the items in each order. The items can be books and/or stationeries. For each book, you should be able to include the details such as the title, the authors, the ISBN, and the price. For stationery, you should have the code, description, and price.
• If a book is required for a particular subject offered in Bundoora College, the database should store this data as well. The information includes the subject code, the subject name, the coordinator name, and the semester it is offered.

Create an Entity-Relationship Diagram (ERD) for the bookstore database. Make sure you include all required entities, relationships and cardinalities information.

Jayhawk Company leased a machine from Houston Leasing. The machine had a 5 year life. the lease was for three years and required three payments of $300,000 each made at the beginning of the year starting with January 1, 2018. The lease was non-cancelable, and title did not pass at the end of the lease. There was no bargain purchase right either. However, the present value of the minimum lease payments was greater than 90% of the fair value on January 1, 2018. The cost of the leased equipment was $650,000. Houston's earning's rate is 8%, and there is an ungauranteed residual value of $30,000 at the end of year 3. The actual value at the end of year 3 was $9,000. Houston considers this lease a sale type lease.

On the books of Houston,

a. Determine the lease receivable and prepare an amortization schedule of the lease receivable.

b. Record the inception of the lease on January 1, 2018 and the receipt of the first payment.

c. Record the last receipt from the lease and the return of the equipment.

Culver Corporation had a net income for the current year ending December 31, 2018 of $1,150,000. Throughout 2018 the following items were outstanding:

No dividends were declared or paid in 2018. Culver’s tax rate is 25%.

1. Calculate basic earnings per share. (For simplicity, ignore the requirement to record the debt and equity portions of the convertible bond separately).

2. Calculate diluted earnings per share. (For simplicity, ignore the requirement to record the debt and equity portions of the convertible bond separately).

You scan through a list of n elements, keeping track of the max. Every time you encounter a new max, you update some variable. How many times do you expect to make such an update?

Define the answer as a random variable, break it into indicator random variables, use linearity of expectation, evaluate each IRV, and finally express the answer as best you can using O, Ω, or Θ.