A software system will be developed to manage the wireless sensor networks. This system will allow...

   

Transcribed Image Text:

A software system will be developed to manage the wireless sensor networks. This system will allow users to perform the followings: defining sensors, defining routers which consist of one or more sensors, defining coordinators which consist of one or more routers, and defining wireless sensor networks which consist of one or more coordinators. A sensor can measure more than one value. One of the most important responsibilities of the system is to store sensor measurements instantly within the database. Wireless sensor networks are established with the aim of measuring data in different domains such as agriculture, livestock, smart home, smart city etc. The router and coordinator devices are located in a certain address that is in a combination of country, city, county, and districts. In addition to the explanations above, the following requirements have been determined in this system. Design and create the most appropriate database to meet these requirements with T-SQL codes. Requirements: 1. The following information should be stored about the sensors: Name Definition 2. The following data regarding sensor measurement types should be stored in the system. Name a. b. a. b. Abbreviation 3. The following data should be stored regarding the definitions of sensor measurements: Which sensor does it belong to? Which sensor type it belongs to a. b. C. Data type of measurement 4. The following data regarding sensor measurements should be stored in the system: Which sensor does it belong to? Which router does it belong to a. b. C. d. e. Measurement type The value of the measurement The date and time of the measurement 5. The following data regarding routers should be stored in the system: Name Description a. b. C. d. e. g. h. i. j. a. b. C. 6. The following data regarding the coordinators should be stored in the system: Name d. e. g. h. a. b. C. Country City County District The latitude The longitude 7. The following data regarding wireless sensor networks should be stored in the system. Name d. The latitude The longitude e. f. Which coordinator does it belong to? The sensors that the router has Description Country City County District Description Domain (Agriculture, livestock, smart home, smart city etc.) Status(Active/Passive) Created date and time The coordinators that wireless sensor network has A software system will be developed to manage the wireless sensor networks. This system will allow users to perform the followings: defining sensors, defining routers which consist of one or more sensors, defining coordinators which consist of one or more routers, and defining wireless sensor networks which consist of one or more coordinators. A sensor can measure more than one value. One of the most important responsibilities of the system is to store sensor measurements instantly within the database. Wireless sensor networks are established with the aim of measuring data in different domains such as agriculture, livestock, smart home, smart city etc. The router and coordinator devices are located in a certain address that is in a combination of country, city, county, and districts. In addition to the explanations above, the following requirements have been determined in this system. Design and create the most appropriate database to meet these requirements with T-SQL codes. Requirements: 1. The following information should be stored about the sensors: Name Definition 2. The following data regarding sensor measurement types should be stored in the system. Name a. b. a. b. Abbreviation 3. The following data should be stored regarding the definitions of sensor measurements: Which sensor does it belong to? Which sensor type it belongs to a. b. C. Data type of measurement 4. The following data regarding sensor measurements should be stored in the system: Which sensor does it belong to? Which router does it belong to a. b. C. d. e. Measurement type The value of the measurement The date and time of the measurement 5. The following data regarding routers should be stored in the system: Name Description a. b. C. d. e. g. h. i. j. a. b. C. 6. The following data regarding the coordinators should be stored in the system: Name d. e. g. h. a. b. C. Country City County District The latitude The longitude 7. The following data regarding wireless sensor networks should be stored in the system. Name d. The latitude The longitude e. f. Which coordinator does it belong to? The sensors that the router has Description Country City County District Description Domain (Agriculture, livestock, smart home, smart city etc.) Status(Active/Passive) Created date and time The coordinators that wireless sensor network has

Answer rating: 100% (QA)

To design a database for managing wireless sensor networks with the specified requirements you can c... View the full answer