by admin | Nov 29, 2022 | Computer Science
Assignment Content
Important note: You must complete the “Select a Business Scenario” assignment—and get approval from your instructor for a business scenario—before you begin this assignment.
This week, you create a proposal for a project to improve a specific business process. A proposal describes the project you are pursuing and explains how the results will positively impact the business.
A proposal is reviewed by the client, whether the client is external to an organization or an internal decision maker. Project work can begin once the proposal has been accepted.
An effective project proposal includes information that enables stakeholders to make a go or no-go decision, and typically details the following about a project:
Scope of work
Problems addressed or opportunities proposed
Project requirements and deliverables
Process and timeline for completion
Labor and materials costs
Quality requirements
Review the Sample Project Proposal to see a completed project proposal.
Complete the Project Proposal Template based on the business scenario you selected (and that was approved by your instructor). Complete all parts of the template and do not delete any information from the document.
If you prefer to work in a format other than a document, you may re-create the template as Microsoft® Excel® spreadsheet or other appropriate document type.
Refer to this week’s reading and media for help creating your project proposal.
Submit your assignment.
by admin | Nov 29, 2022 | Computer Science
Guided Project 3-2
San Diego Sailing Club wants to create three queries. To ensure consistency, the starting file is provided for you. Use Design view to create, edit, add aggregate functions, and add criteria to a query to find the total dollar value of the rentals for each boat in its fleet. After saving and testing the query, create a second query that uses aggregate functions and a parameter. Finally, create a query to find which boat types have been rented.
[Student Learning Outcomes 3.2, 3.3, 3.4, 3.5, 3.6, 3.8]
File Needed: SanDiegoSailing-03.accdb (Available from the Start File link.)
Completed Project File Name: [First Name.Last Name]-SanDiegoSailing-03.accdb
Skills Covered in This Project
Create a query using Design view.
Add fields to a query.
Add criteria to a query.
Execute a query.
Save and test a query.
Save a copy of a query.
Add a parameter.
Use aggregate functions.
Use the Unique Values property.
Alternate Instruction for Microsoft 365 Apps iconThis 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.
Open the SanDiegoSailing-03.accdb database start file.
The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
Enable content in the database.
Create a new summary query in Design view. The Sailing Club wants to find out the total dollar value of the full day rentals, by boat, from the boats that have been rented. If a boat has been rented, a record displays in the SDRentals table.
Click the Query Design button [Create tab, Queries group] to open the Add Tables task pane.
Alternate Instruction for Microsoft 365 Apps iconClick the Query Design button [Create tab, Queries group] to open the Show Table dialog box.
Office 365 Update note icon NOTE: The Show Table dialog in your version of Microsoft Access may appear different due to Office 365 updates.
Select the SailboatFleet table and click the Add Selected Tables button.
Alternate Instruction for Microsoft 365 Apps iconSelect the SailboatFleet table and click the Add button.
Select the SDRentals table and click the Add Selected Tables button.
Alternate Instruction for Microsoft 365 Apps iconSelect the SDRentals table and click the Add button.
Click the Close button in the Add Tables task pane.
Alternate Instruction for Microsoft 365 Apps iconClick the Close button in the Show Table dialog box.
Increase the size of the table objects to display all of the fields.
Click the drop-down arrow in the first Field row cell of the query design grid and select FKBoatID.
Click the second cell in the Field row, click the drop-down arrow, and select BoatType.
Click the third cell in the Field row, click the drop-down arrow, and select FullDayRentalRate.
Click the fourth cell in the Field row, click the drop-down arrow, and select FourHourRental?.
Click the Totals button [Design tab, Show/Hide group].
Alternate Instruction for Microsoft 365 Apps iconClick the Totals button [Query Tools Design tab, Show/Hide group].
Click the Run button [Design tab, Results group] to execute the query. The query should open in Datasheet view and display 16 records (Figure 3-87). This query only shows boats that have been rented. At most a Boat ID appears in two rows; one row if the Four Hour Rental? box is checked and another row if the Four Hour Rental? box is not checked.
Alternate Instruction for Microsoft 365 Apps iconClick the Run button [Query Tools Design tab, Results group] to execute the query. The query should open in Datasheet view and display 16 records (Figure 3-87). This query only shows boats that have been rented. At most a Boat ID appears in two rows; one row if the Four Hour Rental? box is checked and another row if the Four Hour Rental? box is not checked.
Sailboat query results
Figure 3-87 Sailboat query results
Edit the query to add aggregate functions. Because you are looking only for rentals that were for a full day, use the “No” value on the FourHourRental? field.
Click the View button [Home tab, Views group] and select the Design View option to switch back to Design view of the query.
Click the Total row cell for the FullDayRentalRate field.
Click the drop-down arrow and select Sum.
Click the Total row cell for the FourHourRental? field.
Click the drop-down arrow and select Where. This causes the Show row check box for the FourHourRental? field to be deselected.
Click the Criteria row cell for the FourHourRental? field and enter No. The IntelliSense feature in Access may suggest the value of “Now” while you are typing. Press the Esc key to hide the list and then tab out of the field. The query window should look similar to Figure 3-88.
Query design grid with four fields. Total row contains Sum in the FullDayRentalRate field and Where in the FourHourRental? field, which also contains No in the Criteria row.
Figure 3-88 Query design grid for the summary query with criteria
Click the Run button. The query should open in Datasheet view and display eight records (Figure 3-89). The Boat ID now displays only once since the criteria limits the results only to the full day rentals.
Results from completed SummaryOfFullDayRentalsByBoat query
Figure 3-89 Results from completed SummaryOfFullDayRentalsByBoat query
Click the Save button and save the query as FullDayRentalsByBoatSummary.
Verify that that query works correctly.
Open the SDRentals table in Datasheet view.
Click the drop-down arrow in the Boat ID field name cell and select the Sort A to Z option.
Click the drop-down arrow in the Four Hour Rental? field name cell and select the Sort Cleared to Selected You can see that Boat ID 1010 has five full day rentals. From Figure 3-87 you know that the full day rate for that boat is $179.00 and 5 × $179 = $895.00. This matches the results of your query.
Click the Remove Sort button [Home tab, Sort & Filter group].
Close the SDRentals table. If prompted, do not save the changes to the table.
Save a copy of the query.
Click the Save As button [File Tab].
Select the Save Object As button and then click the Save As button.
Replace the suggested name with FullDayRentalsByBoatSummaryWithParameter. This second query will enable the Sailing Club to enter the date range for the summary query and also will count the number of rentals.
Edit the query to add additional fields and an aggregate function and parameters.
Click the Design View icon in the Status bar.
Drag the FullDayRentalRate field from the SailboatFleet table to the fifth column in the query design grid. (Yes, this field is in the query twice!)
Click the Total row cell for this field, click the drop-down arrow, and select Count.
Drag the RentalDate field from the SDRentals table to the sixth column in the query design grid.
Click the Total row cell for this field, click the drop-down arrow, and select Where. This causes the Show row check box for the RentalDate field to be deselected.
Click the Criteria row cell of the RentalDate field.
Right-click and select Zoom.
Type Between [Enter the Start Date] And [Enter the End Date] in the Zoom box to add the two parameters.
Click OK. The query window should look similar to Figure 3-90.
Query design grid with two additional fields added. Total row contains Count in the second FullDayRentalRate field and Where in the RentalDate field, which also contains a parameter expression in the Criteria row.
Figure 3-90 Query window with aggregate functions and a parameter
Click the Save button and save the changes to the query.
Test the query.
Click the Run button.
Enter 2/1/2020 in the Enter the Start Date box of the Enter Parameter Value dialog box.
Click OK.
Enter 2/28/2020 in the Enter the End Date box of the Enter Parameter Value dialog box.
Click OK. The query should open in Datasheet view and display the records shown in Figure 3-91.
Datasheet view of query results shows four records.
Figure 3-91 Query results with Sum and Count aggregate functions and parameter
Click the Save button to save the changes made to the query.
Close the query.
Review the query.
Reopen the query in Design view. Notice that Access has reordered the position of the fields. The two fields that use the Where option on the Total row have been moved to the right side of the query design grid. This does not affect the way the query runs.
Close the query.
Create a new query in Design view. The Sailing Club wants to find out what boat types have been rented so it can decide whether to adjust pricing or marketing of its boat types. If a boat has been rented, a record of that rental exists in the SDRentals table.
Click the Query Design button [Create tab, Queries group] to open the Add Tables task pane.
Alternate Instruction for Microsoft 365 Apps iconClick the Query Design button [Create tab, Queries group] to open the Show Table dialog box.
Office 365 Update note icon NOTE: The Show Table dialog in your version of Microsoft Access may appear different due to Office 365 updates.
Select the SDRentals table, press and hold the Shift key, select the SailboatFleet table, and click the Add Selected Tables button.
Alternate Instruction for Microsoft 365 Apps icon Select the SDRentals table, press and hold the Shift key, select the SailboatFleet table, and click the Add button.
Click the Close button in the Add Tables task pane.
Alternate Instruction for Microsoft 365 Apps iconClick the Close button in the Show Table dialog box.
Click the drop-down arrow in the first Field row cell in the query design grid and select FKBoatID.
Click the Sort row, click the drop-down arrow, and select Ascending.
Click the second cell in the Field row, click the drop-down arrow, and select BoatType.
Click the Run button [Design tab, Results group] to execute the query. The query should open in Datasheet view and display 28 records (Figure 3-92). Notice that in a number of instances the same Boat ID displays multiple times, once for each time that boat was rented.
Alternate Instruction for Microsoft 365 Apps iconClick the Run button [Query Tools Design tab, Results group] to execute the query. The query should open in Datasheet view and display 28 records (Figure 3-92). Notice that in a number of instances the same Boat ID displays multiple times, once for each time that boat was rented.
BoatID query results
Figure 3-92 BoatID query results
Edit the query to display Unique Values.
Click the Design View icon in the Status bar to switch back to Design view of the query.
Click the Property Sheet button [Design tab, Show/Hide group] to open the Property Sheet.
Alternate Instruction for Microsoft 365 Apps iconClick the Property Sheet button [Query Tools Design tab, Show/Hide group] to open the Property Sheet.
Click anywhere in the Query Window so that the Selection type in the Property Sheet displays Query Properties.
Click the Unique Values property box and select Yes. The query window should look similar to Figure 3-93.
Query Design window shows both tables in the top half, the two fields added to the query in the bottom half, and the Property Sheet open to the right.
Figure 3-93 Set the Unique Values property in the Property Sheet of the query
Close the Property Sheet.
Click the Run button. The query should open in Datasheet view and display 12 records (Figure 3-94). Each Boat ID now displays only once, but the Boat Types are still repeated.
Query results with repeated BoatType values
Figure 3-94 Query results with repeated BoatType values
Edit the query so the Boat Type displays only once. The Boat Type is displaying more than once because the FKBoatID field is different for each boat.
Click the View button [Home tab, Views group] and select the Design View option to switch back to Design view.
Click the Sort row of the FKBoatID field, click the drop-down arrow, and select (not sorted).
Deselect the Show row check box for the FKBoatID field.
Click the Run button. The query should display the five boat types that have been rented at least once (Figure 3-95.)
Unique records for BoatType
Figure 3-95 Unique records for BoatType
Click the Save button and save the query as BoatTypesRented.
Close the query.
Close the database.
Upload and save your project file.
Submit project for grading.
by admin | Nov 29, 2022 | Computer Science
This is a 10 page research based writing about SolarWimds hack that happened back in 2020. There’s no instructions to follow since it’s research based. Make sure to cite all the sources used.
by admin | Nov 29, 2022 | Computer Science
This is a 10 page research based writing about SolarWimds hack that happened back in 2020. There’s no instructions to follow since it’s research based. Make sure to cite all the sources used.
by admin | Nov 28, 2022 | Computer Science
Implement regression with gradient descent algorithm, by modifying ex11-4.py.
– Do not use gradient tape function of tensorflow. Apply calculated formula of MSE gradients.
– Use data of softdrink.csv
– Capture code and result into a pdf file. Submit together with the code file of .py.
by admin | Nov 28, 2022 | Computer Science
Databases play a vital role in empowering AI-based applications. Imagine an AI-enabled robot that relies on historical and raw data to make intelligent decisions. The data are stored in ten scattered heterogeneous (structured, unstructured, and graph) databases with different access times due to different performance limitations and geographical locations around the globe.
This discussion invites you to architect a support system for the robot mentioned above to find its required data among the databases and access the data scattered around the globe in the shortest possible time
Review and understand database applications, especially for caching and in-memory storage
Design a simple block diagram showing the system components and about 550 words explaining components and their connections. Also, explain the measures you propose to facilitate the data discovery and to improve access time. For data discovery, it is suggested to utilize methods such as data cataloging, indexing, and aggregation. For the robot performance improvement, consider an intermediate in-memory database for caching frequently accessed data. The cache number and locations are important architectural choices that could affect cost, complexity, and performance. If necessary, feel free to make assumptions on robot processing power, connection bandwidths, and database performances. You may wish to use www.draw.io for drawing your block diagrams.
