Hi I have a new assignment that needs to be completed, the new assignment must be completed with data from the previous assignment that was completed by one of your tutors already for me from Sept. 22 on this account. Can the new assignment be done below? I have attachments also.
PLEASE COPY THE VISIO DIAGRAMS INTO WORD AND SUBMIT TO ME AS A WORD DOCUMENT.
The assignment requires that you utilize the data that was used in the Chapter 3 assignment.
For
this assignment, you are utilizing the data used for the diagrams that
you designed for the Chapter 3 assignment. The new information that you
are to provide is as follows:
(1) You are to design dependency
diagrams for the data design that you are working with. An example of
this can be seen in figure 6.5.
Be sure to indicate the primary and foreign keys in each design.
At the start or end of each attribute name, include your initials.
(2)
You will havesix dependency diagrams. It is necessary that you make
sure the data is converted to third normal form and and an additional
entity will be needed.
(3) Identify transitive and partial dependencies, where appropriate.
(4)
Show the relational schema for your design. An example of the
relational schema is seen on the bottom of the page after the figure
6.5. Indicate primary and foreign keys, using the sample format used in
your textbook.