An objective of this task is to denormalize a conceptual schema to speed up processing of...

 

Transcribed Image Text:

An objective of this task is to denormalize a conceptual schema to speed up processing of a given class of applications. Consider the following conceptual schema: OWNER first-name 101 last-name 101 phone city street Sold ID2 1.. when-sold 1.. PROPERTY city ID street ID bldg ID bedrooms AGENT first-name ID1 Takes-care-about last-nane 101 phone 102 profile 1.. Employs a money-paid AGENCY nane ID specialization (1) Perform simplification of the conceptual schema above and migration of identifiers to implement the associations. Re-draw a simplified conceptual schema with migrated identifiers. (2) (3) We would like to improve the performance of the following class of applications: Find the specializations of real estate agencies (attribute specialization in a class AGENCY) that employ the agents who took care about selling n bedrooms real estate properties (attribute bedrooms in a class PROPERTY) owned by the owners from a given city (attribute city in a class OWNER). A sample application that belongs to a class described above is the following. Find the specializations of real estate agencies that employ the agents who took care about selling 5 bedrooms real estate properties owned by the owners from Sydney. Find a denormalization of the simplified conceptual schema that improves the performance of the class of applications described above. Re-draw a simplified conceptual schema after the denormalizations. An objective of this task is to denormalize a conceptual schema to speed up processing of a given class of applications. Consider the following conceptual schema: OWNER first-name 101 last-name 101 phone city street Sold ID2 1.. when-sold 1.. PROPERTY city ID street ID bldg ID bedrooms AGENT first-name ID1 Takes-care-about last-nane 101 phone 102 profile 1.. Employs a money-paid AGENCY nane ID specialization (1) Perform simplification of the conceptual schema above and migration of identifiers to implement the associations. Re-draw a simplified conceptual schema with migrated identifiers. (2) (3) We would like to improve the performance of the following class of applications: Find the specializations of real estate agencies (attribute specialization in a class AGENCY) that employ the agents who took care about selling n bedrooms real estate properties (attribute bedrooms in a class PROPERTY) owned by the owners from a given city (attribute city in a class OWNER). A sample application that belongs to a class described above is the following. Find the specializations of real estate agencies that employ the agents who took care about selling 5 bedrooms real estate properties owned by the owners from Sydney. Find a denormalization of the simplified conceptual schema that improves the performance of the class of applications described above. Re-draw a simplified conceptual schema after the denormalizations.