Question 1: Discuss how Ultra Wide Band (UWB) works, and where it is used today in the real-world. What companies are making UWB-based products?
Question 2: Explain in detail the differences between ad-hoc mode and infrastructure mode for 802.11. Give examples of where each mode could be used.
Part 1: Write a technical report about Bluetooth. Be sure to discuss its history, the evolution of Bluetooth standards, how the physical layer (RF) works, what its performance and speed limits are, security issues, and what are its current uses and applications today. The more detail, the better. Your report should be well-organized.
Part 2: Write a very detailed, in-depth technical report about the 802.11 standard. Discuss all the versions of the standard, such as 802.11a, 802.11b, 802.11g, 802.11n, 802.11ac. Discuss the physical layer for each. Compare each standard. Explain ad-hoc and infrastructure modes in detail. Discuss the frequencies of operation, and the data rates, and the available channels, etc., of each standard. Don't forget to discuss topics such as 802.11 security and MIMO. Be as thorough as possible. Be very clear and very organized in your report. Use proper grammar and spelling. Use diagrams and figures, which you can create yourself, and also take from any source. You should use many sources.
For this assignment, you are going to answer the following questions using the Structured Query Language (SQL) language. Please do not include any screenshots or results- just list the queries.
Question 1: Using the CREATE TABLE statement, create a table called City with the following columns:
|
Column Name
|
Data Type
|
Accepts NULL
|
|
ID
|
INT (Primary Key)
|
No
|
|
Name
|
VARCHAR(50)
|
No
|
|
Region
|
VARCHAR(50)
|
Yes
|
|
Population
|
INT
|
Yes
|
|
Year_Established
|
INT
|
Yes
|
Question 2: Write a query to select all unique Region values in the City table.
Question 3: Write a query to select the Name values for all records where their Region is equal to Northeast.
Question 4: Write a query that returns all records where their region is equal to Midwest or have a Population of less than 1,000,000.
Question 5: Write a query that returns all records that have a Population of more than 50,000 and whose Year_Established is NOT NULL.
What to Submit: To submit this assignment, save your answers in a Word document (or any other rich word processing program that allows you to create .doc documents), save it as Assignment6FN (where F is your first initial and L is your last initial), and submit them to me via the Blackboard.