Categories
Computer Science

The Online Food Ordering Database Final Project: Must include CreateDB.sql and P

The Online Food Ordering Database Final Project:
Must include CreateDB.sql and PopulateData.sql scriipts.
Must include a User Guide with the URL for the screencast video presentation.( For this please just send me a scriipt and I’ll make the video part)
Must include a Screencast that is eight to 10 minutes in length.
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must document all sources in APA style as outlined in UAGC’s The Writing Center Links to an external site..
Prior to beginning work on this assignment, it is recommended that you review all of your previous readings to better assist you with completing the Final Project.
The Final Project for this course is an accumulation of previous weeks’ assignments in which you will utilize all of the skills you have acquired in this course to implement an Online Food Ordering Database using the latest PHPMyAdmin version. In each week of the course, you performed various tasks toward creating the Online Food Ordering Database. Now you will create SQL scriipts that regenerate the tables, relationships, and data of the Online Food Ordering Database.
In Week 1 (Task 1), you defined the system stakeholder, and you recognized the importance of understanding organizational stakeholders for database design success. In Week 2 (Task 2), you provided a complete Chen ER diagram design and corresponding list of tables. In Week 3 (Task 3), you normalized your database to the third normalization form. In Week 4 (Task 4), you used the latest version of MySQL to implement the tables and relationships of the database you normalized in Week 3. Finally, in Week 5 (Task 5), you added “for insert” and “delete” triggers to the “tbl_employee” table to track which employee updated the Online Food Ordering Database.
Now you will incorporate all the feedback you received for the work you created in previous weeks and
Provide a MySQL scriipt to recreate the final database you implemented in the previous tasks.
The scriipt should recreate all the tables, constraints, views, and triggers you have implemented. Name the SQL scriipt “CreateDB.sql”
Provide a MySQL scriipt to add several rows to each of the tables you created.
Do your best to use data and formatting that mimics what is used in a real online ordering system (i.e., emails, first name, last name, credit card information, etc.). Name the SQL scriipt “PopulateData.sql”
Create a step-by-step user guide on how to run the above scriipts to create the database from scratch using the “CreateDB.sql” and to populate some data into the generated tables using the “PopulateData.sql.”
Title this document “User Guide.” Your user guide should be detailed enough to include your comments describing the SQL functionalities and overall tasks, along with screenshots of all steps and their outputs.
Create a screencast video presentation using Screencast-O-Matic in which you walk the instructor through your Online Food Ordering Database.
(Quick-start guides for Screencast-O-Matic Links to an external site.are provided for your convenience.) Be sure to describe the concepts related to the design and management of your database.
Your screencast should be eight to 10 minutes in length. (It is highly recommended that you create a scriipt and/or speaker’s notes to ensure that your screencast will meet the time requirements. This will also allow you to practice your presentation prior to recording it.)
Once your screencast has been created, make sure to include the URL for your screencast at the end of your User Guide.
Once you have completed the final database with all associated scriipts, save them into a zip folder, and submit it to the Week 5 Zip File Submission page. Your zip folder should include two SQL scriipts (CreateDB.sql and PopulateData.sql). If you need more guidance, review the Zip File Quick Start Guide Download Zip File Quick Start Guide. Next, submit your User Guide through the Waypoint grading system. Your instructor will run your SQL scriipts following your instruction to ensure that the SQL scriipts you provided generate the Online Food Ordering Database and populate data in its tables.

Categories
Computer Science

The following are your main tasks • Define the inclusion and exclusion criteria

The following are your main tasks
• Define the inclusion and exclusion criteria
• Search for studies
• Select studies (do not analyze all types of papers but only those that report studies whatever they are
• Extract data (answers to each question + some statistical analysis/descriiptive)
• Assess quality (your opinion/discussions of the findings)
• Conclusion – Synthesize and present final results

Your task is to compile a list of 40 references from well-known databases (IEEE, ACM, etc…) in which you addressed three questions that you need to define. Research questions should be well formulated and very specific.
————————–
Questions (they need to be rewritten to be formulated and very specific)
Does the a shift on the security model from centralized top-down infrastructure to a decentralized trust model is required?
Does the edge computing improve scalability and reliability of a network by having decentralized nodes?
what are the improvement on privacy of citizens if data stay on edge of political/country border and only sending then minimum amount of data to servers outside?
——-
example SLR attached, charts should look like page 8 of the pdf
Distribution of article pie chart with be split into each journal and not like the example with one segment for all jorunals

Categories
Computer Science

Prior to beginning work on this assignment, review Chapter 8: Advanced SQL from

Prior to beginning work on this assignment, review Chapter 8: Advanced SQL from the course text and the Using Triggers Links to an external site. presentation. This week you will develop the fourth task for the Online Food Ordering Database Project due this week.
For this assignment, you will continue to use PHPMyAdmin to
Add a new table to your database. The table should be called tbl_employee_audit and should contain two fields (id, audit_data).
Add “for insert”and “delete triggers” to the “tbl_employee” table.
The insert trigger is triggered when a new employee is added to the “tbl_employee” table. The trigger then takes the employee_id as a parameter and adds the following data as a new record to the tbl_employee_audit.
id
audit_data
1
New employee with ID = 1221 was added on Sep 21, 2016
The delete trigger is triggered when a row in the “tbl_employee” table is deleted. The trigger then takes employee_id as a parameter and adds the following data as a new record to the tbl_employee_audit.
id
audit_data
6
Employee with ID = 1221 was deleted on Sep 25, 2016
In your initial post,
Attach a screen shot of the SQL query used to create the tbl_employee_audit, updated ER diagram, and SQL queries you used to generate the “for insert” and “for delete” triggers.
Attach all the SQL queries you created for this assignment.
Provide a short descriiption of the use and different type of triggers in MySQL.

Categories
Computer Science

The following are your main tasks • Define the inclusion and exclusion criteria

The following are your main tasks
• Define the inclusion and exclusion criteria
• Search for studies
• Select studies (do not analyze all types of papers but only those that report studies whatever they are
• Extract data (answers to each question + some statistical analysis/descriiptive)
• Assess quality (your opinion/discussions of the findings)
• Conclusion – Synthesize and present final results

Your task is to compile a list of 40 references from well-known databases (IEEE, ACM, etc…) in which you addressed three questions that you need to define. Research questions should be well formulated and very specific.
————————–
Questions (they need to be rewritten to be formulated and very specific)
Does the a shift on the security model from centralized top-down infrastructure to a decentralized trust model is required?
Does the edge computing improve scalability and reliability of a network by having decentralized nodes?
what are the improvement on privacy of citizens if data stay on edge of political/country border and only sending then minimum amount of data to servers outside?
——-
example SLR attached, charts should look like page 8 of the pdf
Distribution of article pie chart with be split into each journal and not like the example with one segment for all jorunals

Categories
Computer Science

The Online Food Ordering Database Final Project: Must include CreateDB.sql and P

The Online Food Ordering Database Final Project:
Must include CreateDB.sql and PopulateData.sql scriipts.
Must include a User Guide with the URL for the screencast video presentation.( For this please just send me a scriipt and I’ll make the video part)
Must include a Screencast that is eight to 10 minutes in length.
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must document all sources in APA style as outlined in UAGC’s The Writing Center Links to an external site..
Prior to beginning work on this assignment, it is recommended that you review all of your previous readings to better assist you with completing the Final Project.
The Final Project for this course is an accumulation of previous weeks’ assignments in which you will utilize all of the skills you have acquired in this course to implement an Online Food Ordering Database using the latest PHPMyAdmin version. In each week of the course, you performed various tasks toward creating the Online Food Ordering Database. Now you will create SQL scriipts that regenerate the tables, relationships, and data of the Online Food Ordering Database.
In Week 1 (Task 1), you defined the system stakeholder, and you recognized the importance of understanding organizational stakeholders for database design success. In Week 2 (Task 2), you provided a complete Chen ER diagram design and corresponding list of tables. In Week 3 (Task 3), you normalized your database to the third normalization form. In Week 4 (Task 4), you used the latest version of MySQL to implement the tables and relationships of the database you normalized in Week 3. Finally, in Week 5 (Task 5), you added “for insert” and “delete” triggers to the “tbl_employee” table to track which employee updated the Online Food Ordering Database.
Now you will incorporate all the feedback you received for the work you created in previous weeks and
Provide a MySQL scriipt to recreate the final database you implemented in the previous tasks.
The scriipt should recreate all the tables, constraints, views, and triggers you have implemented. Name the SQL scriipt “CreateDB.sql”
Provide a MySQL scriipt to add several rows to each of the tables you created.
Do your best to use data and formatting that mimics what is used in a real online ordering system (i.e., emails, first name, last name, credit card information, etc.). Name the SQL scriipt “PopulateData.sql”
Create a step-by-step user guide on how to run the above scriipts to create the database from scratch using the “CreateDB.sql” and to populate some data into the generated tables using the “PopulateData.sql.”
Title this document “User Guide.” Your user guide should be detailed enough to include your comments describing the SQL functionalities and overall tasks, along with screenshots of all steps and their outputs.
Create a screencast video presentation using Screencast-O-Matic in which you walk the instructor through your Online Food Ordering Database.
(Quick-start guides for Screencast-O-Matic Links to an external site.are provided for your convenience.) Be sure to describe the concepts related to the design and management of your database.
Your screencast should be eight to 10 minutes in length. (It is highly recommended that you create a scriipt and/or speaker’s notes to ensure that your screencast will meet the time requirements. This will also allow you to practice your presentation prior to recording it.)
Once your screencast has been created, make sure to include the URL for your screencast at the end of your User Guide.
Once you have completed the final database with all associated scriipts, save them into a zip folder, and submit it to the Week 5 Zip File Submission page. Your zip folder should include two SQL scriipts (CreateDB.sql and PopulateData.sql). If you need more guidance, review the Zip File Quick Start Guide Download Zip File Quick Start Guide. Next, submit your User Guide through the Waypoint grading system. Your instructor will run your SQL scriipts following your instruction to ensure that the SQL scriipts you provided generate the Online Food Ordering Database and populate data in its tables.

Categories
Computer Science

Cloud computing is fundamentally about the delivery of computing services, platf

Cloud computing is fundamentally about the delivery of computing services, platforms, and infrastructures using the Internet rather than designing, building, and operating and maintaining enterprise information systems on premises.
Discuss how an employer could use cloud computing services. Frame your discussion in terms of software as a service (SaaS), platform as a service (PaaS), infrastructure as a service (IaaS), or anything as a service (XaaS). Be sure to explicitly discuss which of an organization’s business processes are supported by a cloud deployment, such as how the cloud deployment serves the organization’s strategic business goals.
Finally, please explore the availability, reliability, and performance metrics that you think need to be measured to ensure that an organization is properly managing its cloud deployment.

Categories
Computer Science

I only need: Stage 3: System Design Specification completed by Feb 5, 2023. I

I only need: Stage 3: System Design Specification completed by Feb 5, 2023. I have attached the other stages so you can understand the assignment. Before you begin this assignment, be sure you have read the Case Study and all assignments for this class, especially Stage 4: Final System Report. Please see attached: Stage 1 thru Stage 4. DFD tips can help you with the Data Flow Diagram (DFD). I have included the first and second assignment Stage 1: Preliminary Investigation Stage 2: Requirements Specification Report to help with writing stage 3.
References:
Dr. Jawahar. (2013). System Analysis and Design (6th ed.). Prof. Dharminder Kumar.
Benali, A., & Asri, B. E. (2021). Towards Rigorous Selection and Configuration of Cloud
Services: Research Methodology.
https://doiorg.ezproxy.umgc.edu/10.5281/zenodo.4431076
Biscobing, J. (2019, September 11). What is entity relationship diagram (ERD)? –
Definition from WhatIs.com. SearchDataManagement.
https://searchdatamanagement.techtarget.com/definition/entity-relationshipdiagram-ERD
CHAI, W. (2021, February 10). What is SaaS (Software as a Service)? Everything you
need to know. SearchCloudComputing.
https://searchcloudcomputing.techtarget.com/definition/Software-as-a-Service
Stage 3: System Design Specification
11
Dr. Jawahar. (2013). System Analysis and Design (6th ed.). Prof. Dharminder Kumar.

Categories
Computer Science

Cloud computing is fundamentally about the delivery of computing services, platf

Cloud computing is fundamentally about the delivery of computing services, platforms, and infrastructures using the Internet rather than designing, building, and operating and maintaining enterprise information systems on premises.
Discuss how an employer could use cloud computing services. Frame your discussion in terms of software as a service (SaaS), platform as a service (PaaS), infrastructure as a service (IaaS), or anything as a service (XaaS). Be sure to explicitly discuss which of an organization’s business processes are supported by a cloud deployment, such as how the cloud deployment serves the organization’s strategic business goals.
Finally, please explore the availability, reliability, and performance metrics that you think need to be measured to ensure that an organization is properly managing its cloud deployment.

Categories
Computer Science

Reference APA format. I have uploaded the assignment and a rubric paper, let me

Reference APA format. I have uploaded the assignment and a rubric paper, let me know if you need more information

Categories
Computer Science

Please let me know if you need more information and once you approve the order I

Please let me know if you need more information and once you approve the order I will provide you with netlab login information