Databases Lab讲解、辅导SQL、SQL编程语言讲解、辅导LMS via
- 首页 >> Database Network & Databases Lab
[15 points/15% of final grade]
Description of Topic
This assignment will give you more practice working with network and database concepts.
Assignment Submission
Due: 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 Details
1.[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: lis654
Password: PYGqU8KC99hR
You will be prompted to enter the credentials twice!
3)Click on the " lis654_hw2" database in the left navigation
4)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 name
c.[1pt] Write a SQL query to retrieve all the Untitled works created since January 1, 2007
d.[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.
[15 points/15% of final grade]
Description of Topic
This assignment will give you more practice working with network and database concepts.
Assignment Submission
Due: 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 Details
1.[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: lis654
Password: PYGqU8KC99hR
You will be prompted to enter the credentials twice!
3)Click on the " lis654_hw2" database in the left navigation
4)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 name
c.[1pt] Write a SQL query to retrieve all the Untitled works created since January 1, 2007
d.[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.