Notes:

Provide a brief description of your schema.

Check which ER relationships could map to the given pattern. This will assist you in your schema choices.

This is a practical assignment. You need to create your DB schema. You may use an online SQL engine such

as:

programiz SQLite

mxCompiler

Note that not all online engines support referential integrity constraints. Hence, ensure that the data in

your tables does not violate these constraints. Otherwise, your fragments will be incorrect.

Create your tables using the CREAT TABLE and the INSERT commands. Include a snapshot of your tables in

the answer sheet.

The number of rows you insert in each table is subject to your judgment.

Save the fragments in new tables. Keep the original tables.

Apply appropriate SQL commands to show the completeness and disjeintness of your fragments. Include a

snapshot of the results in the answer sheet.

Rubric:

Questions will be graded based on a logical and correct application of fragmentation steps, the correctness of

verification steps, and the provided results.Design a database schema of your choice consisting of $3$ relations. The schema diagram must show the attributes,

primary, and foreign keys. The DB schema should match the following pattern:

Briefly describe your database. Show any potential considerations regarding the data in the tables that would

impact fragmentation correctness, specifically the data in Table $2.$

Q$1$: Apply a horizontal fragmentation on Table $1$ and decide on predicates $($exactly $2)$ for horizontal fragmentation.

Show the completeness and disjointness of your fragments.

Q$2$: Apply a derived fragmentation on Table $2$ based on the horizontal fragmentation of Table $1.$ Explain how you

performed the derived fragmentation. Show the completeness and disjointness of your fragments.

Q$3$: Apply horizontal fragmentation to Table $3$ and decide on predicates $($exactly $2)$ for horizontal fragmentation.

Show the completeness and disjointness of your fragments.

Q$4$: Show how Table $2$ may be further fragmented from the fragments in Q$2$ by adding the predicates in Q$3.$

Explain how you performed the derived fragmentation. Show the completeness and disjointness of your

fragments.