I have implemented the web application for that you need to implement the Email multifactor authentication. And need to implement the registration form and login functionality from the data base.

You can use Xamp/ wamp server and need a video of execution from you that it

ER Model and Normalization

Q1: Garage Database [40 points]

We want to design a database for a local garage. For each customer, we want to record the (unique) name, the customer address, and the contact phone number. For each vehicle, we want to record the unique vehicle’s identification number (VIN), and the vehicle’s make, model and year. For each repair job we want to record the description of the job done (maximum 200 chars), the date, and the total dollar cost. A repair job may involve zero or more parts (like, e.g., “windshield wipers”, “battery”, etc.) For each part we want to record its (unique) part number, the part name and its cost. In addition, note that:

• Each vehicle may have 1 or more repair jobs.

• Each customer may be the primary owner of 1 or more vehicles.

• Every vehicle has only one primary owner (we ignore co-owners).

• No vehicle can have more than one repair job in any given day.

Please answer the following questions:

Q1.1. (10 points) Draw an ER diagram for this database. Make sure to indicate primary keys, cardinality constraints, weak entities (if any), and participation constraints. List any assumptions you make in the process.

Q1.2. (10 points) Translate the ER diagram in Q1.1 into relational database tables (i.e. give the SQL DDL statements). Make sure that the translation captures key constraints (primary keys and foreign keys if applicable) and participation constraints in the ER diagram. Identify constraints, if any, that you are not able to capture.

Q1.3. (20 points) Identify the functional dependencies that you expect should hold for the Garage Database domain. Use the dependencies to find keys and BCNF normal forms.

Q2: Restaurant Database [ 40 points]

The student administrator of the Mini University wants to design a database for profiling students’ preferences for the nearby restaurants and the dishes. For example, the student Jack Smith likes the “rib eye steak” at the “TGI Fridays”, not the “rib eye steak” at the “Olive Garden”, while the student Nancy Graham likes the Italian spaghetti at “Zeppoli’s”.

• Each student has his/her SSN, the name, and the department.

• Each restaurant has its name, and the mailing address.

• The name of a restaurant may not be unique, but the mailing address is unique.

• Each dish has the name and the price.

• The price of a dish might differ on different restaurants. For example, “rib eye steak” is $15 at “TGI Fridays”, but $20 at the “Olive Garden”.

• The name of a dish is unique within a restaurant. Two restaurants may have the same dish name.

• A dish is offered by at least one restaurant, and a restaurant offers at least a dish.

Please answer the following questions:

Q2.1. (10 points) Draw an ER diagram for this database. Make sure to indicate primary keys, cardinality constraints, weak entities (if any), and participation constraints. List any assumptions you make in the process.

Q2.2. (10 points) Translate the ER diagram in Q2.1 into relational database tables (i.e. give the SQL DDL statements). Make sure that the translation captures key constraints (primary keys and foreign keys if applicable) and participation constraints in the ER diagram. Identify constraints, if any, that you are not able to capture.

Q2.3. (20 points) Identify the functional dependencies that you expect should hold for the Restaurant Database domain. Use the dependencies to find keys and BCNF normal forms.

Q3: Reverse Engineering [20 points]

This question tests how well you understand the algorithm for converting E/R diagrams to relational schemas. An E/R diagram when converted to relations (using the mechanical construction that we know and love) gives rise to the following relations:

• R(a, b, c)
• S(a, d)
• T(a, d, f, g)

You may assume that the same symbols refer to the same attribute and different symbols refer to different attributes (e.g., the attributes a in the relations R, S and T are the same) i.e. it ultimately comes from a single entity set or relationship in the E/R diagram.

Your task is to reverse-engineer the E/R diagram from these relations; in other words, what E/R diagram could have produced these relations. For full credit, give two different E/R diagrams that could have produced these (and only these) relations (i.e. 10 points for each correct E/R diagram).

 Submission Guidelines and Requirements

• Include your name and UCM ID in the assignment

1. Add the following statement in your solution “I certify that the codes/answers/outputs of this assignment are entirely my own work.”

// Your Name

// Your UCM ID

//Certificate of Authenticity: “I certify that the assignment is entirely my own work.”

1. Add comments to your submission as much as possible
2. Submit your ER diagrams, relation schemas, functional dependencies and normalized forms
3. Zip your files and upload the zipped file onto Blackboard
4. There could be more than one correct answer. We shall accept them all
5. Whenever you are making an assumption, please state it clearly
6. Grading standards:

• There will be automatic 10 points penalty if your submission is missing certificate of authenticity
• Late submission: Late submission is allowed with a 10% deduction per day (delay in submission). Submission after 3 days of the deadline won’t be accepted

CHANGES TO BE MADE!!!!!

 1.1 No primary keys, cardinality constraints, weak entities (if any), and participation constraints are given in your ER diagram
1.2 DDL statements means “Create table” statements with primary keys and foreign keys
1.3 Functional dependencies means for example: Customer.Name —> Customer.Address, Customer.PhoneNumber. All dependencies like this and also BCNF normal form.

2.1 No primary keys, cardinality constraints, weak entities (if any), and participation constraints are given in your ER diagram
2.2 DDL statements means “Create table” statements with primary keys and foreign keys
2.3 Functional dependencies means for example: Student.SSN —> Student.Name, Student.Department. All dependencies like this and also BCNF normal form.

3. Please mention participation constraints by double lines()strong and weak participation), keys etc. in the ER diagram 

In our readings for this week, we’ve learned about designing interfaces and dialogues. For your assignment, you will apply what you’ve learned to make a recommendation.Here is the context for your assignment: Tim is happy with your work. The next part of the proposal will be to provide a high-level recommendation on the method of interacting with the proposed system. For this part of the proposal, Tim wants you to provide a high-level or executive summary and make a recommendation (see below for details). Compose a proposal that is a minimum of 700 words (double-spaced) in length and responds to the two tasks listed below with the necessary references to support your work:

1. Provide a high-level or executive summary of the following interaction methods: object-based, form, natural language, and command language.
2. Then, provide a recommendation for the proposed system. Make sure you provide a clear justification for your recommendation.

Exp19_Access_Ch01_CapAssessment – Latte Delights Inventory 1.0

Exp19_Access_Ch01_CapAssessment – Latte Delights Inventory 1.0  Project Description: In this project, you will open a database containing the inventory of a coffee shop, create a new table in which to store sales representatives (reps) information, and then add the sales rep records. You add a new product using a form and print a report. You apply a filter by selection and sort a query, and then you apply a filter by form to a table. You save both filters. Start Access. Open the downloaded Access file named Exp19_Access_Ch01_CapAssessment_Latte_Delights_Inventory.accdb. Grader has automatically added your last name to the beginning of the filename. Add the following records to the Sales Reps table, letting Access assign the SalesRepID:  LastName FirstName Address City State ZIP Eissler Karean 13 Oak Lane Montgomery PA 17752 Rai Namrata 1000 Ogden Blvd New Castle DE 19720 Pellum Katryn 286 Bergen Rd Salford PA 18957   Close the table. Open the Customers form in Form view. Use Search to locate the record for Baker Auto Supply. Modify the record so that the Address1 field displays 4508 N.W. 7 Avenue. Save and close the form. Open the Products form in Form view. Add a new product (Access will automatically add the Product ID): Coffee-Arabica Premium. The Description is 24/Case, Pre-Ground 1.75 Oz Bags, the Cost is $13 (just type 13, no $), the Markup Percent is 100%, the Brand is Premium, and the Year Introduced is 2017. Save the new record and close the form. Open the Products report and check that the report contains the new product P0026, Coffee-Arabica Premium. View the layout of the report in Print Preview and then change the page layout to Landscape. Save the report and close Print Preview. Open the Customers table. Sort the table by Customer Name in ascending order. Save the changes and close the table. Open the Revenue Stats query and sort the City field in ascending order. Apply Filter by Selection so that only stats for the last name Pellum display. Save and close the filtered query. Open the Products table. Use Filter by Form to create a filter that will identify all premium brands in the Brand field that were introduced after 2017. Apply the filter and preview the filtered table. Close the table and save the changes. Close all database objects. Close the database and then exit Access. Submit the database as directed.
 

Design a Do-While loop that asks the user to enter two numbers. The numbers should be added and the sum displayed. The loop should ask the user whether he or she wishes to perform the operation again. If so, the loop should repeat; otherwise it should terminate

Project Part 2: Identify Vulnerabilities in IT Security

Scenario

Aim Higher College has been the target of focused attacks from a variety of attackers. Your manager has assigned you the task to review the port and vulnerability scan data recently gathered from a typical system to determine what ports and services are exposed to attackers, and what vulnerabilities exist on that system.

Required Resources

Access to the Internet

Text sheet: Zenmap Intense Scan Results (ts_zenmapscan)

Tasks

1. Analyze the results of the Zenmap scan. Your report must answer the following questions:

What are the first five open ports as identified by the Zenmap scan?

Include the port number

Include the service name

Include a brief description of how each is used

2. The Nessus scan identified two critical vulnerabilities, identified as ID 32314 and ID 33850.

Research the vulnerabilities against the Common Vulnerabilities and Exposure (CVE)database.

Include the name and a brief description of each vulnerability.

3. Determine what can be done to protect the system and defend the campus network againstattempts to gather data, and to resolve vulnerabilities. Also determine which ports and services likely need to remain open.

4. Write a report targeted at IT management and systems administration staff explaining thevulnerabilities and protection mechanisms that Aim Higher College should adopt, which will be applied to all similar systems at the college.

Submission Requirements

Format: Microsoft Word (or compatible)

Font: Arial, size 12, double-space

Citation Style: Follow your school’s preferred style guide

Length: 2 to 4 pages

1. In your own words, describe the Dark Web.
2. What type pf content is generally found on the Darknet?
3. What kind of information can be found using the hiddenwiki?

APA format and references 

Exp22_Word_Ch01_Cumulative_Agriculture

Project Description:

As a student assistant in the Office of Academic Programs, you are charged with finalizing a one-page summary of a program change for your university. You will use styles and columns to format and arrange text. In addition, a watermark and document properties identify the document’s ownership and subject matter.

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

Display nonprinting characters.   Insert text from Careers.docx in   the blank paragraph at the end of the document.

Scroll to the top of page 1.   Apply Heading 2 style to the paragraph heading ABOUT. Apply Heading 2 style to the paragraph headings RESEARCH and CAREERS. Modify the Heading 2 style to a font color of Black,   Text 1 (row 1, column 2) and a font size of 16.

Apply Title style to the report   heading CAREER FOCUS and center the   heading. Insert a hard return after the report heading and type Agriculture in Your Future. (Do not type the period.) 

Apply Book Title style to the   subheading Agriculture in Your Future.   Change the font size of the subheading to 14.

Select all report text from ABOUT through the end of the document.   Do not select the two heading lines. Change the number of columns to 2.   Ensure that a line displays between the columns.

Insert a Column break before the   RESEARCH heading near the end of the left   column.

Change the document theme to   Facet. Change the theme colors to Grayscale.
 

  If the theme is not available, browse for the downloaded theme file Facet.thmx.

An informal document like a   flyer often includes a page border for a bit of color and style.
 

  Add a Shadow page border, selecting the first line style (single solid). The   color is Gray, Accent 4 (row 1, column 8), and the line weight is 1 1/2 pt.   Apply the page border to the whole document.

Include a custom watermark with   the text UAC. (Do not type the period.) The watermark should be horizontal.

Replace all occurrences of Department of Agricultural Science with   Department   of Agricultural Economics. (Do not include the period.) Two replacements should be made.

Find the word production. Delete the word in that precedes the word production.

Check the word count. If the   number of words is greater than 400, change the first paragraph heading from ABOUT to ABOUT US. However, make that change only   if the word count exceeds 400.

Check the document for spelling   and grammatical errors. Ignore all refinement concerns such as conciseness.

Modify document properties to   include Shazad Chabil as the author, replacing any existing author. Include a Subject   of Agriculture   degree.

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

Please summarize, 

Overview:  A design document consists of various elements including a style guide and navigation structure. Creating the style guide is one of the more creative aspects of a mobile application. As the style guide is created this week, you want to establish the colors and fonts that will be used throughout the mobile application. These design and style choices should directly reflect the purpose of the mobile app and appeal to the target audience. This style guide should help ensure that the visual aspects of the website will be consistent regardless of the page users will be on in the site. Each style guide would consist of a proposed set of color swatches with their hexadecimal color code to ensure that the exact same colors are being used throughout the entire design of the mobile application. The style guide package would also consist of the font specifications that will be used within the app. The fonts should be selected for the buttons, navigation and the text at the minimum. These fonts should be displayed using the actual font and size that you are proposing. The mobile application navigation should provide information about the navigation process between the various screens. The information that should be created in this visual diagram should be presented in a flowchart. The flowchart should list all the planned main screens and identify how the pages are going to be linked together. Note that some of your screens are universally accessible such as the home screen whereas other screens may only be accessible based on specific criteria. This flowchart will provide a blueprint for the mobile navigation designating how the various screens will be connected. Instructions: • Create a design document that consists of the style guide that will be used for your project along with the navigational structure for your project. These design decisions will help solidify the look and feel of your project along with a guide of what the main screens of your app will be. • Make sure to include the welcome/home screen, main app screen, and the credits at the very least. • Include the flowchart for a blueprint for the mobile navigation designating how the various screens will flow. CIS290 – Mobile Application Development Design Document Requirements: • Submit a Word document that consists of the style guide and the flowchart for the navigation.