Categories
Computer Science

use the video link below to make a poster presentation and an abstract https://

use the video link below to make a poster presentation and an abstract

Categories
Computer Science

Three questions. With sql, ER- diagrams, and relation/relational algebras. Each

Three questions. With sql, ER- diagrams, and relation/relational algebras. Each questions with 3 – 5 sub-questions. Make this one more logical and cleaner than the old ones. create a solution page .

Categories
Computer Science

Prior to beginning work on this assignment, read Chapter 7: Introduction to Stru

Prior to beginning work on this assignment, read Chapter 7: Introduction to Structure Query Language (SQL) from the course text. This week you will develop the fourth task for the Online Food Ordering Database Project due in Week 5. In Week 1, you were asked to start reviewing the latest version of PHPMyAdmin.
PHPMyAdmin Links to an external site. is a free open source application that is designed to administer the database management system (DBMS) – MySQL. PHPMyAdmin is a web-based interface with which you can administer your server MySQL, run commands, and view the contents of tables and databases through a browser.
For this assignment, you will use PHPMyAdmin to implement the normalized database you did in the Week 3 assignment including the following:
Implement all tables, fields, and relationships, and add appropriate constrains on some of the fields (e.g., numbers cannot be negative; dates cannot be in the future unless the requirement specify otherwise).
Assign primary and foreign keys to ensure data integrity and perform faster queries.
Generate an ER diagram from the implemented database.
Write SQL queries to add some data into the implemented tables.
Once you have completed Task 4, you must provide the following in a Word document and submit through the Waypoint grading system:
A screen shot of all developed tables in your database
A screen shot of the ER diagram
A screen of the SQL queries you used to populate data. Be sure also to provide a screen shot for the tables after the data is populated. Note: You should use “Select * from table_name” to view the content of the table
In addition to the screen shots,
Describe Data Definition Language (DDL) insert, update, delete. Your descriiption should be a minimum of 600 words.
Provide at least one example.
Describe inner join, sum, and ordered by. Your descriiption should be a minimum of 600 words.
Provide at least one example.
The Online Food Ordering Database – Task 4 paper
Must include a screen shot, short descriiption, and examples of Task 4.
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 use at least one scholarly, peer-reviewed, and/or credible sources in addition to the course text.
The Scholarly, Peer Reviewed, and Other Credible Sources Links to an external site.table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
Must document all sources in APA style as outlined in the UAGC Writing Center.

Categories
Computer Science

One of our learning challenges this week is to grow in our ability to produce ne

One of our learning challenges this week is to grow in our ability to produce network diagrams with professional quality production values. Please carefully review the Network Diagram Examples [PDF] document that contains six examples of flawed network diagrams which represent a range of aesthetic and technical approaches to creating network diagrams.
Discuss your ideas about at least three of the example diagrams, and explain your rationale for features that you do and do not like.
Finally, include a reflection on your own diagramming skills or experience, and express your intentions for how you will seek to improve your skills

Categories
Computer Science

“Great news,” reports Eliza, your CTO. “Our cloud solutions document has been re

“Great news,” reports Eliza, your CTO. “Our cloud solutions document has been received really well, and everyone is pleased with our team’s work. This will advance the company’s competitive edge.”
“I’ve been thinking,” says Steve, one of your co-workers. “Don’t you think we could push our network even further using a software-defined networking (SDN) architecture? It would really help facilitate changes and increase reliability…”
“We don’t have time to try every new fad out there,” says Eliza. “We could waste resources following trends that are obsolete within the year.”
“But it isn’t a fad,” says Steve.
“Look, I’ll be honest. I’m swamped here and haven’t read up on SDN,” Eliza admits. “Why don’t you pick some people on the team to put together a white paper on this architecture and we’ll see where we go from there.”
“On it!” says Steve. And then he turns to you: “I could use some help on this. Can you lend me a hand?”

Categories
Computer Science

Overview Information technologists, particularly network administrations, routin

Overview
Information technologists, particularly network administrations, routinely document networks by creating diagrams. A good network diagram may represent the primary features and design of a particular network’s logical and physical configuration.
In this assignment, you create three diagrams that depict various parts of a coffee retailer’s cloud-managed network. Your diagrams should depict how the coffee shop retailer might effectively configure its LANs, WLAN, and WAN.
Preparation
Read the Coffee Retailer Descriiption document located in the resources.
Directions
Complete the following two parts of the assignment:
Part 1 – Network Diagrams
Draw diagrams that reasonably depict a network infrastructure that will enable Coffee Retailer to achieve the company’s strategic goal of offering customers public wireless Internet access. Make sure to list any assumptions regarding the company or your design that you need to make in order to design and draw a realistic diagram.
Make sure to do the following:
Create a logical wide area network (WAN) diagram showing major enterprise locations including the corporate headquarters, one typical retail location, and a cloud service provider.
Create a physical WAN diagram that places core and distribution-layer routers and switches in locations that optimize network performance. Justify your choices.
Create a physical local area network (LAN) and wireless LAN (WLAN) diagram for a typical retail location.
Evaluate how well one of your diagrams depicts a working cloud-based solution for Coffee Retailer. What are the most important criteria?
Submission Requirements
Submit a single Word document with both parts of this assignment.
Font: Times New Roman, 12 point.
Format: Double spaced lines. Use current APA style and format.

Categories
Computer Science

One of our learning challenges this week is to grow in our ability to produce ne

One of our learning challenges this week is to grow in our ability to produce network diagrams with professional quality production values. Please carefully review the Network Diagram Examples [PDF] document that contains six examples of flawed network diagrams which represent a range of aesthetic and technical approaches to creating network diagrams.
Discuss your ideas about at least three of the example diagrams, and explain your rationale for features that you do and do not like.
Finally, include a reflection on your own diagramming skills or experience, and express your intentions for how you will seek to improve your skills

Categories
Computer Science

Prior to beginning this assignment, review Chapter 7: Introduction to Structure

Prior to beginning this assignment, review Chapter 7: Introduction to Structure Query Language (SQL) from the course text and the 8.1 Visual SQL Editor Links to an external site.web page. In addition, you may also want to complete problems 1 to 8 in Chapter 7. These problems will assist you in completing this interactive assignment.
For this interactive assignment, you will create three MySQL database tables and write SQL scriipts to read, insert, and delete data. The first database table will contain the names of at least four of your favorite movies. The second table will be a list of actors who appear in the movies. The third table will be an associative table that describes the relationship between the actors and their movies (which actors appear in which movies). Actors and movies have a “many-to-many relationship,” meaning an actor can be in multiple movies and a movie can have multiple actors.
Use the MySQL Database Instructions Download MySQL Database Instructionsto create the three tables.
Once you have completed your three tables, create a “join” statement that joins data from all three tables. Remember that field names used in more than one table (ASIN, ActorID) must be fully qualified (i.e., dvdtitle, ASIN).
The previous SQL query returns a separate record for each actor. Provide a way to group results from several records into a single row.
General guidelines for this interactive assignment:
String values in SQL statements are always enclosed within single quotes. ASIN and Title are both strings and require single quotes. For instance, your insert statement will look something like this:
$sql = “Insert into dvdtitles (asin, title, price) VALUES (‘$asin’, ‘$title’, $price)”;
SQL debugging tip: check your SQL statement before you execute it. Put the following line of code immediately before the mysql_query($strSQL) statement.
When retrieving ASIN from the querystring, remember that ASIN is a string, not a number.
Once you have completed the assignment, include the following in your initial post:
A Word document with screenshots of the tables you created.
A Word document with the SQL statements that you used to create the tables and populate them with data.
Explain how you grouped results from several records into a single row.

Categories
Computer Science

Prior to beginning work on this assignment, read Chapter 7: Introduction to Stru

Prior to beginning work on this assignment, read Chapter 7: Introduction to Structure Query Language (SQL) from the course text. This week you will develop the fourth task for the Online Food Ordering Database Project due in Week 5. In Week 1, you were asked to start reviewing the latest version of PHPMyAdmin.
PHPMyAdmin Links to an external site. is a free open source application that is designed to administer the database management system (DBMS) – MySQL. PHPMyAdmin is a web-based interface with which you can administer your server MySQL, run commands, and view the contents of tables and databases through a browser.
For this assignment, you will use PHPMyAdmin to implement the normalized database you did in the Week 3 assignment including the following:
Implement all tables, fields, and relationships, and add appropriate constrains on some of the fields (e.g., numbers cannot be negative; dates cannot be in the future unless the requirement specify otherwise).
Assign primary and foreign keys to ensure data integrity and perform faster queries.
Generate an ER diagram from the implemented database.
Write SQL queries to add some data into the implemented tables.
Once you have completed Task 4, you must provide the following in a Word document and submit through the Waypoint grading system:
A screen shot of all developed tables in your database
A screen shot of the ER diagram
A screen of the SQL queries you used to populate data. Be sure also to provide a screen shot for the tables after the data is populated. Note: You should use “Select * from table_name” to view the content of the table
In addition to the screen shots,
Describe Data Definition Language (DDL) insert, update, delete. Your descriiption should be a minimum of 600 words.
Provide at least one example.
Describe inner join, sum, and ordered by. Your descriiption should be a minimum of 600 words.
Provide at least one example.
The Online Food Ordering Database – Task 4 paper
Must include a screen shot, short descriiption, and examples of Task 4.
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 use at least one scholarly, peer-reviewed, and/or credible sources in addition to the course text.
The Scholarly, Peer Reviewed, and Other Credible Sources Links to an external site.table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
Must document all sources in APA style as outlined in the UAGC Writing Center.

Categories
Computer Science

1. Understanding of base number system (base 2, base 10, base 16) all 3 base num

1. Understanding of base number system (base 2, base 10, base 16) all 3 base number systems are clearly represented and explained. Some evidence of why hexadecimal is used in data representation has been given.
2. (Converting binary number to decimal) A concise step by step process accurately showing the conversion of a binary byte to decimal value.
3. (Converting decimal numbers to binary) A clear step by step subtraction method explains to convert a decimal value (above 255) to binary with references to checking outcome.
4. (Converting hexadecimal and decimal values using the binary nibble method) A clear modeled example of converting decimal to hexadecimal with nibble method is accurate and clearly explained. The base 16 mathematical check (16^1 + 16^0) has been shown.