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

University Singapore University of Social Science (SUSS)
Subject ICT330: Database Management Systems

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.

Buy Custom Answer of This Assessment & Raise Your Grades

Get Help By Expert

If you want to hire an assignment writer at a reasonable cost then you must get in touch with Singaporeassignmenthelp.com. We have a team of well-qualified experts who provide you well-formatted & grammatically correct Database Management Systems Assignment before the deadline.

Answer

Looking for Plagiarism free Answers for your college/ university Assignments.

Ask Your Homework Today!

We have over 1000 academic writers ready and waiting to help you achieve academic success