KXO206 Database Management Systems
(2024)
Assessment Task 1 - Database Maintenance Report
|
Deadline for Submission: Assessment Weighting: Submission:
|
Friday 19th April 2024 by 11:59 pm (Shanghai-time)
25% of the total assessment for KXO206
Via MyLO
NOTE: All assignments are checked for plagiarism (copying) by the
Turnitin system. Turnitin checks your assignment against other students’ assignments as well as the Internet. For more information see:
www.utas.edu.au/turnitin
|
|
Assignment Type:
|
Individual
|
The scenario
The Shanghai Council for the Promotion of International Trade, founded in November 1956, serves as the oldest local branch of the China Council for the Promotion of International Trade (CCPIT). With a population exceeding 26 million people, the council plays a pivotal role in facilitating business activities within the city.
Currently, the council relies on a centralized Oracle database system to manage its operations efficiently.
However, it's noteworthy that approximately 30% of the council's records remain in electronic format and have not been migrated to the Oracle DBMS.
As of the date of this report, approximately 70% of the council's records have been successfully migrated to the Oracle DBMS. Efforts are ongoing to complete the migration process and ensure that all pertinent data is
integrated into the centralized database system.
The council has five major customers, Local Businesses, Foreign Companies, Citizens, Tourists and Partner Organisations. Tourists can book value pack trips all around Shanghai, if needed.
Stringent measures have been implemented to safeguard the confidentiality, integrity, and availability of the data stored within the Oracle database system. Access controls are in place to restrict unauthorized access, and regular security audits are conducted to identify and address potential vulnerabilities.
Regular backups of the Oracle database are performed to mitigate the risk of data loss in the event of system failures, natural disasters, or other unforeseen circumstances. Additionally, comprehensive disaster recovery plans have been developed to ensure the swift restoration of services in the event of a catastrophic event.
Database Maintenance Report Question:
Task description
The council is running out of time for the next trade exhibition as such, they need a new database developer to complete the migration of the remaining 30% database as originally planned.
• The former developer failed to provide proper documentation of the work that they had completed.
• The entire database tables need to be created again oracle SQL.
• The only document that does exist is the placeholder definitions of the database table, plus there is some test data contained in the SQL script file: Asst02Setup.sql.
• The table names in the Asst02Setup.sql are all place holders. Please create your own table names
Proposed tables and their corresponding attributes
|
Table Names (You are allowed to change the name and use appropriate table names for all)
|
Table Description
|
|
Local Businesses
|
Customer Information
|
Customer Feedback and Reviews
|
|
|
Foreign Companies
|
Companies’ information
|
Cross-Cultural Communication Data
|
|
Intellectual Property and Legal Data
|
|
|
Citizens
|
Personal Information
|
Residential Data. Healthcare Data
|
|
Social Media and Online Activity Data
|
|
Government Interaction Data
|
|
|
Tourists
|
Personal Information
|
Booking and Reservation Data
|
|
Cultural and Heritage Sites Visited
|
|
Shopping and Spending Habits
|
|
Tourism Feedback and Reviews
|
|
Emergency Contact Information
|
|
|
Partner organisations
|
Contact Information
|