🏷️ LIMITED TIME OFFER: GET 20% OFF GRADE+ YEARLY SUBSCRIPTION →
Log in
HomeClass Notes1,200,000CA670,000

HSS 1101 Lecture Notes - Esophageal Cancer, Canada Health Act, Essential Amino Acid

22 views19 pages
School
University of Ottawa
Department
Health Sciences
Course
HSS 1101
Professor

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

Definition: life enhancing resources, such as food supply, housing, economic and social relationships, transportation, education and health care, whose distribution across populations effectively determines length and quality of life. Community: a group of people with a shared identity including: living in the same area, having some level of social interaction, sharing a sense of belonging, or having common political or social responsibilities. Reach (racial and ethnic approaches to community health): communities focus on race, ethnicity, and culture: health equity. The opportunity for everyone to attain his or her full health potential. No one is disadvantaged from achieving this potential because of his or her social position or other socially determined circumstance. Distinct from health equality. (giving enough to each person so they can achieve their potential, give people what they need based on their differences. ) Making sure you receive what you need, not just distributing it equally among people.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

HSS 1101
Final Exam
Study Guide
HSS 1101 Study Guide - Final Guide: Icu Scoring Systems, Health Human Resources, Eye Movement In Reading
crimsondinosaur587
HSS 1101 Lecture Notes - Lecture 1: Brainpower, Population Health, Global Health
pearworm25
HSS 1101 Lecture Notes - Lecture 1: Safe Sex, Hans Selye, Neoliberalism
indigomoose336

Related Questions

CASE STUDY
DIVESTITURE IMPLEMENTATION COMMITTEE (DIC) PROJECT
The Divestiture Process
a. Listing of SOEs to be divested
The Government of Ghana provides the Divestiture Implementation Committee (DIC) with a list of enterprises slated for divestiture. DIC opens a file for each such company. All documentation and correspondence prepared or received in
2
connection with the enterprise is placed on this file.
Enterprises listed for divestiture are categorized by the Ministry of Finance (principally on the basis of employee numbers) into small, medium, and large. In most cases, the divestiture of large and medium enterprises is outsourced to consultants. Small enterprises are either outsourced, or divested by DIC.
b. Advertisements
Bid documents are prepared for the particular State Owned Enterprise (SOE), and the SOE is advertised for sale. Adverts should appear in at least 2 leading Ghanaian newspapers each week for 3 consecutive weeks. Adverts may also appear in foreign publications.
c. Bidding
i. Obtaining bid documents
Investors interested in a particular SOE contact the secretariat, and after filling in an application form, paying a non-refundable bid fee (¢1,000 for local investors, and $400 for foreign investors), and signing a confidentiality undertaking, they are provided with the relevant bid documents.
The bid document is made up of
• bid procedures;
• a draft sale and purchase agreement;
• a memorandum containing the profile of the SOE;
• an independent valuation report (¢ 1,000 for local investors, and $300 for foreigners);
• fixed assets valuation report (where sale of assets is the mode of divestiture);
• share valuation report (where sale of shares is the mode of divestiture).
ii. Form of bids
Investors bids should comprise of a qualification statement made up of
1. Details about the bidder, including (as relevant):
a. the bidder's full name, address and contact details;
b. details of the bidder's directors and shareholders;
c. details of the bidder's existing business;
d. financial periods; and
2. The bidder's business plan for the enterprise, including, by way of example:
3
a. plans for the development of the enterprise (with regard to both its rehabilitation and, as relevant, down-sizing of expansion) and the timing of the implementation of those plan;
b. intentions with regard to employment, proposed staff training programmes and proposals for staff participation in the enterprise;
c. marketing approach and initiatives proposed for the enterprise, including export prospects and anticipated opportunities to expand beyond traditional or existing markets;
d. impact on the local community (particularly where the enterprise has traditionally provided social services and/or infrastructure);
e. impact on competition and the regulatory environment; and
f. environment impact;
3. Confirmation that the offer for the assets or, as the case may be, shares of the
enterprise is not subject to any conditions;
a. any important points of principles arising from the draft sale and purchase agreement; and
b. confirmation that the bidder will comply with the bid procedures.
c. The bid procedures must state the requisite contents of the business plan as specifically and clearly as is possible in the circumstances. The details mentioned in 3 above will not be applicable to all enterprises.
4. A price bid.
a. the price offered for the assets or, as the case may be, shares of the enterprise (clearly indicating the proposed currency of payment);
b. if the offer is not on the basis of cash in full on completion, the precise timing of any deferred payments;
c. in the event of deferred payments, details of the security proposed to be given;
d. a detailed explanation of how the bidder intends to finance the acquisition. In the case of an offer made from existing resources, the bidder will be expected to provide written confirmation from its bank or financial adviser that the necessary funds will be available.
In the case of an offer not made from existing resources, the bidder will be expected to provide written confirmation from its arrangers or providers of finance that arrangements have been made, or will be made, to provide the necessary finance; and
5. Confirmation that the bidder has not done, and will not do, at any time any of
the following:
4
a. communicated to a person other than DIC the amount or approximate amount of the price offered (other than in confidence to the bidder's advisers);
b. entered into any arrangement with any other person that he shall refrain from bidding or as to the amount of any price to be offered;
c. offered or agreed to pay or give, or paid or given, any valuable consideration directly or indirectly to any person for doing or having done, or causing or having caused to be done, any act or omission in relation to the price offered by the bidder or any other bid
.
iii. Evaluation of Bids
This is a two stage process:
• evaluation of qualification statements; and
• comparison of price bids.
DIC opens price bids from only bidders whose qualification statements DIC accepts. In the event of equal price bids, preference is given to Ghanaians.
iv. Rejection of bids :
Bids will be rejected on the following grounds:
• received after closing date and time;
• appropriate fee not paid;
• received from person who canvassed DIC member; and
• received from SOE or a body allied to an SOE.
Exceptions under which bids may be accepted include where the assets concerned comprise non-industrial land and buildings, with no on-going business, and the bidding SOE requires additional office accommodation.
d. Negotiations
DIC will write to the winning bidder, and each other bidder, to inform them of the results of the bid.
Negotiations will then start with the winning bidder. Should he fail to satisfy DIC demands, the next highest conforming bidder will be invited to negotiate.
e. Approvals
After DIC Secretariat has agreed the terms of the sale with the winning bidder, the divestiture will be considered by the DIC members.
DIC members, if they are satisfied with the sale, will submit a letter of
5
recommendation to the President's Office for approval.
If either DIC or the President's Office raises concerns concerning the bid, a letter is sent to the bidder and further negotiations may take place.
If the President's Office grants the approval, DIC will send a letter to the bidder inviting him to sign the sale and purchase documentation. The Executive Secretary of DIC will sign on behalf of DIC and the government.
f. Payments
i. Mode of Finance
This could either be with
• investors own resource. or
• loan from a financial institution (DIC may take security over the asset until full payment is received).
In the case of instalments, for some loans, interest is paid on the diminishing balance.
ii. Terms of Payment
Payment could either be
• outright, or
• by instalments.
iii. Payment timing
• payment of less than 50% of the price offered; or
• deferred payment due 3 years after completion.
DIC prefers outright payment, but will consider deferred payment. Deferred considerations should be secured by a guarantee from a bank or other person of sufficient financial standing. If such guarantee is not available, DIC may consider taking security over the assets or, shares of the enterprise until full payment is received.
iv. Interest
Interest on deferred payments is as follows:
• Ghanaians: relevant Ghanaian Treasury Bill Rate
• Non Ghanaians: relevant London Interbank Offer Rate plus 2%.
v. Divestiture Proceeds
This will be paid to the appropriate DIC bank account.
The Proposed System
The Board of Directors of DIC has received funding from Government of Ghana
6
to commission the development of a robust and user-friendly web-based system that DIC will use for its operations.
REQUIRED:

1. Discuss the system development methodology that you would adopt for this project and justify your choice.
2. Construct data flow diagrams (including a context level diagram, a level 0 diagram, and several child diagrams) that show important, representative parts of the Divestiture Implementation Committee (DIC) System.
3. Identify five data files that will be used in the Divestiture Implementation Committee (DIC) System; and construct a comprehensive Data Dictionary for each of the five data files you have identified.
4. Construct use-case diagrams, sequence diagrams, and class diagrams for the proposed Divestiture Implementation Committee (DIC) System.
5. Construct object diagrams, activity diagrams and communication diagrams for the proposed Divestiture Implementation Committee (DIC) System.
6. Design five reports that should be generated from the Divestiture Implementation Committee (DIC) System.
7. Discuss the testing strategies/techniques that you would use on this project; and provide a table of test criteria and corresponding test data for the testing.

SQL Server

TASK

Is you will need to formalize the database design and use a DBMS (SQL Server, MySQL, etc) to build the database. You will NOT be required to build all the functionality as described above as part of this initial project. You will be responsible only for specific parts of the system and implementing specific features as described below. You should complete the following steps:
1. Analyze the data requirements described in the previous section. Decide which tables are required and which fields should go in which table. Normalize your design. If you wish, you may use an entity-relationship diagram. Create a table design showing the relationships between each table.
It is now time for your instructor to check your progress. After you have finished the preliminary design for the High Spirits Imports Management System, contact your instructor for a brief review.
2. Using your DBMS, create an SQL script to create the High Spirits database. Name the database HSxxxxx, where xxxxx is your student number. Save your script as step2.sql.
3. Create the tables in the HighSpirits database. You do not need to specify relationships in this script. Save your script as step3.sql.
4. Create a default database diagram. Add primary keys and relationships where they make sense. Print your diagram. Create a script that will add the necessary primary keys and foreign keys to the appropriate tables. Save your script as step4.sql.
5. Create a script that will create the needed constraints to enforce the data rules Mr. Tipple has specified. Save your script as step5.sql.
6. Using the provided source documents (see pictures 1 - 5 or download pdf file) populate your database with test data. Minimally, you need:

---->>> url for the pdf file


 4 customers (include High Spirits as a customer so you can track purchase transactions).
 5 transactions - at least 3 are sales type, 2 of which must be paid.
 4 countries, types and sizes
 6 products, each with a quantity specified
Save your script as step6.sql
7. Create a script that will show a list of customers (first name, last name, and phone number) and the total number of sales transactions they have made. Save your script as step7.sql. After running the script, save a screen capture of the output and save it as step7-output.jpg

8. Create a script that will show a list of products (product name, type, size) that have been purchased. Note: You must use an outer join for this query; a subquery is not acceptable. Save your script as step8.sql. After running the script, save a screen capture of the output and save it as step8-output.jpg
9. Create a script that will show a list of products (product name, type, size, supplier) that are from Australia. Save your script as step9.sql. After running the script, save a screen capture of the output and save it as step9-output.jpg
10. Create a script that will show a list of products (product name, type, size, customer, retail price, quantity sold). The script should also calculate the sum of the price field and the sum of the quantity sold from all times the products were sold and display it as a calculated field. Do not include purchases (Remember the status field is set to 0 for sales and 1 for purchases). Save your script as step10.sql. After running the script, save a screen capture of the output and save it as step10-output.jpg
11. Using your DBMS Help feature, explore the use of the SHOW command to display the contents of your database. Create a script that will display a list of tables in the database. Save this script as step11a.sql. Then create a script for each of the four main tables (Customers, Transactions, Products, Transaction details that will display all of the columns in the table. Save your scripts as step11b.sql to step11e.sql.
12. Finally, you will need to create the HS_Employees database. Using the data in the HS-Employees.xls spreadsheet, create a script to populate the Employees database with the data found there. Employee ID's should be unique and start with the two employee initials and then increment by a value of 1. It should be the primary key. Social Insurance numbers are unique for each individual. However, this does not make for a good Primary Key. You must ensure that there is not the ability to incorrectly enter someone else's SI number by mistake by making this field unique. Create the employee database and populate the employees table with the data as indicated above. Save your scripts as step12.sql and step12a.sql

8. Write a class called WordSet representing a set of String objects which can contain an arbitrary number of strings, limited only by the memory available to the Java Virtual Machine. A set is a collection of elements, however, unlike a list, a set cannot contain duplicate elements. Therefore, as its name implies, a WordSet object cannot contain duplicate Strings that is, if one attempts to da String to a Wordset, and the wordset already contains an element which is equal to this string, the attempt will fail and the state of the Wordset will not change. All String comparisons performed in the methods defined in the Wordset class are done in a Case SENSITIVE manner. Note that in the method descriptions below, the phrase "this Wordset" means "the Wordset on which the method in question is called." Your Wordset class MUST provide the following INSTANCE methods • A constructor, which takes no parameters and initializes the new Wordset ohject so that it contains no elements • A method called add(), which takes as its only parameter a string and returns a value of type boolean. If this Wordset already contains a string which is equal to the parameter string, or the parameter String is null, then the state of this Wordset does not change and the method return false; otherwise, the parameter String is added to this Wordset. and the method returns true. • A method called remove().which takes as its only parameter a string and returns a value of type boolean. If this wordSet contains a string which is equal to the parameter String this string is removed from the WordSet and the method returns true. On the other hand, if the string parameter is null or this Wordset does not contain a string which is equal to the parameter string, then the state of this wordset does not change, and the method return false. • A method called get.size(), which takes no parameters and returns the number of strings currently stored in this Wordset. This method MUST NOT change the state of this Wordset. • A method called isMember(). which takes as its only parameter a string and retumsa value of type boolean which is true if this wordset contains the parameter String false otherwise. If the parameter String is null, this method also return false. This method MUST NOT change the state of this wordset. • A method called computebirrerence().which takes as its only parameter a Wordset and returns a new Wordset representing the difference between this wordset and the parameter Wordset: in other words, the WordSet returned by this method contains all the strings that are in this wordset, but not in the parameter Wordset. If the parameter Wordset contains all the elements of this WordSet or this WordSet contains no elements, then this method returns a new Wordset containing no elements. Finally, if the parameter Wordset is null or contains ne strings, then this method returns a new wordset which contains all the elements of this wordset. This method MUST NOT change the state of this wordset or the parameter Wordset. • A method called tostring , which takes the parameters and turns a string which is the textual representation of this wordset. This textual representation consists of the concatena tion of the following clements - The String - The text representation of each clement in the WordSet; cach pair of adjacent clements is separated by the String", but this String MUST NOT appear before the first clement or after the last element - The String") The order in which the elements of this Wordset appear in the textual representation generated by the tostring() method does not matter. If the WordSet contains to Brings, then the textual representation returned by this method is ". Note that you MUST respect proper encapsulation practices that is, the attributes and methods of your class MUST be declared using the proper visibility modifier NINT Um an array list (of string) to keep track of the string stored in a wordt ob joot Is there a method defined in the Array loist class which determines whether in clementis already wored in an array ist, and which will do a case-sensitive comparison when liked on an Arraylint of strings? See the pages 24-26 of this examination for information about potentially useful methods defined by the ArrayList class WRITE YOUR Wordset CLASS IN THE SPACE BELOW: