Imagine you work for an independent grocery store with 20 employees. The business owner has tasked you with creating a relational database that will track employee names, IDs, positions (e.g., cashier, manager, clerk, or night crew), and salaries.

Create a relational database table in Microsoft® Access® or MySQL® for the grocery store using the attached data points.

Apply the universal rules (unique primary keys, unique column names, no duplicate rows) to your table.

Include all necessary null values.

Display in the table the requested database queries:

• INSERT INTO Account: VALUES (188820, ‘Wendall Glass’, $12/h)
• UPDATE Account: Set salary = $12/h WHERE ID = 128872
• DELETE FROM Account WHERE ID = 244332

Calculate the grocery store’s SUM salary and the AVG salary per position.

Data Points

1. Blanche Dishner – 438927 - Manager - $25/h
2. John Smith - 372991 – Night crew - $17/h
3. Luciano Sloney – 300126 – Night crew - $17/h
4. Dorris Goodsell – 300129 -Cashier - $15/h
5. Sybil Fain – 119325 – Clerk - $11/h
6. Shaun McNeil – 200743 – Cashier - $13/h
7. Olen Wigley – 222345 – Cashier - $14/h
8. Dovie Seawood – 109321 – Clerk - $12/h
9. Magdalen Mullaney – 256921 – Cashier
10. Salena Souza – 185549 – Clerk - $12/h
11. Paige Alvarez - 132943 – Clerk - $11/h
12. Cassy Lundin – 391285 – Night crew
13. Tajuana Stoval - 491621 – Manager – $23/h
14. Joaquina Piasecki – 185392 – Clerk - $13/h
15. Janiece Abelson – 244332 – Cashier - $13/h
16. Rogelio Peppler – 128872 – Clerk - $11/h
17. Fatima Haymaker – 100321 - $13/h
18. Rico Fairbank – 318821 – Night crew - $16/h
19. Trey Peloquin – 488326 – Manager - $24/h
20. Paulene Thibeau – 193931 – Clerk - $12/h

answer the following question for oracle developer:

1- ____ is the category of SQL commands to create, alter or drop SQL objects (create a table, drop a view)

2-____ handles access to objects. The DBA might grant select on Customers to Bob. This will allow user Bob to read the Customers table.

3- Run this query in SQL Developer:

Select sysdate
from dual
What is sysdate? What is dual?

4-What is a surrogate key? How are surrogate keys implemented in Oracle?

5-Which are DML commands?

6- Rules for a table: choose what is best

a- Name should not contain spaces

b- Name must start with an alpha character

c-Must be unique in the schema

d-Must contain a Primary Key

e-Must be unique in the database

f-Must contain at least one column

g-Primary Key must be first column in the database

7- What is First Normal Form (1NF)? What condition would violate 1NF?

8- ____ are SQL commands used to handle data in tables. Typical commands are Select, Update, Insert, Delete and Merge

9-Which are valid DDL commands?

10-A table has two (or more) columns that make up the Primary Key. This is called a(n) ____ key.

11-A column that's nchar(5) takes up ____ bytes of data.

12- Maximum number of columns for an Oracle table is ____ columns

13-Define: null. What is null? What does it mean? How are nulls treated?

14-

Run the following query in SQL Developer:

select to_char(sysdate + 2,'mm/dd hh24:mm')
from dual

What is returned?

Change the query to return the last day of the month (if sysdate is 2/14/2017, return 2/28/2017).

15- One-to-one relationships between two tables in a database are rare. Why? Give me a scenario where 1:1 relationship would be implemented?

Check a number if the Database. Write MIPS assembly code for the following requirements.

Given the following code for the data segment.

.data

Database: .word 1,2,3,4,5,6,7,8,9,10

Ask user to type in a random integer number using syscall #5. Check if this number is within the database or not, print out "number found!" if the number was foudn in the database, print out "No such number found in database!" if not.

On January 1, 2017, QuickPort Company acquired 90 percent of the outstanding voting stock of NetSpeed, Inc., for $855,000 in cash and stock options. At the acquisition date, NetSpeed had common stock of $860,000 and Retained Earnings of $43,000. The acquisition-date fair value of the 10 percent noncontrolling interest was $95,000. QuickPort attributed the $47,000 excess of NetSpeed's fair value over book value to a database with a five-year remaining life.

During the next two years, NetSpeed reported the following:

On July 1, 2017, QuickPort sold communication equipment to NetSpeed for $33,100. The equipment originally cost $37,800 and had accumulated depreciation of $7,100 and an estimated remaining life of three years at the date of the intra-entity transfer.

Compute the equity method balance in QuickPort's Investment in NetSpeed, Inc., account as of December 31, 2018.

Prepare the worksheet adjustments for the December 31, 2018, consolidation of QuickPort and NetSpeed.

Counting Services Inc. has the following portfolio of trading equity securities at 12/31/17. All securities were purchased during 2017.

Symbol # shares Total Cost Market Value

AAPL 1000 $102,000 $107,000

BMX 2000 $47,000 $41,000

GNC 3000 $64,000 $87,000

Total $213,000

• Prepare the adjustment necessary at 12/31/17.

• On February 12, 2018, Counting Services sells 1,000 shares of AAPL for $115,000. Prepare the journal entry.

• The total cost of the two remaining securities is $111,000 and the market value is $130,000 at March 31, 2018. Prepare the adjusting entry.

Please explain work.

As of January 2018, Evite Fashions Co has 5% preferred stock, $100 par value, 25,000 shares issued and outstanding; common stock, $3 par value, 150,000 shares issued and outstanding.

The following dividends were delcared and paid in 2018, 2019 and 2020.

2017 No dividends were declared and paid

2018 25,000

2019 50,000

2020 200,000

2021 850,000

For common stock holders and non-cummulative

a) assuming the preferred stock were non-cummulative, how much dividends did preferred and common stockholders recieve for each year dividends were declared

b) calculate dividend per share for each year.

For common stock holders and cummulative

a) assuming the preferred stock were cummulative, how much dividends did preferred and common stockholders recieve for each year dividends were declared

b) calculate dividend per share for each year

The summarized statement of financial positions of A Ltd and B Ltd as at 31 December 2018 are as follows:

A Ltd purchased the entire share capital of B Ltd on 31 December 2018. The Non-Current Assets of B Ltd are considered to possess a fair value of sh.54,000 but there are no material differences between the book values and fair values of the remaining assets.

Required

1. Calculate the goodwill arising on consolidation
2. Prepare the consolidated statement of financial position of A Ltd and it subsidiary as at 31 December 2018

Note: Ignore depreciation

1) A machine contains 5 components that all need to be functional in order for the equipment to operate. The reliability of the components is .99, .98, .99, .999, and .96, what is the resulting system reliability?

2) If the second and fourth components had redundant components with the same reliabilities what would be the system reliability?

Question 1

Ben Limited has a 31 December year end. Employees work a 5 day week and are entitled to 20 paid working days of vacation per annum.

Employee statistics are as follows:

Number of employees : 50 000

Average annual salary 2017 : 100 000

Unused leave 31 December 2017 : 10 Days

Leave taken in the year ended 31 December 2018 : 14 Days

* S1 and S2 : On average, 9 Earned in 2018, 5 Earned in 2017

* S3 : All earned in 2018

Leave expected to be taken during the year ended 31 December 2019 : 15 Days

* S1 and S2 : On average, 12 Days earned in 2019, 3 Days earned in 2018

* S3 : All days earned in 2019

Additional information :

1. No employees left or joined the company in the past 2 years

2. Salaries increased by 20% from 01 January 2018

3. Past estimates show that management is able to correctly forecast the number of vacation days that will be used in the following financial year.

Required :

Determine the Leave Pay Provision, and Provide the Journal at the 31 December 2018 assuming that :

1.1 Leave accumulates and vests indefinitely

1.2. Leave accumulates for one year after it accrues but is non-vesting

1.3. Leave does not accumulate and is non-vesting

Show all workings and journal entries