Lukket

Homework help database normalization to 4NF

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

ER Design

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).

Færdigheder: Uddannelse & Tutoring, MySQL, PHP, Software Arkitektur

Se mere: normalization 4nf, schema design, requirements decomposition, recursively, old database, find this author, find help, education city, do your homework for you, do homework for you, city year, normalization database assignment, database normalization 4nf, solution design document template, c++ homework help, author find, author address, normalization, isbn, homework help\, help name, fd, ER diagram, docx, document database

Om arbejdsgiveren:
( 0 bedømmelser ) Kalamazoo, United States

Projekt-ID: #972996

7 freelancere byder i gennemsnit $250 for dette job

naumanrandhawa

Hi, Please check pmb for details.

$250 USD på 1 dag
(141 bedømmelser)
7.2
italinobz

Hi, I am a experienced database designer and developer and have done similar projects. Please see PMB for more details.

$250 USD in 5 dage
(1 bedømmelse)
1.0
developer545

ready to start right now ....

$250 USD på 1 dag
(0 bedømmelser)
0.0
sankalplondon5

Please let me know when we have to start the work for u I am on Skype add me as sankalpsaxena7

$250 USD in 5 dage
(0 bedømmelser)
0.0
xayb

Please check your private message...

$250 USD på 1 dag
(0 bedømmelser)
0.0
abhisekprasad

Hi, Please see private message.

$250 USD på 1 dag
(0 bedømmelser)
0.0
ielearnings

Please check your PMB.

$250 USD in 3 dage
(0 bedømmelser)
0.0