Assignment 2 

Create an order menu as following. 

1. Filet-O-Fish…………………………………$2.00

2. McDouble……………………………………$3.50

3. Big Mac…………………………………….…$3.99

4. Cheeseburger……………………………….$2.99

5. McChicken…………………………………..$3.00

6. Soft Drinks…………………………………..$1.00

7. 1% Milk…………………………………….…$1.50

8. Premium Tea……………………………..…$1.00 

————————————————— 

Prompt a user to choose an item from the order menu, also ask the user how many of

the chosen item he/she wants. Then the program will generate a receipt. 

e.g. Filet-O-Fish x 2……………………………..$4.00 (@$2.00) 

       Sub-total………………………………………$4.00 

       HST 13%………………………………………….$0.52 

       Total…………………………………………….$4.52 

Company Profile

Across the States Bank (ASB) takes pride in providing our customers with superior service and the ability to manage their finances 24/7 from anywhere in the world. As one of America’s largest banks, our 132,500 employees are available to address personal and business banking customer needs any time of the day or night by phone, e-mail, or through our online chat feature. Our seamless online and mobile banking and 24-hour customer support ensure that your money management needs can always be met.

Based in Metropolis, California, ASB offers over 17,000 branch offices and ATMs to service customers across the continental United States. When traveling abroad, ASB customers can easily access accounts and complete routine banking transactions in most European nations through our foreign partner, Across the EU Bank. Always looking for means of expanding our $10 billion business, we are developing additional foreign partnerships that will soon allow us to expand our services to South America and Asia to better meet our customer needs.

Products and Services

Personal Banking

As one of the nation’s leading personal banking service providers, ASB allows individuals to select from a wide range of banking services, including:

• Savings and checking accounts
• Debit and credit cards
• Personal and automobile loans
• Home loans, including first mortgages, home equity, and lines of credit
• Insurance
• Investment banking services
• Wealth management and estate services

Business and Commercial Banking

To meet the diverse needs of business and commercial customers, ASB offers individually selected and bundled services, including:

• Business savings and checking accounts
• Business loans
• Merchant services
• Payroll services
• Insurance
• Investment banking
• Trust services
• Shareowner services

QUESTION

Organizations will task security administrators, human resources, the legal department, and other departments to develop appropriate security policies to enhance the control, monitoring, and protection of intellectual property. Some of this protection comes from liability from a legal perspective, privilege access from a human resource protection perspective, or simply data management from a security perspective.

This assignment will guide you through the development of a comprehensive security policy that sets guidelines for the protection of information systems from malicious activity. Review Chapter 4 of the course text, and research various templates online to identify how organizations generate clear and concise policies that are used to create the standards, guidelines, and procedures throughout the enterprise infrastructure. Using the same fictitious organization selected in Topic 1, develop a three to four-page Information Systems Security Policy that includes the following:

1. A cover page with company logo (I will add the logo myself) 

1. A table of contents (TOC)

1. A revision page (policies are updated on a routine basis and require tracking for compliance)

1. A purpose, scope, or objective statement (that aligns with the corporate profile)

1. Identification of eight security topics such as (but not limited to): Acceptable Use Policy for End-Users, Remote Access Policy, Email Policy, Unauthorized Access, Limitations of Liability, Prohibited Uses, Logging Standards, Physical Access Control Policy, Operating System Updates, Anti-Virus Protection, Application Security, and/or Data Classification Standards.

1. For each of the selected 8 security topics, write the security policy section of a general security policy that aligns with your corporate profile.

Each topic should be a minimum of 125 words in length.

I NEED ASSISTANCE WITH THE FOLLOWING:

Assignment Access Chapter 2 Capstone – International Foodies (PC only)

Assignment Access Chapter 2 Mid-Level 1 – Games (PC only)

 Describe two cryptographic applications and how they are used in Information System Security. 

Do a web search for other methods employed by industry or government to share information on possible incidents then write a report supported by references discussing what you found.

 Exp19_Excel_Ch05_HOEAssessment_Fine_Art

Start Excel. Download and open the file named Exp19_Excel_Ch05_HOEAssessment_FineArt.xlsx. Grader has   automatically added your last name to the beginning of the filename.

Before using the Subtotal command, the data must be sorted by   categories.
 

  On the Subtotals worksheet, perform a three-level sort by Status, then by   Type, and finally by Title, all in alphabetical order.

You want to subtotal data to identify the highest issue prices,   estimated values, and percentage change by the Status category and the Type   of art work.
 

  Use the Subtotals feature to insert subtotal rows by Status to identify the   highest (max) Issue Price, Est. Value,   and Change. Then add a second-level subtotal by Type using the same function   and columns.

You want to apply an outline so that you can collapse values used for   the formula in column F. Then you will collapse the subtotaled rows.
 

  Apply an auto outline and click the collapse button above column F. Collapse   the data by displaying only the subtotals and grand total rows. Set a print   area for the range B1:F48.

A PivotTable can give additional perspective to data. You will use   the Art worksheet to create a recommended PivotTable.
 

  Use the Art worksheet to create the recommended PivotTable called Sum of   Issue Price by Type on a new worksheet named Sold   Out. Mac users create a PivotChart that includes   the Status field in the Filters area, the Est. Values field in the Columns   area, the Type field in the Rows area, and the Issue Price field in the Values   area.
 

  Name the PivotTable Art Type.

Currently, the PivotTable contains the Issue Price field. You will   add the Est. Value field to compare the difference between total value of the   art based on issue price and estimated value today.
 

  Add the Est. Value field below the Sum of Issue Price in the Values area.

You want to display the average   values instead of the sum of the values in each category.
 

  Modify the two Values fields to determine the average Issue Price and average   Est. Value by type. Change the custom name to Average Issue Price and Average Est. Value, respectively.

Format the two Values fields   with Accounting number type with zero decimal places.

The Summary sheet is designed to   display two key averages from the PivotTable on the Summary sheet.
 

  Display the Summary sheet. In cell B2, insert the GETPIVOTDATA function that   references cell C4 on the PivotTable in the Sold Out sheet. In cell B3,   insert the GETPIVOTDATA function that references cell C9 on the PivotTable in   the Sold Out sheet.

Some art is still available, but   most art is sold out. You want to create a filter to focus on the sold-out   art.
 

  Display the Sold Out sheet. Add the Status field from the field list to the   Filters area. Set a filter to display only art that is Sold Out.

Insert a slicer for the Type   field, change the slicer height to 2 inches, change the button width to 2 inches, and apply the Light   Blue, Slicer Style Dark 5. Cut the slicer and paste it in cell A11.
 

  Note, depending upon the Office version used, the style name may be Slicer   Style Dark 1.

Display the Totals sheet. Insert   a calculated field named Field1 to determine difference between the two   values, Est. Value   and   Issue Price.   Change the custom name to Value Increase.

With the PivotTable on the   Totals sheet displayed, change the Sum of Issue Price and Sum of Est. Value   fields to show values as percentage of column totals.

With the PivotTable on the   Totals sheet displayed, select Light Blue, Pivot Style Medium 6 and display   banded rows.

Display the Porcelains sheet.   Create a relationship between the PORCELAINS table using the Code field and the   CODES table using the Code field.

Create a blank PivotTable from   inside the PORCELAINS table. Add this data to the Data Model. Name the   worksheet Porcelain Pivot and name the PivotTable Porcelain   Values.

Display all tables in the   PivotTable Fields List task pane. Add the Description from the CODES table to   the Rows area and the Issue and Est. Value fields as Values from the   PORCELAIN table. Format the two value fields with Accounting number format   with zero decimal places.

Create a clustered column   PivotChart from the Porcelain Values PivotTable. Cut the PivotChart and paste   it in cell A7.

Add a chart title and type Porcelain   Values. Bold   the title. Change the value axis maximum bounds to $3,000.

Change the PivotChart height to 2.5 inches and the width to 3.7 inches.

Create a footer on all   worksheets (except Art) with your name in the left section, the sheet name   code in the center section, and the file name code in the right section.

Ensure that the worksheets are   correctly named and placed in the following order in the workbook: Subtotals,   Totals, Sold Out, Art, Summary, Porcelain Pivot, Porcelains.

Save and close Exp19_Excel_Ch05_HOEAssessment_FineArt.xlsx.   Exit Excel. Submit the file as directed

Read the OpenQuestion pdf files

Question Three [30 marks]

Radisson Blue Hotels stores information about their hotels in different countries. Every hotel is identified by hotel id, hotel name, hotel address, city and URL. Every country is identified by country code, country name and country currency. Guests staying in the hotel is identified by guest number, guest name, guest address and guest city. Every room in the hotel is identified by room number, and room floor. Every room booking is identified by booking id, starting date, and ending date. There are different types of rooms in the hotel. Each room type is identified by room type code, room standard rate, and description. In each country, there may be no hotels or more than one hotel. A hotel may have one or more rooms. A guest can book one or more rooms and a room may be booked by one or more guests. A hotel may have one or more bookings and each booking is associated with exactly one hotel. Each room type may have one or more rooms and a room belongs to one room type. 

1) Write the schema of the appropriate relations for the above scenario. Identify the primary key and the foreign key in each of the relations. [4 marks]

How did you identify the primary key and foreign key? Explain.  [2 Marks]   

2) Use the designed relations to write SQL statements for the following questions:  –  Explain the working of each query in detail.

a. Display all the rooms having the same rate in the ascending order of room rate.  [5 marks]

b. List the number of hotels in each country. Only include countries with more than 4 hotels.  [4 marks]

c. Display the details of hotels that is not yet included in any booking. [4 marks]

d. Display all the details of guests who booked hotels on ‘2021-05-01’. [4 marks]

e. Display the room number, room standard rate and the hotel id. [4 marks]

f. Display the details of countries with country name starting with letters other than any letter within ‘A’ and ‘P’. [3 marks]

Business Ethics:

–   Pick one of the following terms for your research: Morals, principles, values, corporate social responsibility, or ethical culture. 

–  The paper should have a definition, Summary and Discussion ( Summary should have 150-200 words and discussion should have 300-350 words. )

– Attach minimum 2 references

– Absolutely no plagiarism, attach a plagiarism report with 0% similarity index. 

GO16_AC_VOL1_GRADER_CAP_AS – Inventory Supplies