Monthly Archives: January 2024

CALIFORNIA STATE POLYTECHNIC UNIVERSITY, POMONA PROJECT CASE STUDY

Project #4 CRC cards and Class diagram

ACTIVITY DIAGRAM

The following activity diagram depicts the process of buying eye glasses from the viewpoint of the patient. The first step is to see an eye doctor who determines if the patient needs glasses then gives the patient a prescription. The patient goes to a glasses store, where he selects the frame and places the order for the glasses. Once the glasses have been made, the patient returns to the store for a fitting and pays for the glasses.

USE CASE DIAGRAM

The following use case diagram illustrates the process of buying eye glasses.

CRC CARDS AND CLASS DIAGRAM

The following concepts were identified from the Activity diagram and Use Case diagram above.

Patient Prescription Eyeglasses Frame

Lenses Order Doctor Store

ATTRIBUTES AND BEHAVIORS

The system needs to remember at minimum the following attributes and perform the following operations

System Attributes

System Behaviors

Eyeglasses getLenseID Eyeglasses getFrameID Order calculateTax
Order calculateItemCost Order calculateTotalCost Customer getContact Customer getPaymentInfo Prescription getSpecification Lens getStrength

Frame getStyle
Store getDirections Doctor getAppointment

Bill to address CC#
Email address ID

Customer
Customer
Customer
Customer
Customer
Customer
Customer
Doctor ID
Eye glasses Base cost Eyeglasses Description Eyeglasses Discount cost Eyeglasses Manufacturer Eyeglasses Model

Frame ID
Lens ID
Order Date
Order Discount price Order ID

Order Quantity
Order Retail price Prescription Date Prescription specification Product ID (eyeglasses) Ship to address

Store name Store phone Store address Store number

Name
Phone number (home) Phone number (work)

PROJECT REQUIREMENTS

1. Create a CRC card for each class
2. Use the classes that were outlined for you and create the CLASS diagram for the system.

•   Determine which class each attribute belongs to.
•   Identify and add associations to the diagram
•   Name your associations
•   Add attributes and behaviors to the diagram
•   Identify and add multiplicity indicators to the diagram
  PROJECT DELIVERABLES
  1. Upload your PDF version of the project to the assignment posting on blackboard 2. Use the cover page at the end of this handout as the first page of your assignment

Course: Assignment: Student Name:

CIS 3150 –Introduction to Systems 

Carefully review and use either of the book options below as a reference for various aspects of analytics.

• Sharda, R., Delen, D., & Turban, E. (2015) Business intelligence and analytics: Systems for decision support (10th ed.). Boston: Pearson. Print: ISBN-13: 978-0-13-305090-5
• Sharda, R., Delen, D., & Turban, E. (2020) Analytics, data science, & artificial intelligence: Systems for decision support (11th ed.). Boston: Pearson. Print: ISBN-13: 978-0-13-519201-6

After reading and analyzing content from book references and or from outside research, select “one” of the research options below and respond.

• Go to www.IBM.com and find at least three customer case studies on Big Data and write a report where you discuss the commonalities and differences of these cases.
• Go to www.cloudera.com and find at least three customer case studies on Hadoop implementation, and write a report where you discuss the commonalities and differences of these cases.
• Go to www.google.com/scholar, and search for articles on stream analytics. Find at least three related articles. Read and summarize your findings.
• Go to www.google.com/scholar, and search for articles on data stream mining. Find at least three related articles. Read and summarize your findings.
• Go to www.google.com/scholar, and search for articles that talk about Big Data versus data warehousing. Find at least five articles. Read and summarize your findings.

1. Open the EmergencyProcedures-02.docx start file. If the document opens in Protected View, click the Enable Editing button so you can modify it.
2. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
3. Change the theme to Integral and the theme color to Red.
4. Change the top, bottom, left, and right margins to 0.75″.
5. Select the entire document and change the font size to 12 pt.
6. Format the title of the document.
   1. Select the title of the document and apply Heading 1 style.
   2. Open the Font dialog box, apply All caps effect, and change the font size to 16 pt.
   3. Change the Before paragraph spacing to 0 pt.
   4. Add a bottom border to the title using the Borders drop-down list.
7. Apply and modify the Heading 2 style and delete blank lines.
   1. Apply the Heading 2 style to each of the bold section headings.
   2. Select the first section heading (“Emergency Telephones [Blue Phones]”).
   3. Change Before paragraph spacing to 12 pt. and After paragraph spacing to 3 pt.
   4. Apply small caps effect.
   5. Update Heading 2 style to match selection. All the section headings are updated.
   6. Turn on Show/Hide and delete all the blank lines in the document.
8. Select the bulleted list in the first section and change it to a numbered list.
9. Apply numbering format and formatting changes, and use the Format Painter.
   1. Apply numbering to the text below the section headings in the following sections: “Assaults, Fights, or Emotional Disturbances”; “Power Failure”; “Fire”; “Earthquake”; and “Bomb Threat.”
   2. Select the numbered list in the “Bomb Threat” section.
   3. Open the Paragraph dialog box, set Before and After paragraph spacing to 2 pt., deselect the Don’t add space between paragraphs of the same style check box, and click OK to close the dialog box.
   4. Use the Format Painter to copy this numbering format to each of the other numbered lists.
   5. Reset each numbered list so it begins with 1 (right-click the first item in each numbered list and select Restart at 1 from the context menu).
10. Customize a bulleted list and use the Format Painter.
    1. Select the text in the “Accident or Medical Emergency” section.
    2. Create a custom bulleted list and use a double right-pointing triangle symbol (Webdings, Character code 56).
    3. Open the Paragraph dialog box and confirm the left indent is 0.25″ and hanging indent is 0.25″. If not, change the settings.
    4. Set Before and After paragraph spacing to 2 pt. and deselect the Don’t add space between paragraphs of the same style check box.
    5. Use the Format Painter to apply this bulleted list format to the following text in the following sections: “Tips to Professors and Staff” and “Response to Students.”
11. Change indent and paragraph spacing and apply a style.
    1. Select the text below the “Emergency Telephone Locations” heading.
    2. Set a 0.25″ left indent.
    3. Set Before and After paragraph spacing to 2 pt.
    4. Confirm the Don’t add space between paragraphs of the same style box is unchecked (Paragraph dialog box).
    5. Apply Book Title style to each of the telephone locations in the “Emergency Telephone Locations” section. Select only the location, not the text in parentheses or following text.
12. Change left indent and paragraph spacing and set a tab stop with a dot leader.
    1. Select the text below the “Emergency Phone Numbers” heading.
    2. Open the Paragraph dialog box and set a 0.25″ left indent for this text.
    3. Set Before and After paragraph spacing to 2 pt. and confirm the Don’t add space between paragraphs of the same style box is unchecked.
    4. Open the Tabs dialog box, set a right tab stop at 7″, and use a dot leader (2).
    5. Press Tab before the phone number (after the space) on each of these lines. The phone numbers align at the right margin with a dot leader between the text and phone number.
13. Apply the Intense Reference style to the paragraph headings in the “Accident or Medical Emergency” section (“Life-Threating Emergencies” and “Minor Emergencies”). Include the colon when selecting the paragraph headings.
14. Use the Replace feature to replace all instances of “Phone 911” with “CALL 911” with bold font style. Note: If previous Find or Replace criteria displays in the Replace dialog box, remove this content before performing this instruction.
15. Insert a footer with document property fields and the current date that appears on every page.
    1. Edit the footer on the first page and use the ruler to move the center tab stop to 3.5″ and the right tab stop to 7″.
    2. Insert the Title document property field on the left. Use the right arrow key to deselect the document property field.
    3. Tab to the center tab stop and insert the Company document property field at center. Use the right arrow key to deselect the document property field.
    4. Tab to the right tab stop, insert (not type) the date (use January 1, 2020 format), and set it to update automatically.
    5. Change the font size of all the text in the footer to 10 pt.
    6. Add a top border to the text in the footer using the Borders drop-down list and close the footer.
16. Use the Borders and Shading dialog box to insert a page border on the entire document.
    1. Use Shadow setting and solid line style.
    2. Select the fifth color in the first row of the Theme Colors (Dark Red, Accent 1) and 1 pt. line width.
17. Center the entire document vertically (Hint: use the Page Setup dialog box).
18. View the document in Side to Side page movement view [View tab, Page Movement group] and then return to Vertical page movement view.
19. Save and close the document (Figure 2-119).
20. Upload and save your project file.
21. Submit project for grading.

This week’s written activity is a three- part activity. You will respond to three separate prompts but prepare your paper as one research paper. Be sure to include at least one UC library source per prompt, in addition to your textbook (which means you’ll have at least 4 sources cited). 

Start your paper with an introductory paragraph.

Prompt 1 “Data Warehouse Architecture” (2-3 pages): Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare data for a data warehouse. Also, describe in your own words current key trends in data warehousing. 

Prompt 2 “Big Data” (2-3 pages): Describe your understanding of big data and give an example of how you’ve seen big data used either personally or professionally. In your view, what demands is big data placing on organizations and data management technology? 

Prompt 3 “Green Computing” (2-3 pages):  One of our topics in Chapter 13 surrounds IT Green Computing. The need for green computing is becoming more obvious considering the amount of power needed to drive our computers, servers, routers, switches, and data centers. Discuss ways in which organizations can make their data centers “green”. In your discussion, find an example of an organization that has already implemented IT green computing strategies successfully. Discuss that organization and share your link. You can find examples in the UC Library.

Conclude your paper with a detailed conclusion section. 

The paper needs to be approximately 7-10 pages long, including both a title page and a references page (for a total of 9-12 pages). Be sure to use proper APA formatting and citations to avoid plagiarism.

Your paper should meet the following requirements:

• Be approximately seven to ten pages in length, not including the required cover page and reference page.

• Follow APA7 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, the course textbook, and at least three scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find supplemental 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.

Please see the attachments for the instruction for this assignment.

Thank you.

 Do you foresee that the traditional computer will be replaced by mobile and smart technologies as a primary device form factor in the near future? If one looks at the world of education for example, the use of Google Chromebooks and Apple iPads are now running the majority of school infrastructures. Mobile apps replace traditional software. Can the same hold true for corporate enterprises today? 

In order to complete Assignment #2 you will need to answer the below questions. Please complete the questions in a Word document and then upload the assignment for grading. When assigning a name to your document please use the following format (last name_Assignment #2). Use examples from the readings, lecture notes and outside research to support your answers. The assignment must be a minimum of 1-full page in length with a minimum of 2 outside sources. Please be sure to follow APA guidelines for citing and referencing sources. Assignments are due by 11:59 pm Eastern Time on Sunday.

Please read the Time Bomb Case (Box 3.6) found on page 64 in Chapter 3.

Which theory do you believe applies to this case? Please explain the reasons why the theory you picked applies.

BOX 3.6 Time Bomb Attacks by an Insider

William Carl Shea, aged 39, was hired around August 2001 as a programmer and manager for Bay Area Credit Services, Inc., in San Jose, California. Shea’s position gave him administrative access to and familiarity with the company’s computer systems, including the database server. He was notified of poor job performance in 2002 and was given an improvement plan in 2003. He was fired on January 17, 2003, when he failed to show up at work. Around this period, a malicious code “time bomb” was placed on the company network that was set to delete and change data at the end of the month. This malicious software caused financial records to be altered and removed and disrupted the computer networks within the company, affecting more than 50,000 debtor accounts. Shea was sentenced to 12 months and 1 day in prison, 6 months of home confinement with electronic monitoring, and 3 years of supervised release for his jury conviction.

Which theory do you think applies best to this case?

Source: www.justice.gov/criminal/cybercrime/

Build out the ERD diagrams for the entire solution based on the following questions (you must have at least 3 tables for full credit, there is no limit based on your simplification of the data. The simplification of the data should follow the in-class examples of data, with no duplication in tables)

Provide 

I. The MYSQL code (within the word document) to build the database and tables

II. The MYSQL code (within the word document) to answer each of the following questions

III. Provide screen shots answering each question along with any supporting text

The answers must be done in SQL, not table presentation and manual interpretation of the data

Questions :

1. What is the total revenue for the year? 

2. What is the gross profit for the year? (based only on what is in the tables)

3. How much revenue did each wine provide for the year?

4. What is the Average revenue per month per location for the year?

5. What is the final inventory of the Premium Red wine?

6. If the retail price of the wine increases by 10%, what is the gross profit margin ?

7. How many bottles of the different wines were ordered in July? 

8. What is the revenue per year per restaurant?

Assume that you have a Saudi league player database. In this database, you have a table containing players’ attributes such as (Name, age, position, etc.) and you decided to add information about players’ agents. Would you represent the agent information as attributes in the player table or would you create an entity set for players’ agents? Justify your answer.

Please write 350 words essay