1 of 3 Create a database to track laptops and iPads loaned to students. The requirements...

Transcribed Image Text:

1 of 3 Create a database to track laptops and iPads loaned to students. The requirements are: Student name, address, email, phone and guardian. Devices including device type, mac address, memory, storage School name, address Students are assigned to schools Students are assigned devices. Identify when the device is assigned to the student and when it's returned. Questions Create SQL to answer the following queries. Identify all devices assigned to students at PS 105. Display the student name and device type. Identify the number of devices assigned by school. Display 2 columns: school name and number of devices. Sort by school name. Utilize a function to answer this question. Identify devices assigned to student Bo Li. Display the student name, school and device name and assigned date. . Identify students without devices. Display the student name and email. Use a nested select to answer this question. Identify devices that were not returned. Display the student name and device type. Identify the total number of students by borough. Display 1 row for each borough. Use a function to answer this question. Display the structure of ALL tables using SQL Describe. 1 of 3 Create a database to track laptops and iPads loaned to students. The requirements are: Student name, address, email, phone and guardian. Devices including device type, mac address, memory, storage School name, address Students are assigned to schools Students are assigned devices. Identify when the device is assigned to the student and when it's returned. Questions Create SQL to answer the following queries. Identify all devices assigned to students at PS 105. Display the student name and device type. Identify the number of devices assigned by school. Display 2 columns: school name and number of devices. Sort by school name. Utilize a function to answer this question. Identify devices assigned to student Bo Li. Display the student name, school and device name and assigned date. . Identify students without devices. Display the student name and email. Use a nested select to answer this question. Identify devices that were not returned. Display the student name and device type. Identify the total number of students by borough. Display 1 row for each borough. Use a function to answer this question. Display the structure of ALL tables using SQL Describe.