Network & Databases Lab[15 points/15% of final grade]Description of TopicThis assignment will give you more practice working with network and database concepts. Assignment SubmissionDue: See schedule in syllabus for specific date. To submit, first complete the assignment below and then upload to the LMS via the Week 6 assignment link, as a Word document or PDF. Assignment Details1.[1pt] Explain the following statement: The Internet is fast enough to mimic synchronous communication. Make sure to use the appropriate technical terminology in explaining your answer. 2.[1pt] Explain the difference between client computers and server computers on the Internet. Make sure to use the appropriate technical terminology in your answer. Give an example of a client and server interaction. 3.[2pt] As discussed in class, the ping and traceroute commands are computer network tools used to test whether a particular host is reachable across an IP network and the path taken. If you are using Windows, bring up a Command Prompt window. Then, enter: ping www.google.com If you are using a Mac, start the Terminal (Applications > Utilities > Terminal). Then, enter: ping www.google.com a.What is the IP address of www.google.com? How long did it take (round-trip time)? b.Now, try to ping the website of Japan Airlines: ping www.jal.co.jp What is the IP address of www.jal.co.jp? How long did it take (round-trip time)? c.Did it take more time or less time to send a packet to the Japan Airlines url or the Google url? Why? Make sure to use the appropriate technical terminology in your answer.d.In the same Terminal or Command Prompt window enter: tracert www.loc.gov on Windows or traceroute www.loc.gov on Mac. How many hops did it take to reach the destination? Explain what a hop is, using the appropriate technical terminology. 4.[6pts] Create an entity-relationship diagram (ERD) for a relational database design for a small library to store information about their collection, their patrons, and the items checked-out by patrons. Make sure to identify all your tables’ keys (primary and/or foreign), include names for all your tables, and the tables columns. You may sketch and photograph your design, then paste into the following section, or use the software of your choice to represent your diagram. Use appropriate Crow’s Foot Notation to draw your ERD.5.Below is a schema for a small relational database that stores information about artists and their work. You will log into a web-accessible MySQL database to answer the remaining questions. Login instructions Database Schema (for reference)1)Go to - https://webdevdbcourses.prattsi.org/phpmyadmin/ 2)Enter the following credentials:Username: lis654Password: PYGqU8KC99hRYou will be prompted to enter the credentials twice!3)Click on the lis654_hw2 database in the left navigation4)Click on the SQL tab to enter and work on your SQL queries for the following questions a.[2pts] What is the function of primary and foreign keys? What are the primary key(s) and foreign key(s) in each of the three tables?b.[1pt] Write a SQL query to retrieve only the the name of all prints in the Artworks table sorted alphabetically by namec.[1pt] Write a SQL query to retrieve all the Untitled works created since January 1, 2007d.[1pt] Write a SQL query to retrieve the name of the artwork and its media type using a JOIN. Your output table in phpMyAdmin should look like the following example table:Rubric A/Excellent [15-14pts] B/Average[13-12pts] C/Below Average[11-10.5pts] D/Poor[10-0pts]Explanation & Understanding Where appropriate, answers are descriptive and detailed, demonstrating clear understanding and reflection on technical concepts. Where appropriate, answers are mostly descriptive and detailed, demonstrating some understanding and reflection on technical concepts. Answers are somewhat descriptive, demonstrating basic understanding of technical concepts. Answers are generally not descriptive and do not demonstrate understanding of technical concepts.Instructions All directions followed exactly and sections fully completed in depth. All directions followed and sections fully completed. Most directions followed. Few or no directions followed.本团队核心人员组成主要包括硅谷工程师、BAT一线工程师，精通德英语！我们主要业务范围是代做编程大作业、课程设计等等。我们的方向领域：window编程 数值算法 AI人工智能 金融统计 计量分析 大数据 网络编程 WEB编程 通讯编程 游戏编程多媒体linux 外挂编程 程序API图像处理 嵌入式/单片机 数据库编程 控制台 进程与线程 网络安全 汇编语言 硬件编程 软件设计 工程标准规等。其中代写编程、代写程序、代写留学生程序作业语言或工具包括但不限于以下范围:C/C++/C#代写Java代写IT代写Python代写辅导编程作业Matlab代写Haskell代写Processing代写Linux环境搭建Rust代写Data Structure Assginment 数据结构代写MIPS代写Machine Learning 作业 代写Oracle/SQL/PostgreSQL/Pig 数据库代写/代做/辅导Web开发、网站开发、网站作业ASP.NET网站开发Finance Insurace Statistics统计、回归、迭代Prolog代写Computer Computational method代做因为专业，所以值得信赖。如有需要，请加QQ：99515681 或邮箱：99515681@qq.com 微信：codehelp
网友评论