user(id, name, address, city, state, zip, email, acct_balance)
catalog(isbn, author, title, year, copy, status, user_id, due_date)
Using this schema, find all FD/MVDs. This should be a minimal set of FD/MVDs that cover all FD/MVDs in as few FD/MVDsas possible (i.e. don't limit your FD/MVDs to singleton right sides and don't list any redundancies). Recursively decompose into 4NF following the steps of the informal solution file for assignment 03. Do not add/remove any columns at this point (if you see a place to do so, do it in the next step). Use the [url removed, login to view] starter file linked above as a template.
Note that you do not need to decompose on the following FD, though it should still be listed as an FD/Violator (if it is an FD/Violator) in this document:
zip --> city, state
Based on your decomposition, produce an ER design in Visio. Follow the same requirements as in the previous ER diagram assignment. Note you may find in this step (or a subsequent step) that an additional change to the schema is needed (e.g. a new column may be needed or an old column may be deleted; hint hint). If you encounter such a change, you must change your ER diagram and other artifacts accordingly with the exception of the schema design document described above (which requires no change).