The tbl_employee contains information about the employee and its department, and it contains the following fields (it is possible to also include other missing fields): employee_id, employee_gender ,employee_salary, employee_annual_sallary, department_name, department_location, department head.

Make use of the database normalization skills learned to normalize a database to the third normalization form. Organize the columns and tables to reduce data redundancy and arrange attributes based on the relationships.

• Provide a screen shot of the database design before the normalization. Create a heading titled “Database Before Normalization.”
• Provide a screen shot of the database design after the normalization. Create a heading titled “Database After Normalization.”
• In more than 400 words, describe the three normalization forms and the guidelines for transforming from lower normal forms to higher normal forms.

A few years ago, Blockbuster was the dominant competitor in video rentals, but today the company has gone through bankruptcy and is a fraction of its former size. Imagine that Blockbuster had initiated a business intelligence database project 10 years ago to help executives foresee and deal with coming challenges. How might Blockbuster have carried out such a project, and how could it have helped the company?

To begin, consider the first step in the database life cycle, the database initial study. How would you have done a database initial study for a business intelligence database at Blockbuster 10 years ago? What was the company’s situation, and what problems and constraints did the company face? How would you have defined the objectives, scope, and boundaries for a business intelligence database at Blockbuster?

Part 1: Terminology
In your own words, define/describe what each of these terms means in a database context. Do not attempt to copy specific sentences from the video word for word. Examples to support definitions and descriptions are welcome, but are insufficient on their own. You should establish that you understand the significance of each term.
1. Database Functionality:

a. Massive

b. Persistent

c. Safe

d. Multi-user

e. Convenient

f. Efficient

g. Reliable

  
2. database concepts:

a. data model

b. schema vs. data

3. purpose of languages associated with a database:

a. data definition language

b. data manipulation language

c. query language

4. database-related jobs:

a. DBMS implementer

b. designer

c. application developer

d. database administrator

The following selected transactions relate to investment activities of Ornamental Insulation Corporation during 2018. The company buys debt securities, not intending to profit from short-term differences in price and not necessarily to hold debt securities to maturity, but to have them available for sale when circumstances warrant. Ornamental’s fiscal year ends on December 31. No investments were held by Ornamental on December 31, 2017. Mar. 31 Acquired 8% Distribution Transformers Corporation bonds costing $570,000 at face value. Sep. 1 Acquired $1,155,000 of American Instruments’ 10% bonds at face value. Sep. 30 Received semiannual interest payment on the Distribution Transformers bonds. Oct. 2 Sold the Distribution Transformers bonds for $612,000. Nov. 1 Purchased $1,570,000 of M&D Corporation 6% bonds costing at face value. Dec. 31 Recorded any necessary adjusting entry(s) relating to the investments. The market prices of the investments are: American Instruments bonds $ 1,088,000 M&D Corporation bonds $ 1,649,000 (Hint: Interest must be accrued.) Required: 1. Prepare the appropriate journal entry for each transaction or event during 2018, as well as any adjusting entries necessary at year end. For any sales, prepare entries to update the fair-value adjustment, record any reclassification adjustment, and record the sale. 2. Indicate any amounts that Ornamental Insulation would report in its 2018 income statement, 2018 statement of comprehensive income, and 12/31/2018 balance sheet as a result of these investments.

The following selected transactions relate to investment activities of Ornamental Insulation Corporation during 2018. The company buys debt securities, not intending to profit from short-term differences in price and not necessarily to hold debt securities to maturity, but to have them available for sale when circumstances warrant. Ornamental’s fiscal year ends on December 31. No investments were held by Ornamental on December 31, 2017. Mar. 31 Acquired 6% Distribution Transformers Corporation bonds costing $430,000 at face value. Sep. 1 Acquired $945,000 of American Instruments’ 8% bonds at face value. Sep. 30 Received semiannual interest payment on the Distribution Transformers bonds. Oct. 2 Sold the Distribution Transformers bonds for $458,000. Nov. 1 Purchased $1,410,000 of M&D Corporation 4% bonds costing at face value. Dec. 31 Recorded any necessary adjusting entry(s) relating to the investments. The market prices of the investments are: American Instruments bonds $ 892,000 M&D Corporation bonds $ 1,493,000 (Hint: Interest must be accrued.) Required: 1. Prepare the appropriate journal entry for each transaction or event during 2018, as well as any adjusting entries necessary at year end. For any sales, prepare entries to update the fair-value adjustment, record any reclassification adjustment, and record the sale. 2. Indicate any amounts that Ornamental Insulation would report in its 2018 income statement, 2018 statement of comprehensive income, and 12/31/2018 balance sheet as a result of these investments.

The following selected transactions relate to investment activities of Ornamental Insulation Corporation during 2018. The company buys debt securities, not intending to profit from short-term differences in price and not necessarily to hold debt securities to maturity, but to have them available for sale when circumstances warrant. Ornamental’s fiscal year ends on December 31. No investments were held by Ornamental on December 31, 2017.

Mar. 31 Acquired 5% Distribution Transformers Corporation bonds costing $600,000 at face value.

Sep. 1 Acquired $1,200,000 of American Instruments’ 7% bonds at face value.

Sep. 30 Received semiannual interest payment on the Distribution Transformers bonds.

Oct. 2 Sold the Distribution Transformers bonds for $645,000.

Nov. 1 Purchased $1,600,000 of M&D Corporation 3% bonds costing at face value.

Dec. 31 Recorded any necessary adjusting entry(s) relating to the investments.

The market prices of the investments are: American Instruments bonds $ 1,130,000

M&D Corporation bonds $ 1,680,000

(Hint: Interest must be accrued.)

Required: 1. Prepare the appropriate journal entry for each transaction or event during 2018, as well as any adjusting entries necessary at year end. For any sales, prepare entries to update the fair-value adjustment, record any reclassification adjustment, and record the sale. 2. Indicate any amounts that Ornamental Insulation would report in its 2018 income statement, 2018 statement of comprehensive income, and 12/31/2018 balance sheet as a result of these investments.

The following selected transactions relate to investment activities of Ornamental Insulation Corporation during 2018. The company buys debt securities, not intending to profit from short-term differences in price and not necessarily to hold debt securities to maturity, but to have them available for sale when circumstances warrant. Ornamental’s fiscal year ends on December 31. No investments were held by Ornamental on December 31, 2017.

(Hint: Interest must be accrued.)

Required:
1. Prepare the appropriate journal entry for each transaction or event during 2018, as well as any adjusting entries necessary at year end. For any sales, prepare entries to update the fair-value adjustment, record any reclassification adjustment, and record the sale.
2. Indicate any amounts that Ornamental Insulation would report in its 2018 income statement, 2018 statement of comprehensive income, and 12/31/2018 balance sheet as a result of these investments.

I need help with the journal entries

The following selected transactions relate to investment activities of Ornamental Insulation Corporation during 2018. The company buys debt securities, not intending to profit from short-term differences in price and not necessarily to hold debt securities to maturity, but to have them available for sale when circumstances warrant. Ornamental’s fiscal year ends on December 31. No investments were held by Ornamental on December 31, 2017.

Mar. 31 Acquired 6% Distribution Transformers Corporation bonds costing $500,000 at face value.

Sep. 1 Acquired $1,050,000 of American Instruments’ 8% bonds at face value.

Sep. 30 Received semiannual interest payment on the Distribution Transformers bonds.

Oct. 2 Sold the Distribution Transformers bonds for $535,000.

Nov. 1 Purchased $1,500,000 of M&D Corporation 4% bonds costing at face value.

Dec. 31 Recorded any necessary adjusting entry(s) relating to the investments. The market prices of the investments are: American Instruments bonds $ 990,000 M&D Corporation bonds $ 1,570,000 (Hint: Interest must be accrued.)

Required: 1. Prepare the appropriate journal entry for each transaction or event during 2018, as well as any adjusting entries necessary at year end. For any sales, prepare entries to update the fair-value adjustment, record any reclassification adjustment, and record the sale.

2. Indicate any amounts that Ornamental Insulation would report in its 2018 income statement, 2018 statement of comprehensive income, and 12/31/2018 balance sheet as a result of these investments.

The following selected transactions relate to investment activities of Ornamental Insulation Corporation during 2018. The company buys debt securities, not intending to profit from short-term differences in price and not necessarily to hold debt securities to maturity, but to have them available for sale when circumstances warrant. Ornamental’s fiscal year ends on December 31. No investments were held by Ornamental on December 31, 2017.

(Hint: Interest must be accrued.)

Required:
1. Prepare the appropriate journal entry for each transaction or event during 2018, as well as any adjusting entries necessary at year end. For any sales, prepare entries to update the fair-value adjustment, record any reclassification adjustment, and record the sale.
2. Indicate any amounts that Ornamental Insulation would report in its 2018 income statement, 2018 statement of comprehensive income, and 12/31/2018 balance sheet as a result of these investments.