Enumerate 5 items that you must maintain update in the maintaining surgical supplies

Search on the following three phrases:

• Insertion Anomaly
• Update Anomaly
• Deletion Anomaly

Assuming Database is not providing Referential Integrity Constraints support i-e Primary key, foreign key and Unique key, your task is to design a database engine with your own built in Referential integrity rules implementation and you need that only one database connection is maintained which an application should access.

Recommend proper design pattern used for the stated problem. Give reasons for selecting that pattern, create complete class diagram for the solution. The class diagram should also show the methods of the class and all the relations a class has with other classes. Also provide complete working code of the example

As an enterprise system developer, you need to develop the registration page of the employee management system. The administrator of the system registers a new employee using the GUI developed in JSP. The required table ‘Employee’ is provided in mysql database with columns as employee id, name, address, city, state and zip code as shown in figure.

Write a GUI snippet/JSP code with GUI components to take the user’s input. Separately, write the servlet code to insert the input records from the JSP page into the ‘employee’ table using JDBC (Java Database Connectivity).
Note: You may assume the username and password for the database connectivity.

1.  Several ASU's have been issued by the FASB over the last several years. Accounting Standards Update No. 2015-01 Extraordinary and Unusual Items was issued in the beginning of 2015.

Required: (Address only extraordinary items in your answer.)

1.What was the reason for this update?

2.What was the standard before and how has it changed the presentation of extraordinary items?

3.Do you think this is an improvement? Give two reasons for your answer.

void Stack :: push(float x)
{
  if (count _______ capacity)                                                    // If there is no room for a new value
{
float* new_A = ______ float[ 2 * ________ ];                     // Create a new array with two-fold capacity
for (int i = 0; i < count; ++i)                                   // Copy existing data to new array
_______= A[i];
delete[]__________ ;                                                          // Delete old array
A = new_A;                                                            // Connect to the new array
capacity *= _______ ;                                                    // Update the capacity
}
A[ ______] = x;                                                                   // Insert the new item onto the stack
++ ________ ;                                                                          // Update count of items in the stack
}

Lab 1 – Databases, Schemas, and Basic Tables

For this lab we will be creating a small Student Loan Database.

Make sure to open your screenshot word document. Include the required screenshots of your code in the document.

Database: Create a new database: StudentLoan_LastName.
Schemas: Create the following schemas. Make sure to screenshot and run your code:

1. Student
2. Guarantor 3. Institution 4. Activity
5. Loan
6. Lender

Tables: First complete the word document for designing the tables like we did in the slides. Use the information below to complete the file.

Note the schemas the tables are associated with:

Schema. Table Name

Student tblStudent

Guarantor.   tblGuarantor

Institution.   tblInstitution

Activity. tblActivityReport

Loan.   tblLoan tblLoanStatement

Lender. tblLender

Finally, write and screenshot the code for creating the following tables in your database. Make sure to run the code to create the tables:

tblStudent –include the student’s names, date of birth, and gpa.

tblGuarantor – include the guarantor’s name, address, city, state, zip, and phone

number.

tblInstitution – include the institution’s name, address, city, state, zip, and phone number.

tblActivityReport - include the name of the activity, begin date for activity, end date for activity, and how much the activity costs.

tblLoan – include the name of the loan type, the amount of the loan, the begin date of the loan, the id of the guarantor of the loan, the id of the lender for the loan, and the id of the student who took out the loan.

tblLoanStatement – include the amount of the loan, the id of the student who took out the loan, the amount of money the loan is for, the graduation date of the student, and the monthly payment amount for the loan.

tblLender – include the lender’s name, address, city, state, zip, and phone number.

Backup the database file, zip it.

Submit the following:

1.the zip of your database file

2.the table creation word document

3.the code screenshots document

Grading Rubric:

Grade item   Points

Create correct database 10pts

Create all 6 schemas   20pts

Create and associate the correct tables with their schemas. Make sure to use correct data types. 30pts

Screenshot Document   15pts

Table Creation Document   25pts

Total   100pts

Deductions

Exact Same Code/Documents as Another Student   -10pts per infraction or 0 on assignment

Word Documents Not Named Correctly   -5pts per document

Incorrect database name used   -10pts

Formatting changed in Word Documents -10pts per document

Using your own Word Document instead of the one provided   No points for docs

Database Backup/Word document Incorrect/Unreadable -100pts

b) Using the financial information above, provide analytical calculations (supported by formulae and figures) for the purpose of reviewing the financial performance and the financial position of Magnificent Homeware Ltd. Your focus should be to highlight matters of significant concern and trends that appear unusual.  


c) From the analysis in (b) above, what are the audit risk factors for inventory and accounts receivable?

d) How would the financial statement analysis in (b) above assist to plan your audit approach for Magnificent Homeware Ltd?

e) From the information above (excluding the financial statements) list the potential problem areas and any major concerns (where there could be risk or material misstatement) that you will need to consider as part of the plan for the 2018 audit for this company. You must provide brief reasons why each of the areas you have listed require special consideration. You should be able to comment on at least 10 areas.

Project Selection

Your company is prepared to undertake several new projects over the next five years. Each Division has submitted a number of project proposals that include the annual budgets and anticipated profit. Your company’s annual budgets for the next five years are as follows. (Amounts are X$1000)

The project proposals (for a total of fifteen possible projects) are as follows:

What project selection should your company choose? (You decide what criterion to use, but recall that this Business school.)

Please show/explain using excel solver