Physical Database Design

This assignment aims to develop your skills optimizing query. It involves identifying the suitable methods for structuring the data and writing the query. First, you will need to create a query on some unstructured data. Unstructured data can be thought of in this context as a table which is NOT clustered or hashed. In addition the table should NOT contain any indexes at all. The query can be an equi-join or a sub-query.