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.

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.

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 }

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)

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).

1. Draw a class diagram for a real estate firm that lists property for sale. The following describes the organization:

• The firm has a number of sales offices in several states; location is an attribute of sales office.
• Each sales office is assigned one or more employees. Attributes of employee include employeeID and employeeName. An employee must be assigned to only one sales office.
• For each sales office, there is always one employee assigned to manage that office. An employee may manage only the sales office to which he or she is assigned.
• The firm lists property for sale. Attributes of property include propertyName and location.
• Each unit of property must be listed with one (and only one) of the sales offices.
• A sales office may have any number of properties listed, or may have no properties listed.
• Each unit of property has one or more owners. Attributes of owner are ownerName and address. An owner may own one or more units of property. For each property that an owner owns, an attribute called percentOwned indicates what percentage of the property is owned by the owner.

2. Consider a database schema with a relation EMP whose attributes are as shown below, with types specified for multivalued attributes. (Oracle database for writing SQL)

EMP= (ename, ChildrenSet multiset(Children), SkillSet multiset(Skills))

Children = (name, birthday)

Skills = (type, ExamSet setof(Exams))

Exams = (year, city)

1. Define the above schema in SQL, with appropriate types for each attribute.
2. Using the above schema, write the following queries in SQL.
   1. Find the names of all employees who have a child born on or after January 1, 2000.
   2. Find those employees who took an examination for the skill type “typing” in the city “Dayton”.
   3. List all skill types in the relation EMP.

1. Female labor force participation (LFP) tends to be markedly lower in the MENA region when compared to other world regions. Some scholars have claimed that this phenomenon can be traced to the traditional culture and/or the dominant religion (i.e., Islam) in the region. Others attribute the outcome to the presence large natural resource rents.
   (a)   What is the theoretical argument why natural resource rents may reduce female LFP? Who has present empirical evidence in favor of this hypothesis?
   (b)   Some scholars have argued that rather reducing female LFP, natural resource rents may actually be associated with higher female LFP rates. What are the theoretical arguments and the empirical evidence in favor of this hypothesis?
2. There are many studies that suggest an association between low female LFP some religious affiliations and cultural backgrounds, which may explain the situation in the MENA region. What sort of empirical evidence do these studies produce to support these claims?