Identify the primary key and its dependencies, partial dependencies and transitive dependencies. Draw the dependency diagram using any graphical editor . Mark the PK with a different color. Mark distinctly the partial dependencies from the transitive dependencies.
Database Model Conventions You must follow these conventions when you perform your homework. Failing to follow the conventions will be penalized per each mistake and may also constitute evidence of cheating. • Entity names: singular nouns written in CAPITAL LETTERS, using _ instead of space, must end with a two letter suffix with your first […]