ITEC601 | Schemas for the Housing Policies
The Housing Office is an organization in Australia supporting low income families to find suitable government subsided housing and managing payment. In order to assess an applicant’s eligibility and determine the rate, the applicant is required to obtain relevant document from Centrelink (www.humanservices.gov.au/individuals/centrelink) Now both the Housing Office
and Centerlink want to reduce the amount of time and money spent on hiring staff handling applicant inquiries and claims. By allowing applicants to view their own information and work out their eligibility and entitlements, and to request changes and make payments online, they will be able to cut back significantly on resource use by staff in local branches, and more importantly help applicants make better informed decisions. The objective is to allow policyholders to make decisions based on the housing support policy information stored in the databases in the Housing Office, as well as applicant information stored in the databases in the Centerlink offices.
Suppose an applicant wants to check her housing subsidy eligibility, the types of housing support one can apply for, the available housing in a desired area as well as rental availability. This request would actually need data from multiple disparate back-end systems from the Housing Office and Centerlink. In this case, there is a need to decompose a request into multiple requests to be sent to different back-end databases applications, then gather the information sent back and assemble this information into the form of a single uniform response (recompose). Therefore you need to:
- design simple schemas for the housing policies and customer databases and explain what kind of integration technique you will be using. Assume the back-end databases are relational.
- design and draw a tiered EAI system that can handle this situation and how users can gain direct access to business applications and data.
- explain how queries will be decomposed and replies recomposed. You can make necessary assumptions.
Answer:
Schemas for the housing policies and customer databases
Housing Policies
Customer Database
Integration technique
The integration of the data would be done for the Housing Office and Centrelink so that the data of the customers and the properties owned by them can be linked properly so that efficient queries and results can be fetched from the system. In addition to this, the integration would enable them to provide a uniform response for the multiple queries which have been sent to the system. Major emphasis has to be put on the program-centric data system that would be developed for the organization. This would help the policy makers in simplifying the queries that are to be made in the system do that their purpose is served efficiently. An application based system is to be used for the development to the system which would help them in obtaining. Hence a Need based Data Integration is to be adopted by the organization, which would benefit the organization to a great extent and this would help them in achieving a proper integration.
Tiered EAI system
Queries decomposition and replies re-composition
For the explanation of the query getting decomposed and the replies to the query getting decomposed and the replies to be re-composed for the staffs. The case of an applicant wanting to check the eligibility of her housing subsidy. The applicant wants to check the type of housing support that they can apply for and desired area for which the rents are available. The integrated system would provide the applicant the option to input their queries and the system would process the query. For example, the query provided below is considered for discussion:
SELECT eligibility FROM Property
INNER JOIN Housing_Policies ON Property.PropertyID = Housing_policies.PropertyID
INNER JOIN Owner ON Owner.OwnerID = Housing_Polcies.OwnerID
WHERE eligibility = “elegible”;
For the retrieval of the data is done by sub dividing the query into the projection into two groups. The data is selected from the projection of the two tables Housing_Policies and Property and also the projection of Owner and Housing_Policies. In addition to this, the data from the projections are to be joined using the two projections and the data are fetched and re-complied using the Join operations. The join operation would be providing a large set of data for the query hence a selection is to be done for the data which is eligible for the applicant. The complete organized data is then displayed in front of the query maker very efficiently.
Assumptions
For the system some assumptions have been made in development of the schemas. Here it has been assumed that the owners and the customers are different entities. However, for the example that has been stated in this, report that the applicant can be considered and assumed both as an owner and a customer. In addition, to this the owners and the customers can be included in the applicant category. In addition to this, it has been assumed that there has been an eligibility field.
Bibliography
Bi, Z., Da Xu, L. and Wang, C., 2014. Internet of things for enterprise systems of modern manufacturing. IEEE Transactions on industrial informatics, 10(2), pp.1537-1546.
Colombi, J.M., Kretser, M.P., Ogden, J. and Hartman, P., 2016. Enterprise Systems Integration using Collapsing Design Structure Matrices. CrossTalk, p.33.
He, W. and Da Xu, L., 2014. Integration of distributed enterprise applications: A survey. IEEE Transactions on Industrial Informatics, 10(1), pp.35-42.
Javidroozi, V., Shah, H., Amini, A. and Cole, A., 2014. Smart city as an integrated enterprise: a business process centric framework addressing challenges in systems integration. In Proceedings of 3rd International Conference on Smart Systems, Devices and Technologies, Paris (pp. 55-59)
Buy ITEC601 | Schemas for the Housing Policies Answers Online
Talk to our expert to get the help with ITEC601 | Schemas for the Housing Policies Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
