Smart Systems Project

Do research on two of the following topics:

  • Smart Cities
  • Smart Highways
  • Smart Factories/Warehouses
  • Smart Data Centers
  • Smart Homes

Write a 10-page Word document, double-spaced, detailing each system, their subsystems and at least 25 requirements (total)and associated specifications for each of the Smart Systems.  (PMI, 2021) indicates “the term requirement generally refers to a customer need while specification refers to a detailed, usually technical description of how that need will be met.” For example, if a Smart Home must have a wireless thermostat, that is a requirement.   A Requirement states what a product must do or a quality it must possess. A Specification is a collection of requirements that are used in the design of that product.Research must include scholarly references but can also include YouTube videos on the Smart Systems.  Note when thinking about sub-systems: consider a home Smart System.  Within that System you might have a sub-system for electricity, another sub-system for communications, and another sub-system for security, etc.  You must not only detail the major system but also the sub-systems found in the research.Also view YouTube videos on Augmented Reality and Virtual Reality to extend your research on how these Smart systems may evolve over time.Your paper should include multiple topic sections or paragraphs.  Start with a section that describes the first Smart System, followed by individual sections for each of its Sub-Systems.  Then add a section that describes the second Smart System, followed by individual sections for each of its Sub-Systems.  In your paper, provide the following:

  1. An Introduction paragraph describing the assignment and a short description of the two systems selected.
  2. A section that describes the Smart System (with an appropriate section Heading) and the basic specifications that drive the development of the Smart Systems.  
    1. What is its purpose?  
    2. What operations it performs?
    3. What are its inputs (resources, interfaces, when used)?
    4. What are its outputs (interfaces, data)?
    5. How does the technology integrate within the system?
    6. How important is the technology to the system?
    7. The system’s complexity/cost/feasibility.
    8. Any constraints or risks found during the research.
    9. How the various technologies integrate to accomplish the system goals.

Conclude the section with any potential specifications and functionality that might be added in the future based on enhanced technology (this may come from your research or from other technologies like Augmented or Virtual Reality).

  1. A section for each Sub-System (with an appropriate section Heading) that includes:
    1. A description of that Sub-System.
    2. Detailed functionality that drives the development of the Sub-System. 
    3. Conclude with any potential specifications and functionality that might be added in the future based on enhanced technology (this may come from your research or from other technologies like Augmented or Virtual Reality).

Your paper should conclude with a Findings section the compares the two systems.  Provide the following:

  1. What specifications/functionality are common to both Smart Systems.
  2. What specifications/functionality from one Smart System or Sub-System should or could be applied to the other Smart System.
  3. What potential specifications and functionality might be included in both systems.

To receive full credit for this assignment, you must not only document the smart system but also document how the sub-systems are integrated as processes within a system (i.e. Smart Cities have a lot of smart tools but these tools are integrated as a smart system used across multiple platforms – infrastructure, transportation, etc.)You must include at least 10 references with citations.  Not all references need to be scholarly and can include videos, websites, blogs, etc.

3.jpg

Advance security & information system

Lab: Threat Modeling

Using the the Microsoft Threat Modeling tool “model” the web service that takes an user input from the internet and gets a response from query of a database as shown in the picture below.

3.jpg

For all communication modify the link properties to be encrypted. For data stored at individual components have the data be encrypted. Generate:

1. A threat report keeping the state as Not Started.

2. Go to each individual threat and change the states to either “Mitigated”, “Not Applicable”, “Need Investigation”. Change the priority as deemed for each threat and provide justification.

3. Regenerate a threat report after working on all the threats.

What to Submit?

Submit a zip file that contains the following:

1. Write-up in Microsoft Word about the Lab goals and insights

2. Threat report from “Microsoft Threat Modeling tool” where threats are just generated by the tool (threats are in a Not Started state)

2. Threat report  from “Microsoft Threat Modeling tool” with threats having different states other than “Not Started” state, with adjusted priority and justification

Write a program that prints a letter

Write a program that prints a letter. Ask the user for the receiver’s name, a topic (any string), and the sender name. Your program should print a letter like this:

Hi *receiver*,

This is *sender*. I would like to discuss *topic* with you.

Call me.Regards,

*sender*

Discussion Post

Given the growth in telecommuting and other mobile work arrangements, how might offices physically change in the coming years? Will offices as we think of them today exist in the next ten years? Why or why not?

D. Questions

 

Please note that there are two posts needed to successfully complete the discussion board assignment. An initial post addressing the discussion board topic is due by end of day Saturday. A response post to at least one other student is due by end of day Tuesday.

Look for a tutorial on how to create a database, and share it with the class. What type of RDBMS (Oracle, SQL Server, MySQL, DB2, Informix) is this tutorial? Is the tutorial complete? Do you think that you can follow it to create a database on your own?

Own words no plagarism

To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this project, the ERD is provided to you.Deliverables:

  • SQL Script with your name as follows: YourLastName_Project_Ph3.sql.
  • MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.
  • ZIP file to include the two files mentioned above.

Required Software:

  • MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench.
  • Follow Step 1-3 for your Course Project Phase phase 1, to install the required software components.

Lab Steps:Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships.  You will need to have a clear understanding for these components to create your database using MySQL. Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table

  • Create a new Database, as you did in your Course Project Phase 1 deliverable and you already created a database using the MySQL DBMS.  Reference the attached video (Course Project Ph1 Video.mp4), for a demonstration to create a new Database using MySQL. This video was initially presented to you for phase 2 of your project.  Also, reference the supplemental text: Available for Free download as part of our UC Library.  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2.  Link to UC Library: http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=nlebk&AN=291311&site=eds-live&ebv=EB&ppid=pp_ii
  • Utilize the SQL dialect you learned so far in this course for MySQL.  Use the file supplemental textbook:  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill, as supplement your knowledge of the MySQL dialect. 
  • Create your SCRIPT file to be named: YourLastName_Project_Ph3.sql.

Step 3: Include the following commands at the tops of your scripts:

  • SET FOREIGN_KEY_CHECKS=0;
  • DROP TABLE IF EXISTS STUDENT;
  • DROP TABLE IF EXISTS CAMPUS;
  • DROP TABLE IF EXISTS ROOM;
  • DROP TABLE IF EXISTS COURSE;
  • DROP TABLE IF EXISTS INSTRUCTOR;
  • DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
  • DROP TABLE IF EXISTS CLASS;
  • DROP TABLE IF EXISTS STUDENT_GRADE;
  • SET FOREIGN_KEY_CHECKS=1;

Step 4: Create Tables in your database

  • Create a new Table for each of the entities provided to you in the ERD diagram in Step 1.
  • Add a column to represent each attribute addressed in the ERD diagram in Step 1.
  • Designate Primary Key, as noted in the ERD diagram in Step 1.
  • Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1.
  • Enable referential integrity on the relationships, as needed.
  • Enable cascade updates as needed on the relationships.

Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables.

  • Dates: they should have a date data designation type.
  • Surrogate keys: shall be auto-numbered
  • Character type: shall have a character data designation type.

Step 6: Column Constraints Designation.

  • Grade designation must be of one of these values as follows: A, B, C, D, F, I, W, E (E=enrolled, and W = withdrawn).
  • Student’s first and last names are not to be designated as NULL.
  • Course Credit hours shall be BETWEEN one and four.
  • The instructor first and last name must NOT be NULL
  • Course name designation has to be UNIQUE and must not be NULL type.

Step 7: Data Table Addition

  • Use the INSERT operator to add minimum 2-3 rows of data per each database.
  • You are free to use any values you might like for each of the columns.
  • NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled.

Step 8: Executing your SCRIPT

  • Must incorporate the COMMIT command at the end of your Script
  • Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created.
  • Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script.
  • EXECUTE your SCRIPT.
  • Copy and paste your OUTPUT into your MS Word file as follows: YourLastName_Project_Ph3_Output.doc

Step 9: Upload your work

  • Upload ZIP file to include the two files as follows: 1) SQL Script with your name as follows: YourLastName_Project_Ph3.sql, and 2) MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.

Rubric:

  • Tables Created: create a table for each entity as noted in the ERD diagram in Step 1. 5 points
  • Columns Created: create a column for each attribute as noted the ERD diagram in Step 1. 5 points
  • Primary Key designation: primary key addressed for all tables with unique constraints specified as column properties. 5 points
  • Data Types: Addressed for each attribute. Should include: 1) Date data type incorporated, 2) Surrogate Key Automated, 3) Numeric data shall be numeric type, 4) Character data shall have a character type. 5 points
  • Relationships Created, as noted in the ERD diagram in STEP 1. Relationships shall be enabled for referential integrity and cascade updates. 10 points.
  • Data Added per row: 5 rows of data for each table. 10 points
  • Column Constraints Added: As noted in the description for the project. Checked by adding rows with invalid values. Should take into consideration constraints as follows: 1) student name cannot be NULL, 2) course credit hours are restricted to allocations between 1-4, 3) course name is unique and NOT NULL, 4) instructor last name and first name can NOT be NULL, and 5) grade restrictions to the following values: A,B,C,D,F,I,W, E. 10 points

IT472 week 1 assignment

Week 1 Assignment

  • Describe the concept of a “system.” Though these are the characteristics of any system,  relate it to information systems, as best as you can.
  • Also, describe your understanding of System Analysis and Design.

Submit a one to two page paper in APA format by Sunday 11:59 PM. You are welcome to submit drafts for the instructor’s comments.

For APA format, include a title page. Include an abstract statement on page two. Add the body on pages 3 & 4. Put  your references on page 5. Use more than one reference for your information. Use Times New Roman 12 point font, double-spaced through the entire document. Indent paragraphs in the body. The abstract is not indented.

You can use the APA template and References tab in MS Word for easier formatting.

Discussion 300 words

 

Social engineering is the art of manipulating people so they give up confidential information. The types of information these criminals are seeking can vary, but when individuals are targeted the criminals are usually trying to trick you into giving them your passwords or bank information, or access your computer to secretly install malicious software – that will give them access to your passwords and bank information as well as giving them control over your computer.

Explain a scenario where you or someone you know may have unknowingly given too much personal information to a stranger. How could this situation  been avoided?

Reference Article Link: 

https://www.webroot.com/us/en/resources/tips-articles/what-is-social-engineering

Exp22_Excel_Ch12_CumulativeAssessment_Variation_Teaching_Schedule

 Exp22_Excel_Ch12_CumulativeAssessment_Variation_Teaching_Schedule 

 Exp22 Excel Ch12 CumulativeAssessment Variation Teaching Schedule 

Excel Chapter 12 Cumulative Assessment – Variation Teaching Schedule 

  

Project Description:

You have just started your first career as a high school teacher. To jump start your planning process, you would like to create a teaching schedule template to help plan your weekly tasks. You will create a template, create custom macros to automatically insert dates, and inspect the document for issues.

     

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

 

Clear all data validation in the   range A1:G19. 

 

Delete the sample text in cell   B2

 

Type Teaching Schedule in cell B1.

 

Type Prepared by: in cell F1.

 

Delete the value in cell G1.

 

Add the following comment in   cell G1 Enter Name.

 

Type Monday in cell C4 and use the fill handle to fill the   range D4:G4 with the remaining days of the week. 

 

Use the document inspector to   inspect the document. Remove document properties and personal information and   then click or select close.
 

  Note: Mac users, from the Excel menu, open your preferences, click or select   Security, and then click or select the check box to Remove personal   information from this file on save.

 

Use the accessibility checker to check the document for issues.   Accept the recommended actions for merged cells and use the recommended   action to select Rose, Table Style Medium 23. Close the accessibility checker   pane.

 

Record a macro named ClearSchedule using the shortcut   CTRL+SHIFT+J. Add the description When run, this macro clears the values in the schedule (no period). When run, the   macro should delete the values in cell G1 and in the ranges C3:G3, C5:G6,   C8:G9, C11:G12, C14:G15, C17:G19, in that order.

 

Create a form control button   that fills cell F2. Assign the ClearSchedule macro and edit the button text   to Clear.

 

Create a form control button   that fills cell G2 and edit the button text to Insert Dates.

 

Open the VBA editor and create a   new module named DateStamp. Create a procedure named InsertDate. Insert the comment Inserts   weekly dates,   then enter the following code Range(“C3:G3”) = Array(Date, Date + 1, Date +   2, Date + 3, Date + 4)   and exit the VBA editor.

 

Assign the InsertDate macro to   the Insert Dates form control button.

 

Test both macros and then open   the VBA editor. Locate the module containing the ClearSchedule macro. Copy   the code and paste it starting in cell B2 in the Code worksheet. 

 

Locate the module containing the   InsertDate macro. Copy the code and paste it starting in cell D2.

 

Check the document for   compatibility with Excel 2016 and 2019.
 

  Note: Mac users, skip this step.

 

Save EXP22_Excel_CH12_Cumulative_Assessment_Variation_TeachingSchedule   as a macro-free workbook and close it. Exit Excel. Submit the file as   directed.