All posts by : chebby

 200 words

Beginning in 2014, malware infected the reservation system of Starwood Hotels, which included Sheraton, W Hotels, Westin, Le Meridien, Four Points by Sheraton, Aloft and St. Regis.  Then, in 2016, Marriott Hotels acquired Starwood. In November 2018, Marriott discovered and revealed the four-year hacking campaign that attacked Starwood’s reservation database. A total of 383 million guests were eventually determined to have been affected. The data breach related in the theft of names, addresses, phone numbers, credit card information, email addresses, and millions of unencrypted passport numbers. The Data Breach has arguably subjected Starwood to legal liability both in the US (data breach and breach notification laws) and in the EU (the EU General Data Protection Regulation —GDPR). In your initial post, please answer both of the following questions:

1. Choosing either a US state data breach law or the EU GDPR (check our reading materials and PowerPoint slides, the links below, and ncsl.org for descriptions of applicable law) and explain how it applies or has already been applied to Starwood for its data security breach.
2. Using your best judgment, what would you recommend to create and maintain an infrastructure that would most robustly and effectively protect against future breaches and the liabilities resulting from those breaches?  Include any specifics you may be familiar with such as hardware and software recommendations, compliance with specific US and  international laws, industry best practices, and any appropriate third-party vendor solutions.

Improve It Project 3-7

Windows   Mac

Central Sierra Insurance is a multi-office company that handles commercial and personal insurance products. In this project, you add missing data and verify that the charts are updated.

[Student Learning Outcomes 3.2, 3.3, 3.4]

File Needed: CentralSierra-03.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-CentralSierra-03.xlsx

Skills Covered in This Project

• Edit source data.
• Switch row and column data.
• Change chart colors.
• Apply a chart style.
• Add and format elements in a chart.
• Use gradient fill for a chart object.
• Change the chart type.

This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

1. Open CentralSierra-03.xlsx the start file workbook. The start file will be renamed automatically to include your name. Change the file name if directed to do so by your instructor and save it.
2. Insert a new row at row 8.
3. Type Motorcycle in cell A8. In cells B8:D8, type these values: 15, 82, and 24.
4. Change the pie chart object to a 3-D Pie and apply Style 3. Notice that a data series for “Motorcycle” has been added.
5. Switch the row and column data for the column chart. The data series for “Motorcycle” is not included.
6. Click the Select Data button [Chart Design tab, Data group] and reset the source data to show cells A5:D10.
   Click the Select Data button [Chart Tools Design tab, Data group] and reset the source data to show cells A5:D10.
7. Change the column chart color scheme to Monochromatic Palette 7 in the Monochromatic group.
8. Format chart elements.Figure 3-76a Linear Down gradient
   1. Select the Side Wall of the column chart and apply Olive Green, Accent 3 shape fill (seventh column).
   2. Use the Shape Fill button to apply the Linear Down gradient in the Light Variations group to the side wall (Figure 3-76a).
   3. Apply the same fill and gradient to the Walls element.
   4. Select the Floor element and apply Olive Green, Accent 3, Lighter 60% (seventh column) with no gradient.
   5. Select the gridlines and use the Shape Outline button to format them with Black, Text 1, Lighter 50% (second column). (To select the gridlines, select the Plot Area and then click one of the gridlines in the chart.)
9. Select the pie chart object and change the colors to Monochromatic Palette 7 in the Monochromatic group.
10. Use Olive Green, Accent 3 as shape fill (seventh column) for the pie chart area with a Linear Down gradient from the light variations.
11. Apply a 1 pt Olive Green, Accent 3, Darker 25% outline (seventh column) to both chart objects.
12. Save and close the workbook (Figure 3-76).
13. Upload and save your project file.
14. Submit project for grading.

1. Conduct a critical analysis of two of your classmates’ posts 
2. Each response to your classmates should be at least 150 words in length and include a citation to one credible information source. The response citation should follow APA formatting.

please read all the attached instructions. The template for the project is attached

pls ready the following instruction in the pdf because there are four options but we have to exclude the fourth option because it can only be done by the professor approve. therefore, from one to three option would be the focus on this assignment. 

QUESTION 1

Use the following business rules to create a Crow’s Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

• A department employs many employees, but each employee is employed by only one department.
• Some employees, known as “rovers,” are not assigned to any department.
• A division operates many departments, but each department is operated by only one division.
• An employee may be assigned many projects, and a project may have many employees assigned to it.
• A project must have at least one employee assigned to it.
• One of the employees manages each department, and each department is managed by only one employee.
• One of the employees runs each division, and each division is run by only one employee.

 SAVE AS:  ch4_question1_deleon.doc 

—————————————————–

QUESTION 2

Create a complete ERD in Crow’s Foot notation that can be implemented in the relational model using the following description of operations. Hot Water (HW) is a small start-up company that sells spas. HW does not carry any stock. A few spas are set up in a simple warehouse so customers can see some of the models available, but any products sold must be ordered at the time of the sale

• HW can get spas from several different manufacturers.
• Each manufacturer produces one or more different brands of spas.
• Each and every brand is produced by only one manufacturer.
• Every brand has one or more models.
• Every model is produced as part of a brand. For example, Iguana Bay Spas is a manufacturer that produces Big Blue Iguana spas, a premium-level brand, and Lazy Lizard spas, an entry-level brand. The Big Blue Iguana brand offers several models, including the BBI-6, an 81-jet spa with two 6-hp motors, and the BBI- 10, a 102-jet spa with three 6-hp motors.
• Every manufacturer is identified by a manufacturer code. The company name, address, area code, phone number, and account number are kept in the system for every manufacturer.
• For each brand, the brand name and brand level (premium, mid-level, or entry level) are kept in the system.
• For each model, the model number, number of jets, number of motors, number of horsepower per motor, suggested retail price, HW retail price, dry weight, water capacity, and seating capacity must be kept in the system.

 SAVE AS:  ch4_question2_deleon.doc 

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

QUESTION 3

The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to 3 coaches (offensive, defensive, and physical training coaches). During the season, each team plays 2 games (home and visitor) against each of the other teams. Given those conditions, do the following:

• Identify the connectivity of each relationship.
• Identify the type of dependency that exists between CITY and TEAM.
• Identify the cardinality between teams and players and between teams and city.
• Identify the dependency between COACH and TEAM and between TEAM and PLAYER.
• Draw the Chen and Crow’s Foot ERDs to represent the JCBC database.
• Draw the UML class diagram to depict the JCBC database.

 SAVE AS:  ch4_question3_deleon.doc 

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

QUESTION 4

Create an ERD based on the Crow’s Foot notation using the following requirements:

• An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative.
• The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices.
• An INVOICE can include many detail lines (LINE), each of which describes one product bought by the customer.
• The product information is stored in a PRODUCT entity.
• The product’s vendor information is found in a VENDOR entity.

 SAVE AS:  ch4_question4_deleon.doc 

—————————————————————–

QUESTION 5

The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company’s training program. The HEG administrator gives you the following description of the training group’s operating environment. (Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell which ones?)

The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers 5 Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to 2 classes or may be assigned to do research only. Each trainee may take up to 2 classes per year.

Given that information, do the following:

a. Define all of the entities and relationships.

b. Describe the relationship between instructor and class in terms of connectivity, cardinality, and existence dependence.

 SAVE AS:  ch4_question5_deleon.doc 

——————————————————————–

QUESTION 6

Automata, Inc., produces specialty vehicles by contract. The company operates several departments, each of which builds a particular vehicle, such as a limousine, truck, van, or RV.

• Before a new vehicle is built, the department places an order with the purchasing department to request specific components. Automata’s purchasing department is interested in creating a database to keep track of orders and to accelerate the process of delivering materials.
• The order received by the purchasing department may contain several different items. An inventory is maintained so the most frequently requested items are delivered almost immediately. When an order comes in, it is checked to determine whether the requested item is in inventory. If an item is not in inventory, it must be ordered from a supplier. Each item may have several suppliers.

Given that functional description of the processes at Automata’s purchasing department, do the following:

a. Identify all of the main entities.

b. Identify all of the relations and connectivities among entities.

c. Identify the type of existence dependence in all the relationships.

d. Give at least two examples of the types of reports that can be obtained from the database. 

 SAVE AS:  ch4_question6_deleon.doc 

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

QUESTION 7

United Helpers is a nonprofit organization that provides aid to people after natural disasters. Based on the following brief description of operations, create the appropriate fully labeled Crow’s Foot ERD.

• Volunteers carry out the tasks of the organization. The name, address, and telephone number are tracked for each volunteer. Each volunteer may be assigned to several tasks, and some tasks require many volunteers. A volunteer might be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned. When a volunteer is assigned to a task, the system should track the start time and end time of that assignment.
• Each task has a task code, task description, task type, and task status. For example, there may be a task with task code “101,” a description of “answer the telephone,” a type of “recurring,” and a status of “ongoing.” Another task might have a code of “102,” a description of “prepare 5,000 packages of basic medical supplies,” a type of “packing,” and a status of “open.”
• For all tasks of type “packing,” there is a packing list that specifies the contents of the packages. There are many packing lists to produce different packages, such as basic medical packages, child-care packages, and food packages. Each packing list has an ID number, a packing list name, and a packing list description, which describes the items that should make up the package. Every packing task is associated with only one packing list. A packing list may not be associated with any tasks, or it may be associated with many tasks. Tasks that are not packing tasks are not associated with any packing list.
• Packing tasks result in the creation of packages. Each individual package of supplies produced by the organization is tracked, and each package is assigned an ID number. The date the package was created and its total weight are recorded. A given package is associated with only one task. Some tasks (such as “answer the phones”) will not produce any packages, while other tasks (such as “prepare 5,000 packages of basic medical supplies”) will be associated with many packages.
• The packing list describes the ideal contents of each package, but it is not always possible to include the ideal number of each item. Therefore, the actual items included in each package should be tracked. A package can contain many different items, and a given item can be used in many different packages.
• Each item that the organization provides has an item ID number, item description, item value, and item quantity on hand stored in the system. Along with tracking the actual items that are placed in each package, the quantity of each item placed in the package must be tracked as well. For example, a packing list may state that basic medical packages should include 100 bandages, 4 bottles of iodine, and 4 bottles of hydrogen peroxide. However, because of the limited supply of items, a given package may include only 10 bandages, 1 bottle of iodine, and no hydrogen peroxide. The fact that the package includes bandages and iodine needs to be recorded along with the quantity of each item included. It is possible for the organization to have items that have not been included in any package yet, but every package will contain at least one item.

 SAVE AS:  ch4_question7_deleon.doc 

———————————————————————————–

QUESTION 8

Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic using the following business rules:

• A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient.
• Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.”
• If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment.
• With each visit, the patient’s records are updated to provide a medical history.
• Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients.
• Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill.
• A patient may pay the bill directly, or the bill may be the basis for a claim submitted to an insurance company.
• If the bill is paid by an insurance company, the deductible is submitted to the patient for payment.

 SAVE AS:  ch4_question8_deleon.doc 

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

QUESTION 9

Create a Crow’s Foot notation ERD to support the following business operations:

• A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business.
• When a customer brings a device to PEAR for repair, data must be recorded about the customer, the device, and the repair. The customer’s name, address, and a contact phone number must be recorded (if the customer has used the shop before, the information already in the system for the customer is verified as being current). For the device to be repaired, the type of device, model, and
• serial number are recorded (or verified if the device is already in the system). Only customers who have brought devices into PEAR for repair will be included in this system.
• Since a customer might sell an older device to someone else who then brings the device to PEAR for repair, it is possible for a device to be brought in for repair by more than one customer. However, each repair is associated with only one customer. When a customer brings in a device to be fixed, it is referred to as a repair request, or just “repair,” for short. Each repair request is given a reference number, which is recorded in the system along with the date of the request, and a description of the problem(s) that the customer wants fixed. It is possible for a device to be brought to the shop for repair many different times, and only devices that are brought in for repair are recorded in the system. Each repair request is for the repair of one and only one device. If a customer needs multiple devices fixed, then each device will require its own repair request.
• There are a limited number of repair services that PEAR can perform. For each repair service, there is a service ID number, description, and charge. “Charge” is how much the customer is charged for the shop to perform the service, including any parts used. The actual repair of a device is the performance of the services necessary to address the problems described by the customer. Completing a repair request may require the performance of many services. Each service can be performed many different times during the repair of different devices, but each service will be performed only once during a given repair request.
• All repairs eventually require the performance of at least one service, but which services will be required may not be known at the time the repair request is made. It is possible for services to be available at PEAR but that have never been required in performing any repair.
• Some services involve only labor activities and no parts are required, but most services require the replacement of one or more parts. The quantity of each part required in the performance of each service should also be recorded. For each part, the part number, part description, quantity in stock, and cost is recorded in the system. The cost indicated is the amount that PEAR pays for the part. Some parts may be used in more than one service, but each part is required for at least one service.

 SAVE AS:  ch4_question9_deleon.doc 

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

QUESTION 10

Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company’s operations are as follows:

• LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide’s name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date
• that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides.
• Every tour must be designed to visit at least three locations. For each location, a name, type, and official description are kept. Some locations (such as the White House) are visited by more than one tour, while others (such as Arlington Cemetery) are visited by a single tour. All locations are visited by at least one tour. The order in which the tour visits each location should be tracked as well.
• When a tour is actually given, that is referred to as an “outing.” LOST schedules outings well in advance so they can be advertised and so employees can understand their upcoming work schedules. A tour can have many scheduled outings, although newly designed tours may not have any outings scheduled. Each outing is for a single tour and is scheduled for a particular date and time. All outings must be associated with a tour. All tours at LOST are guided tours, so a guide must be assigned to each outing. Each outing has one and only one guide. Guides are occasionally asked to lead an outing of a tour even if they are not officially qualified to lead that tour. Newly hired guides may not have ever been scheduled to lead any outings. Tourists, called “clients” by LOST, pay to join a scheduled outing. For each client, the name and telephone number are recorded. Clients may sign up to join many different outings, and each outing can have many clients. Information is kept only on clients who have signed up for at least one outing, although newly scheduled outings may not have any clients signed up yet.

a. Create a Crow’s Foot notation ERD to support LOST operations.

b. The operations provided state that it is possible for a guide to lead an outing of a tour even if the guide is not officially qualified to lead outings of that tour. Imagine that the business rules instead specified that a guide is never, under any circumstance, allowed to lead an outing unless he or she is qualified to lead outings of that tour. How could the data model in Part a. be modified to enforce this new constraint?

 SAVE AS:  ch4_question10_deleon.doc  

Week 4 Research Paper: Big Data and the Internet of Things

The recent advances in information and communication technology (ICT) has promoted the evolution of conventional computer-aided manufacturing industry to smart data-driven manufacturing. Data analytics in massive manufacturing data can extract huge business values while it can also result in research challenges due to the heterogeneous data types, enormous volume and real-time velocity of manufacturing data. For this assignment, you are required to research the benefits as well as the challenges associated with Big Data Analytics for Manufacturing Internet of Things.

Your paper should meet these requirements:

• Be approximately FIVE full pages in length, not including the required cover page and reference page.
• Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Readings:

Reading Assignments

Dai, H.-N., Wang, H., Xu, G., Wan, J., & Imran, M. (2019). Big Data Analytics for Manufacturing Internet of Things: Opportunities, Challenges and Enabling Technologies.
https://arxiv.org/abs/1909.00413? ​There is a link to the PDF of this article in the right column of this record under Download.

Martinez, R. M. (2017). The Internet of Things: Privacy Issues in a Connected World Remarks Given at Protecting Virtual You: Individual and Informational Privacy in the Age of Big Data. University of St. Thomas Journal of Law and Public Policy (Minnesota), 11(1), 63–71.

New technologies may lead to a series of unintended consequences. However, fear of those consequences may slow changes that can be beneficial. However, fear may slow beneficial change. Jasanoff asserted we should combine the “can do” of science and engineering with the “should do” of ethical and political analysis (Winston & Edelbach, 2014). Take a specific example of technology and explain how these two have been or might be combined. 

Reference:

Winston, M., & Edelbach, R. (2014). Society, ethics, & technology (5th ed.). Wadsworth Cengage Learning.

Exp19_Word_Ch04_CapAssessment_Retirement 

Exp19 Word Ch04 CapAssessment Retirement 

Project Description:

You are enrolled in a personal finance course at your local  university. One of the assignments is to write a group paper with  another student about the different types of retirement plans. You and  your partner conducted research on the topic and wrote a final draft of  the report. In this project, you will format the paper to enhance  readability. You will use track changes, accepting and rejecting them as  necessary, credit sources used in the preparation of the report,  address your partner’s comments, include a table of contents and an  index.

Start   Word. Download and open the file named Exp19_Word_Ch04_CapAssessment_Retirement.docx. Grader has automatically added   your last name to the beginning of the filename. 

Ensure that the markup view is   All Markup. Review the comments. On the second page, reject the replacement   of the two words NOW to lowercase.

Accept all other tracked changes   in the document and stop tracking. Keep all comments.

Change all headings to the   correct heading styles as per the comments left by your partner.

Reply to the first comment by   typing I   have made the style replacement. (include the period.)

Select the table on page 2, and   insert the caption text to read Table 1: The Future Value of Money (no period). Make sure the   caption displays above the selected item. Center the caption.

Assign the caption Table 2: Comparisons   between a Traditional and a Roth IRA for the next table, as instructed in the comments.   Center the caption.

Select the APA Sixth Edition   style. Click before the period at the end of the first sentence of the 403(b) Plans section. The sentence   ends in (TSA) plan. Insert the   following Web site citation:
 

  Name of Web Page: Choosing a Retirement Plan: 403(b) Tax-Sheltered   Annuity Plan
   Name of Web Site: IRS
   Year: 2018
   Month: October
   Day: 08
   URL: http://www.irs.gov/Retirement-Plans/Choosing-a-Retirement-Plan:-403(b)-Tax-Sheltered-Annuity-Plan

Click before the period ending   the first sentence of the 401(K)   section. The sentence ends with at   their workplace. Insert the following Web site citation:
 

  Name of Web Page: 401(k) Plan
   Name of Web Site: IRS
   Year: 2018
   Month: October
   Day: 14
   URL: http://www.irs.gov/Retirement-Plans/401(k)-Plans

For the first table, replace the   Source URL with the following website citation:
 

  Name of Web Page: The Future Value of Money
   Name of Web Site: IRS
   Year: 2018
   Month: October
   Day: 14
   URL: https://www.irs.gov/retirement-plans/plan-participant-employee/retirement-topics-benefits-of-saving-now

Insert a footnote on page 2 at   the end of the table heading in the Introduction   section (the first line of the table), which ends with 6% annual return. Type the following for the footnote: The   calculation did not take into consideration the cost of living adjustment   (COLA).  (Do not   include the period.) Change the number format for footnotes  to a, b, c in the   Footnotes dialog box. (Click Apply, not Insert.)

Insert a blank page at the end   of the report and insert a bibliography with the title References. The bibliography should be double-spaced with no   paragraph spacing before or after.

Format the bibliography with a   font of Times New Roman and a font size of 12 pt. Center the References title. All text in the   bibliography should be Black, Text 1 font color. Ensure that no text is bold.

Create a table of contents, with   an Automatic Table 1 style, on a  new page positioned between the cover page   and the current page 2.  Note: Mac users, create a Classic style table of   contents.

Mark the following words as   index entries, selecting Mark All for each: contribution, Roth IRA,   traditional IRA, 403(b), and 401(k). Select the first occurrence of deduction and set a cross-reference as See contribution.
   Note, please be sure to search your document to ensure that all  occurrences   are marked as specified; press CTRL+F and use the  Navigation Pane to locate   each one.

Add an index on a blank page at   the end of the document. Use Classic format and accept all other default   settings.

Insert a footer with a centered   page number, using the Plain Number  2 format. Note: Mac users, insert the   default page number. Do not  display the page number footer on the first page.   Numbering begins  with page 1 on the Table of Contents page.

Insert a page break so that the   second table and its caption is on  one page. Also, update the Table of   Contents to reflect the change in  page number.

Save and close Exp19_Word_Ch04_CapAssessment_Retirement.docx.   Exit Word. Submit the file as directed.

1 page answering these 2 questions

no plagiarism