Analysis, design, and implementation of a Smart City Management Application

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Analysis, design, and implementation of a Smart City Management Application

 

System features:

A smart city has a number of smart buildings and smart streets. The users of the system have different roles and different privileges.

The system components in addition to the different users, their roles and responsibilities are presented in the next paragraphs.

Smart Buildings:

  • Each building has a number of floors and each floor consists of a number of apartments.
  • A building is characterized by its ID, type (residential, institutional, business, industrial), the smart street where it is located, in addition to the number of residents.
  • Smart buildings integrate renewable energy sources (solar and/or wind) in order to power the building.
  • Apartments in each building have IDs.
  • Each apartment is equipped with a sensor node.
  • These nodes contain the following components:
  • Motion sensor
  • Temperature sensor
  • Humidity sensor
  • Microcontroller
  • Communication module
  • a microcontroller and a communication module.

Smart Streets:

  • A smart street has a name and an ID.
  • Streets are also equipped with sensor nodes consisting of the following components:
  • Microcontroller
  • Temperature sensor
  • Smart meter for the streetlights power consumption monitoring
  • Each street has a general control room where we can find data about the street itself along with data regarding the different buildings located in that street.

The system has two main users:

General Admin:

The general admin manages the entire city. His privileges include:

  • Adding smart buildings to the system
  • Adding smart streets to the system
  • Adding apartments to the buildings on the system
  • Adding sensor nodes to the apartments and streets on the system
  • Viewing data related to the different sensor nodes deployed.
  • Manages profiles/accounts for the residents
  • Create account
  • Delete account
  • Update account

In order to have access to these privileges, the general admin has to login using a username and a password. A general admin has an ID, full name, email, and phone number. In addition to the privileges mentioned previously, the general admin can manage his own account. The general admis also takes care of the different report given by the residents. These reports are given to the corresponding organisations offline.

Resident 

Residents have ID, name, phone number, email, age, profession, and address (street, building, and apartment). Residents have access to the different sensor nodes that are deployed in their apartments. They can view the data given by the sensors and the status of the appliances; they can also control the appliances (turn on/off). In addition to that, residents can report any problems related to their smart appliances or the sensor nodes deployed in their apartments. These reports and requests are handled by the general admin who contacts the responsible parties to take care of the problems. Residents have access to the system through their accounts (login and password). They can manage their accounts by changing passwords and usernames.

Let's build the Building class!

 

Building
ID PK
type
street
Apartment
No of residents
1.
ID PK
1.
Admin
Integrate
Sensornode
enesgyc)
IDP k
gashesdatary
fullname
email
M.
Resident
phone
IDPK
appliance
andd buildings
name
phone
email
add scnsod
SmartstreeH
Name
type
nodecs
name
is
connect()
ConsUMe
power)
addsess
eauipsensof
access
sensorc)
newduta)
Transcribed Image Text:Building ID PK type street Apartment No of residents 1. ID PK 1. Admin Integrate Sensornode enesgyc) IDP k gashesdatary fullname email M. Resident phone IDPK appliance andd buildings name phone email add scnsod SmartstreeH Name type nodecs name is connect() ConsUMe power) addsess eauipsensof access sensorc) newduta)
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Mobile Devices
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education