Prototyping an Event-Driven IT Application DC Medical Supply, located in Washington, DC is in the industry of medical device sales. Its market share is small compared to the industry leaders, but it hopes to increase its share by becoming more responsive to customer needs. DC Medical Supply would like your help documenting their sales process using an event driven ERP. The following is a description of the sales/collection process of DC Medical Supply. When customers need to order medical devices, they place an order online at DCMedicalSupply.com. When orders are received, a sales representative records the order to update the Sales Order Transaction file and prints two copies of a formal sales order and one copy of a stock release document. The sales representative staples one copy of the sales order to the stock release and sends it to the warehouse department. The other copy of the sales order is filed numerically in the sales department. If part of an order is out of stock, it will be picked when it is available. A warehouse employee receives the stock release and sales order and picks and scans the goods using a handheld scanner to update the Pick Transaction file. The warehouse employee forwards the goods, the stock release and order document to the shipping department. A shipping clerk proceeds to update the Shipment Transaction file and prints the packing list and three copies of the shipping notice. The shipping companies arrive every day at 4:30 PM, and a shipping clerk gives them the packing slip, the original shipping notice and the devices to be shipped. The stock release, a copy of the shipping notice, and the sales order are stapled together and sent to the billing department. The last copy of the shipping notice is filed numerically in Shipping. The Billing Department receives the order, stock release and shipping notice, prepares the invoice, emails it to the customer and saves an electronic copy of it in the department. Once the invoice has been sent, a billing clerk sends the sales order, stock release, and shipping notice to the accounts receivable department. At the end of each month, the accounts receivable department emails customers with balances owing. DC Medical Supply accepts installment payments in some cases. The cash receipts clerk receives the checks and updates the cash receipts transaction file. The controller prepares a deposit slip and deposits the checks at the local bank branch. Customers have 30 days to return devices to DC Medical Supply warehouse. Required: (Turn in two pieces of paper, unstapled, with your name on the top of each page.) 1. Conceptual model: Draw an REA model with cardinalities for the operating events in the sales/collection process described above (do not model the production of the baked items). Make sure you differentiate between the operating and the information events. The REA model can be hand-drawn, but neatness is required. 2. Logical model: List each database table required (master and event tables), complete with key attributes (primary keys), foreign keys, and non-key attributes. Use proper notation as described in class. This part of the requirement needs to be typewritten.

NOTE: If the default database date format for the Oracle Server you are using does not show a four digit date you can issue a command to change the default to something you prefer. Examples:

alter session set nls_date_format ='DD-MON-YYYY';

alter session set nls_date_format ='Month DD, YYYY';

1. Create a logical view of your presidents table named ModernPresidents that shows all of the presidents since the end of World War II. Harry Truman was the president at that time so you can start with him.   In your view please show these columns:

PRESNUM

NAME

TOOKOFFICE

LEFTOFFICE

DAYSINOFFICE (the number of days they were in office)

Specify that the order of the table should be PRESNUM ascending

Hint: If you subtract one date from another what is returned is the number of days between those two dates.

2. Create a view name PresidentStates that has two columns: The name of every state in the presidents table and the number of presidents that have been from that state. Name that column NUMPRESIDENTS and have the rows in your view in order from the state with the most presidents to the state with the fewest presidents. So that the number of presidents in each state doesn’t have to be computed over and over again every time someone uses this view make it a materialized view. Since updates to this table will not be very frequent make any update of the materialized view a full update and have it happen whenever a change to the presidents table is committed.    You can test if your MV works by change a presidents home state, looking at your view, and then change the state back again.

Understanding Operating Systems

It seems, in this tough economy, people are resorting to borrowing books and DVDs from the library rather than buying or renting from stores.  Your library continues to thrive.  You have expanded and added staff - besides you, you now have two library assistants, Peter and Jane.  Peter is assigned to receive returned books, DVDs, and magazines, while Jane is in charge of lending out books and items.

As you only have a finite amount of titles to lend, you have also instituted a "Wait List" for your borrowers.  If the book or DVD they're borrowing is not available, they will be put on the "waitlist".  Note that for everyone's title, there could only be ONE borrower on the "waitlist" at a time.

Being new to your library, you must devise a system for Jane and Peter to follow so that:

i) Jane can check the "waitlist" when someone is borrowing

ii) Peter can update the "waitlist" when a book is returned

iii) If the book recently returned is immediately borrowed on the same day, Jane should be able to come to Peter to get the book and update the "waitlist" herself.  Otherwise, Peter, at the end of the day, should put it back on the shelf.

iv) Jane and Peter can generate a report summarizing the titles borrowed and returned that day.

The key here is Jane and Peter should be synchronized in what they are going to do.  Device a solution (an algorithm, pen-and-paper approach, or series of steps) to enable this new process. Software is not a solution (ie - use an SQL database or a third-party program). Apply methodologies such as test-and-set, Wait-and-signal, and semaphores to assist you in synchronization.

5. When selecting colors for slide presentation, which action will enhance readability? A. Using smooth contrast in colors to assist color blind viewers

   B. Choosing the color purple will create a sense of passion
   C. Applying black on red makes an object appear closer
   D. Selecting colors on opposite side of the color wheel improves visualization

6. A nurse is creating a slide presentation and is using a predesigned combination of colors, font style, size, and position of place keepers. The nurse is using a:

   A. Lecture support model. B. Content layer.
   C. Layout layer.
   D. Theme.

7. A nurse is deciding about whether to create a spreadsheet or a table to present information. The nurse would most likely use a table for which information?

   A. Listing benefits and limitations of breast-feeding

B. Monitoring for medication errors
C. Calculating length of stays of surgical clients
D. Documenting quality improvement of client care

10. A new nurse is learning how to use a spreadsheet and how it differs from word processing. Which action would the nurse most likely identify as specific to spreadsheets?

    A. Features used in spreadsheets are different.
    B. Programs are bundled with other office software. C. Formula functions are built into the menu options. D. Windows are used but icons are not.

11. A nurse is reading a journal article about information literacy and health literacy and how it connects with critical thinking. Which strategy would the nurse most likely find as a key aspect of critical thinking?

    A. Focusing on a single approach for problem solving
    B. Using a set of skills for processing and generating information C. Providing specific answers to questions D. Setting boundaries for seeking information

12. A nurse is a student in a doctoral program in nursing practice. The major focus of this program for a nurse being prepared at this level would be to:

    A. Conduct nursing research.
    B. Evaluate research findings.
    C. Use findings to develop evidence-based practice guidelines.D. Use research findings in clinical practice.

13. A nurse is working to develop information technology skills. The nurse demonstrates current skills when he or she is able to:

    A. Use searching tools.
    B. Understand computer networks.
    C. Think abstractly.
    D. Manipulate information into something new.

14. When evaluating a website for health information, which question would be important for the nurse to ask to determine the validity of the information?

    A. Is the site a for-profit or not-for-profit site?
    B. Is the date of the site's last update clearly specified? C. Who is the author and what are his or her credentials? D. Are there any potential conflicts of interest?

15. A nurse is evaluating the information obtained from a search and notes that the majority of information is from reports of expert committees. The nurse interprets this research to be at which level of evidence?

    A. Level VII B. Level VI C. Level V D. Level IV

16. When searching PubMed, the nurse understands that this database uses a search term structure:

    A. Based on linear relationship.
    B. Using a feedback loop.
    C. Employing a hierarchy.
    D. Involving a specific to general search.

17. A nurse is using a mobile device and stores his calendar, contacts, and notes. The nurse understands that this information is stored at which location?

    A. ROM
    B. RAM
    C. Flash memory
    D. Compact flash card

18. A nurse is preparing to do research about heart disease and women using a handheld device. Which uses would be appropriate? Select all that apply.

    A. Participating in web-based research surveys B. Storing data for aggregation and analysis C. Recording comments from a focus group

D. Taking photos of changes in status with a treatment E. Searching for evidence-based resources

19. A group of nurses are creating a database. Which step would the nurses need to do first? A. Determine the data to be collected.

    B. Identify the question needing an answer. C. Develop a purpose for the database.
    D. Identify the pieces of data to enter.

20. When working with a database, a nurse selects data from a set of items that was created to avoid having to type in the entry. The nurse is using a:

    A. Field.
    B. Relational database. C. Look-up table.
    D. Query.

21. A nurse wants to find information about databases specifically used in nursing. Which query would the nurse use to obtain the narrowest search?

    A. Databases or nursing
    B. Nursing not databases
    C. Nursing and/or databases D. Nursing and databases

22. A nurse is preparing to create a database. Which aspect would the nurse identify as being the foundation for the database?

    A. Table B. Query C. Form D. Report

23. Various barriers to the adoption of evidence-based practice have been identified. Which would be considered a personal barrier? Select all that apply.

A. Inadequate numbers of staff to participate
B. Difficulty in understanding research statistics C. Lack of information literacy skills
D. Inaccessibility of resources for searching
E. Perception of unrealistic use of research

24. When developing a presentation for the unit staff, a nurse manager uses a free personal reference manager. Which actions would the nurse manager be able to take? Select all that apply.

    A. Save citations
    B. Take notes
    C. Create reference lists
    D. Hyperlink to files
    E. Store information on the Cloud

25. A nurse is using the Cochrane Library to search for systematic reviews about treatment for hypertension. The nurse understands that systematic reviews help to reduce bias. When reading the review, the nurse notes that the review covers a wide range of databases and search terms. The nurse identifies this as reducing which bias?

    A. Selection B. Indexing C. Publishing D. Sampling

5. When selecting colors for slide presentation, which action will enhance readability? A. Using smooth contrast in colors to assist color blind viewers

   B. Choosing the color purple will create a sense of passion
   C. Applying black on red makes an object appear closer
   D. Selecting colors on opposite side of the color wheel improves visualization

6. A nurse is creating a slide presentation and is using a predesigned combination of colors, font style, size, and position of place keepers. The nurse is using a:

   A. Lecture support model. B. Content layer.
   C. Layout layer.
   D. Theme.

7. A nurse is deciding about whether to create a spreadsheet or a table to present information. The nurse would most likely use a table for which information?

   A. Listing benefits and limitations of breast-feeding

B. Monitoring for medication errors
C. Calculating length of stays of surgical clients
D. Documenting quality improvement of client care

10. A new nurse is learning how to use a spreadsheet and how it differs from word processing. Which action would the nurse most likely identify as specific to spreadsheets?

    A. Features used in spreadsheets are different.
    B. Programs are bundled with other office software. C. Formula functions are built into the menu options. D. Windows are used but icons are not.

11. A nurse is reading a journal article about information literacy and health literacy and how it connects with critical thinking. Which strategy would the nurse most likely find as a key aspect of critical thinking?

    A. Focusing on a single approach for problem solving
    B. Using a set of skills for processing and generating information C. Providing specific answers to questions D. Setting boundaries for seeking information

12. A nurse is a student in a doctoral program in nursing practice. The major focus of this program for a nurse being prepared at this level would be to:

    A. Conduct nursing research.
    B. Evaluate research findings.
    C. Use findings to develop evidence-based practice guidelines.D. Use research findings in clinical practice.

13. A nurse is working to develop information technology skills. The nurse demonstrates current skills when he or she is able to:

    A. Use searching tools.
    B. Understand computer networks.
    C. Think abstractly.
    D. Manipulate information into something new.

14. When evaluating a website for health information, which question would be important for the nurse to ask to determine the validity of the information?

    A. Is the site a for-profit or not-for-profit site?
    B. Is the date of the site's last update clearly specified? C. Who is the author and what are his or her credentials? D. Are there any potential conflicts of interest?

15. A nurse is evaluating the information obtained from a search and notes that the majority of information is from reports of expert committees. The nurse interprets this research to be at which level of evidence?

    A. Level VII B. Level VI C. Level V D. Level IV

16. When searching PubMed, the nurse understands that this database uses a search term structure:

    A. Based on linear relationship.
    B. Using a feedback loop.
    C. Employing a hierarchy.
    D. Involving a specific to general search.

17. A nurse is using a mobile device and stores his calendar, contacts, and notes. The nurse understands that this information is stored at which location?

    A. ROM
    B. RAM
    C. Flash memory
    D. Compact flash card

18. A nurse is preparing to do research about heart disease and women using a handheld device. Which uses would be appropriate? Select all that apply.

    A. Participating in web-based research surveys B. Storing data for aggregation and analysis C. Recording comments from a focus group

D. Taking photos of changes in status with a treatment E. Searching for evidence-based resources

19. A group of nurses are creating a database. Which step would the nurses need to do first? A. Determine the data to be collected.

    B. Identify the question needing an answer. C. Develop a purpose for the database.
    D. Identify the pieces of data to enter.

20. When working with a database, a nurse selects data from a set of items that was created to avoid having to type in the entry. The nurse is using a:

    A. Field.
    B. Relational database. C. Look-up table.
    D. Query.

21. A nurse wants to find information about databases specifically used in nursing. Which query would the nurse use to obtain the narrowest search?

    A. Databases or nursing
    B. Nursing not databases
    C. Nursing and/or databases D. Nursing and databases

22. A nurse is preparing to create a database. Which aspect would the nurse identify as being the foundation for the database?

    A. Table B. Query C. Form D. Report

23. Various barriers to the adoption of evidence-based practice have been identified. Which would be considered a personal barrier? Select all that apply.

A. Inadequate numbers of staff to participate
B. Difficulty in understanding research statistics C. Lack of information literacy skills
D. Inaccessibility of resources for searching
E. Perception of unrealistic use of research

24. When developing a presentation for the unit staff, a nurse manager uses a free personal reference manager. Which actions would the nurse manager be able to take? Select all that apply.

    A. Save citations
    B. Take notes
    C. Create reference lists
    D. Hyperlink to files
    E. Store information on the Cloud

25. A nurse is using the Cochrane Library to search for systematic reviews about treatment for hypertension. The nurse understands that systematic reviews help to reduce bias. When reading the review, the nurse notes that the review covers a wide range of databases and search terms. The nurse identifies this as reducing which bias?

    A. Selection B. Indexing C. Publishing D. Sampling

R.Kelly Company Incorporation condensed income statement for the year 2018 and 2017

2018 2017

$ $

Net Sales 6984.2 6762.1

Cost of goods sold 3325.1 3282.6

Gross profit 3659.1 3479.5

Selling and administrative expenses 2585.7 2513.9

Non- recurring charges 244.6 70.5

Income from operations 828.8 895.1

Interest expenses 118.8 895.1

Other income(expenses) (173.3) 6.9

Income before tax 536.7 782.5

Income tax expenses 198.4 279.9

Net Income 338.3 502.6

Required: Compute the ratios for R.Kelly for 2018 and 2017 and discuss your findings.

whats the purpose of the following:

source data structure

source database object metadata

an Oracle Database Module

SQL Server Database ODBC Model

Warehouse Builder ODBC module for SQL Server

~~~USING C# ONLY~~~

Create a console application

Design a class named Person with properties for holding a person’s name, address, and telephone number.

Design a class named Customer, which is derived from the Person class. The Customer class should have the variables and properties for the customer number, customer email, a spentAmount of the customer’s purchases, and a Boolean variable indicating whether the customer wishes to be on a mailing list. It also includes a function named calcAmount that calculates the spentAmount.

All retail store has a preferred customer plan where customers can earn discounts on all their purchases. The amount of a customer’s discount is determined by the amount of the customer’s cumulative purchases in the store as follows:

• When a preferred customer spends $500, he or she gets a 5% discount on all future purchases.
• When a preferred customer spends $1000, he or she gets a 6% discount on all future purchases.
• When a preferred customer spends $1500, he or she gets an 8% discount on all future purchases.
• When a preferred customer spends $2000, he or she gets a 10% discount on all future purchases.

Design a class named PreferredCustomer, which is derived from the Customer class. The PreferredCustomer class should have a variable, discountLevel, with a read-only property. It alsoincludes a setDiscountLevel function that determine the discount level based on the purchases amount using switch statement and an override function, calcAmount, calculates the spentAmount with the current discount level.

Create a CustomerDemo class. In the main function, the program calls the getData function to read the data from the “CustomerInfo.txt” file and create a dynamic array of PreferredCustomer object. Then, it prompts user to enter a customer number and displays a menu:

1. Display Customer Information: display the specific customer information
2. Update Spent Amount: update the total amount with the correct discount level

After update the spent Amount, the program writes the updated information back to file.