Question 2 Skyscrapers, offices, houses and apartments are everywhere in a metropolitan. Constructors see a lucrative profit from building commercial offices and housing apartments in metropolitans. As a COMM1822 student, imagine you have been approached by a local constructor owner who was impressed by the Database skills you learned in this course at UNSW. The owner is aware that technology can help him grow his business. He recognises the need for a well-organised, I computerbased system, which has become the standard in the construction industry and society. The owner wanted some initial steps taken to maintain the records of every worker. Maintaining the records on paper has proved difficult, and it has become necessary to have a computerised system that manages these issues. The owner explained that in the current manual system, data security is lacking, the file-based system they use is misleading, it is time-consuming to gather information files, and general searching and managing records is getting more and more difficult with the increase in construction projects. Data redundancies and inconsistencies make the existing system inefficient and frustrating for users. All departments involve paperwork to manage their allocated construction projects. The existing system creates project management problems that lead to project completion delays. Delay in project completion does not just undermine the company's profit but also affects the company's reputation in bidding on new projects. The owner asked you to develop an Oracle Database Management System to replace the manual system. Named 'Construction Database Management System' (CDMS), this system aims to provide an easy solution to the owner as well as providing excellent security of data to all involved. After a few conversations and interviews with the owner, the owner advised that he wants to store in the database information about: Worker: Each worker has an ID, Name, Email Address, Home Address, and Mobile Number. A worker must be either a permanent worker or a casual worker. A permanent worker has a Yearly Salary, while a casual worker has an Hourly Rate. Project: Each project has a Code, Name, Start Date, End Date, and Project Type (Commercial or Housing). Department: Each department has an ID and Name, and is managed by one and only one permanent worker. Supplier: Each supplier has an ID and Business Name, and supplies a variety of Materials, e.g., brick and cement, with a Unit Price. Contractor: Each contractor has an ID, Business Name, Address, Contact Person Name, Phone and Type of Work. The owner further elaborated on the operations of his company: - A permanent worker works for one and only one department. - Each worker is supervised by at most one permanent worker. - A project involves many departments and workers. - A supplier may supply materials to many projects. - Each contractor may involve in many projects. a) Create an Entity Relationship Diagram (ERD) - using Chen's notation - that reflects a suitable model based on the above scenario. Show all relevant entities, relationships and attributes. Indicate connectivity and cardinality in the ERD. You can state your assumptions if any, but they must be reasonable and not contradict the case scenario. [Max. 150 words for assumptions] b) The owner wants to expand his business and decides to bid on a theme park project. The owner wants to understand the potential of Big Data for their business and the strategies they can take to realize its potential before bidding on the park project. You need to provide TWO[2] recommendations on Big Data strategy to the company owner and justify how each strategy could help the owner to expand his business. Support your recommendations with relevant references [Max 300 words] Question 2 Skyscrapers, offices, houses and apartments are everywhere in a metropolitan. Constructors see a lucrative profit from building commercial offices and housing apartments in metropolitans. As a COMM1822 student, imagine you have been approached by a local constructor owner who was impressed by the Database skills you learned in this course at UNSW. The owner is aware that technology can help him grow his business. He recognises the need for a well-organised, I computerbased system, which has become the standard in the construction industry and society. The owner wanted some initial steps taken to maintain the records of every worker. Maintaining the records on paper has proved difficult, and it has become necessary to have a computerised system that manages these issues. The owner explained that in the current manual system, data security is lacking, the file-based system they use is misleading, it is time-consuming to gather information files, and general searching and managing records is getting more and more difficult with the increase in construction projects. Data redundancies and inconsistencies make the existing system inefficient and frustrating for users. All departments involve paperwork to manage their allocated construction projects. The existing system creates project management problems that lead to project completion delays. Delay in project completion does not just undermine the company's profit but also affects the company's reputation in bidding on new projects. The owner asked you to develop an Oracle Database Management System to replace the manual system. Named 'Construction Database Management System' (CDMS), this system aims to provide an easy solution to the owner as well as providing excellent security of data to all involved. After a few conversations and interviews with the owner, the owner advised that he wants to store in the database information about: Worker: Each worker has an ID, Name, Email Address, Home Address, and Mobile Number. A worker must be either a permanent worker or a casual worker. A permanent worker has a Yearly Salary, while a casual worker has an Hourly Rate. Project: Each project has a Code, Name, Start Date, End Date, and Project Type (Commercial or Housing). Department: Each department has an ID and Name, and is managed by one and only one permanent worker. Supplier: Each supplier has an ID and Business Name, and supplies a variety of Materials, e.g., brick and cement, with a Unit Price. Contractor: Each contractor has an ID, Business Name, Address, Contact Person Name, Phone and Type of Work. The owner further elaborated on the operations of his company: - A permanent worker works for one and only one department. - Each worker is supervised by at most one permanent worker. - A project involves many departments and workers. - A supplier may supply materials to many projects. - Each contractor may involve in many projects. a) Create an Entity Relationship Diagram (ERD) - using Chen's notation - that reflects a suitable model based on the above scenario. Show all relevant entities, relationships and attributes. Indicate connectivity and cardinality in the ERD. You can state your assumptions if any, but they must be reasonable and not contradict the case scenario. [Max. 150 words for assumptions] b) The owner wants to expand his business and decides to bid on a theme park project. The owner wants to understand the potential of Big Data for their business and the strategies they can take to realize its potential before bidding on the park project. You need to provide TWO[2] recommendations on Big Data strategy to the company owner and justify how each strategy could help the owner to expand his business. Support your recommendations with relevant references [Max 300 words]