Part A

The table below lists customer/car hires data. Each customer may hire cars from various outlets throughout Singapore. A car is registered at a particular outlet and can be hired out to a customer on a given date.

Instructions:

1. The data in the table is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
2. Describe and illustrate the process of normalization by converting Table 1 to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations.

Part B

The following tables form part of a database held in a Relational Database Management System for a printing company that handles printing jobs for book publishers:

Publisher                        (pubID, pubName, street, city, postcode, telNo, creditCode)

              BookJob                          (jobID, pubID, jobDate, description, jobType)

              PurchaseOrder               (jobID, poID, poDate)

              POItem                            (jobID, poID, itemID, quantity)

              Item                                  (itemID, description, onHand, price)

Where:

Publisher                          contains publisher details and pubID is the key.

BookJob                            contains details of the printing jobs (books or part books) and jobID is the key.

PurchaseOrder                 A printing job requires the use of materials, such as paper and ink, which are assigned to a job via purchase orders. This table contains details of the purchase orders for each job and the key is jobID/poID. Each printing job may have several purchase orders assigned to it.

POItem                              Each purchase order (PO) may contain several PO items. This table contains details of the PO items and jobID/poID/itemID form the key.

Item                                   contains details of the materials which appear in POItem, and the key is itemID.

Instructions:

Formulate the following queries using SQL:

(i)                         List all publishers in alphabetical order of name.

(ii)                        List all printing jobs for the publisher ‘Gold Press’.

(iii)                      List the names and phone numbers of all publisher who have a rush job (jobType = ‘R’).

(iv)                       List the dates of all the purchase orders for the publisher ‘PressMan’.

(v)                        How many publisher fall into each credit code category?

(vi)                       List all job type’s with at least three printing jobs.

(vii)                     List the average price of all items.

(viii) List all items with a price below the average price of an item.

Questions;

The futures market is referred to as an auction market, whereby producers and suppliers of commodities endeavour to avoid market volatility; in other words, producers and suppliers negotiate contracts with an investor who agrees to take on probable risk and reward, based on the expected volatility of the market.

Question 1

Critically discuss the theoretical concept of futures contracts as a risk management tool, used by any would be investor to decrease future risk exposure or market volatility. . Please state references and use APA Citations lastest version

You have just been appointed to the post of Surgeon General of the United States. The President wants you to develop an advertising campaign called, “A healthy America by the year 2021” that encourages Americans to lead a healthier lifestyle.

What types of behaviors would you try to influence? Why? And how would you influence these behaviors?

Feel free to conduct an online search on the topic to collect materials for your answer. Provide those citations in your answer and articulate your argument with facts rather than emotion.

Design a lesson plan for your school (or workplace) that teaches students (or employees) about different cultures. At a minimum, include the following categories in your lesson plan: Objectives, Procedures, Reading Assignments, Materials, and Assessment. In addition, attach an assessment that you will use to determine if the students (or employees) learned from your lesson. There is a lesson plan template you may use located in course resources. Your lesson plan must be entirely original. Please provide title page, citations, and reference page for this assignment.

Staying informed is a crucial activity for any financial professional. Each week you will research two current articles, from two separate sources, that examines a topic/trend/analysis related to the current credit market. Write a two-paragraph response with one paragraph that summarizes the articles and one paragraph that synthesis the correlation between the two. Posting guidelines:

Include proper citations using the MLA format.

Write or copy/paste from a word document into the Journal area provided. DO NOT ATTACH A WORD DOCUMENT.

The following submission rules apply:

·    For those questions requiring programs, the solutions must be implemented using JavaScript or Java.

o Appropriate self-documenting comments in the source code are mandatory, consistent with good programming practices.

o Solutions must be provided in plain text so that formatting is not lost.

·    All answers must be provided in this document.

·    Sources must be given accurate and complete citations sufficient for the instructor to find and confirm them.

Does the Principle of Optimality hold for coin changing? Discuss with various interpretations of the Combine function.