ICT330: The traditionally labor-intensive real estate and built environment sector has been hit particularly hard by the pandemic: Database Management Systems Assignment, SUSS, Singapore

The traditionally labor-intensive real estate and built environment sector has been hit particularly hard by the pandemic and the resulting manpower shortage, but with the increasing use of emerging technologies like drones, artificial intelligence (AI), and Internet-of-Things (IoT) devices, the sector may soon see significant alleviation of its manpower issues.

On top of that, these technologies can also benefit the end-users of the real estate sector – real people living in real homes. Besides making the construction process more efficient and less reliant on manpower, these technologies can also help with safety monitoring, fall detection, and even cleaning.

Database setup

To support this initiative by the real estate sector, the Singapore government has brought in a new cloud hosting service provider Amazon. Incorporated and based in Singapore, the cloud services it provides will give the real estate sector the processing power it needs for its digitization and AI initiatives.

You have been hired as Amazon’s database administrator. To spearhead its
incorporation, it has recently launched a web portal for its customers to easily
purchase and use its services.

It has received its first batch of 200 user accounts

• Analysis of the fields and data in the CSV file and design the new user account
  database.
• Write an SQL script to insert the customer data in csv file data into the
  database.

What to submit

• ER diagram of the new user account database.
• SQL script to set up the new database.
• SQL script to load the customer data into the database.