How has the study of trade patterns evolved over time, and in the light of empirical testing of trade models

systematically describe the empirical evidence for/against employing unitary household models to understand households in developing countries

Part 3: Lessee Entries: Capital Lease

On January 1, 2018, Southern, Inc. signed a 10-year non-cancelable lease for a machine. The terms of the lease called for Southern to make annual payments of $17,240 at the beginning of each year, starting January 1, 2018. The machine has an estimated useful life of 12 years.

The machine reverts back to the lessor at the end of the lease term. Southern uses the straight-line method of depreciation for all of its plant assets. Southern’s incremental borrowing rate is 4%, and the Lessor’s implicit rate is unknown.

• Identify and explain the type of lease. Use the blank area in the template following the journal entries to make your notes.
• Compute the present value of the minimum lease payments.

subject DBA

use mysql workbench and select my guitar shop database as default schema

Problem8

Write a script that implements the following design in a database named my_web_db:

    users                                                       downloads                                                                 Products

*user_id INT                                         * download_id INT                                                   * product_id INT                     

*email_address VARCHAR(100)          * user_id INT                                                         * product_name VARCHAR(45)

*first_name VARCHAR(45)                  *download_date DATETIME

*last_name VARCHAR(45)                  * filename VARCHAR(50)

                                                               *product_id INT

Details

• In the downloads table, the user_id and product_id columns are the foreign keys.
• Include a statement to drop the database if it already exists.
• Include statements to create and select the database.
• Include any indexes that you think are necessary.
• Specify the utf8 character set for all tables.
• Specify the InnoDB storage engine for all tables.

Solution fill in the blanks :-

______DATABASE ____________ ;

CREATE DATABASE my_web_db ___________ ;

USE my_web_db;

_________ TABLE _______

    user_id       INT          PRIMARY _______ AUTO_INCREMENT,

    email_address VARCHAR(100) UNIQUE,

    first_name    VARCHAR(45) NOT NULL,

    last_name     VARCHAR(45) NOT NULL

) ___________ ;

__________ products (

    product_id   INT         ________ AUTO_INCREMENT,

    product_name VARCHAR(45) UNIQUE

__________

____________

    download_id   INT         PRIMARY KEY,

    ____________       INT         NOT NULL,

    download_date DATETIME    NOT NULL,

    filename      __________ NOT NULL,

    product_id    INT         NOT NULL,

    ___________ fk_downloads_users

_____________ KEY (user_id )

        REFERENCES users (user_id),

_______________

_______________ product_id)

        REFERENCES products _______________

) ENGINE = _________ ;

The following is the original code,

(add, t1, 3, 5)

(assign, a, t1)

(add, t2, 3, 5)

(sub, t3, t2, z)

(assign, b, t3)

Constant folding is applied to give the following,

(assign, t1, 8)

(assign, a, t1)

(assign, t2, 8)

(sub, t3, t2, z)

(assign, b, t3)

After the constant folding is applied, the (assign, t2, 8) becomes redundant. What optimizations should take place in order to remove this redundancy in the constant folded code? Also show the optimized code.

View the following C# Script carefully. Assume that the Script is enabled, is attached to an active GameObject, and addresses the appropriate namespaces first.

1. Discuss when and how often during the game the Update() function will be executed.
2. Discuss each line (from line 9 to 17, excluding the lines with curly brackets) to detail what the code inside the update function is doing.
   Be sure to outline how the variables are being used during your discussion.

1 public class Player : MonoBehaviour
2 {
3    public GameObject coinPrefab;
4 private GameObject coin;
5    public Transform spawnpoint;
6  
7    void Update()
8    {
9       if (Input.GetMouseButtonDown(0))
10       {
11          Instantiate(coinPrefab, spawnpoint.position, spawnpoint.rotation);
12       }
13       if (Input.GetMouseButtonDown(1))
14       {
15          coin =  GameObject.FindWithTag("Coin");
16          Destroy(coin);
17       }
18    }
19 }

View the following C# Script carefully. Assume that the Script is enabled, is attached to an active GameObject, and addresses the appropriate namespaces first. Discuss when and how often during the game the Update() function will be executed. Discuss each line (from line 9 to 17, excluding the lines with curly brackets) to detail what the code inside the update function is doing. Be sure to outline how the variables are being used during your discussion. 1 public class Player : MonoBehaviour 2 { 3 public GameObject coinPrefab; 4 private GameObject coin; 5 public Transform spawnpoint; 6 7 void Update() 8 { 9 if (Input.GetMouseButtonDown(0)) 10 { 11 Instantiate(coinPrefab, spawnpoint.position, spawnpoint.rotation); 12 } 13 if (Input.GetMouseButtonDown(1)) 14 { 15 coin = GameObject.FindWithTag("Coin"); 16 Destroy(coin); 17 } 18 } 19 }

Normalizing the Relational Model for the Student Project and
Creating a Normalized SQL Database

Patient (patientNo, name, address, phone, dateOfBirth, sex, insuranceCo, policyNo, relationshipToInsured)

Appointment(patientNo, apptdate, appttime, reason, staffNo, visitNo)

Visit(visitNo, patientNo, visitdate, visittime, duration, reason, visitType, visitCost, staffNo, roomNo)

Staff(staffNo, name, title, specialty, address, phone)

Availability(staffNo, availDate, startTime, endTime)

InsurancePolicy (company, policyNo, insuredName, policytype, medicalCoPay, labCoPay, pharmacyCoPay, startDate, endingDate)

DiagnosisMenu(diagCode, diagName)

ProcedureMenu(procCode, procName, cost)

Room(roomNo, roomType, condition)

PrescriptionScript(scriptNo, visitNo, dateWritten, itemPrescribed, quantityPrescribed, directions, numberRefills)

LabTest(testNo, prescriptionNo, testype, testDate, testTime, cost, result)

Diagnosis(visitNo, diagCode, dateOnset, symptons, severity, prognosis)

Referral(refNo, visitNo, refTo, reason)

Bill(invoiceNo, billDate, totalAmount, dueDate, patientNo, amountPaid)

Charge(invoiceNo, serviceType, serviceDate, amountCharged)

Payment(invoiceNo, date, amountPaid, patientPayer, insuranceCoPayer, insurancePolNoPayer)

Task 1:

Begin with the list of the tables that the entities and relationships from the E-R diagram mapped to naturally. For each table on the list, identify the functional dependencies. List the functional dependencies in a Microsoft Word document.

Task 2:

Normalize the relations to BCNF, placing the normalized relations in your Word document.

Task 3:

Then decide whether the resulting tables should be implemented in that form. If not, explain why in your Word document.

Task 4:

For each table, write the table name and write out the names, data types, and sizes of all the data items, Identify any constraints, using the conventions of the DBMS you will use for implementation. Add this information to your Word document.

Task 5:

Write and execute SQL statements to create all the tables needed to implement the design. Note that you will need to name your database something different then the name you previously used.

Task 6:

Create indexes for foreign keys and any other columns that will be used most often for queries.

Task 7:

Insert about five records in each table, preserving all constraints. Put in enough data to demonstrate how the database will function.

Task 8:

Write SQL statements that will process five non-routine requests for information from the database just created. For each, write the request in English, followed by the corresponding SQL command.

Task 9:

Create at least one trigger and write the code for it.

Jabieb corporation issued 3,000 convertible bonds on January 1, 2018. The bonds have a 3-year life and are issued at par with a face value of $1,000 per bond, giving total proceedings of $3,000,000. Interest is payable annually at 6%. Each bond is convertible into 200 ordinary shares (par value $1). The market rate of interest on similar non-convertible debt is 8%

a) Compute the liability and equity component of the convertible bond on January 1, 2018.

b) Assume the bond is converted on January 1, 2019, compute the carrying value of the bond payable on

January 1 2019.

c) Prepare the journal entry to record the conversion on January 1, 2019. .

d) Assume that the bonds were repurchased on January 1, 2019 for $2,900,000 cash instead of being

converted. The net present value of the bonds on January 1, 2019 is $2,850,000. Prepare the journal entry

to show the repurchase on January 1, 2019.

Josh Company had 200,000 ordinary shares outstanding on December 31, 2017. The company issued 20,000 shares on April 1, 2018 and retired 10,000 shares on September 1, 2018. Josh company recorded net income for the year ended December 31, 2018 of $300,000 after a loss on discontinued operations of $35,000 (net of tax).

Discuss the main characteristics (at least 2-3) of the database approach and how it differs from traditional file systems. (5 pts) Give examples of systems in which it may make sense to use traditional file processing instead of a database approach. (these examples may come from your day-to-day use of technology)