Question

1 Approved Answer

Posted on Oct 26, 2024

In the following exercises, you have to create ERDs based on the tables provided for respective databases. Be sure to include primary keys, foreign keys,

In the following exercises, you have to create ERDs based on the tables provided for respective databases. Be sure to include primary keys, foreign keys, and appropriate relationships. Instead of making guesses about the relationships, study the data well and make your inferences relying on your judgement.

Make an ERD For Video Store. Try to follow the Tiny college solution included in one of Module1 materials as a guide and complete all the requirements: primary keys, foreign keys, relationships. image text in transcribed

MEMBER MOVIE TAPE \begin{tabular}{|c|c|c|c|c|} \hline TPNUMB & MVNUMB & PURDATE & TMSRNT & MMBNUMB \\ \hline 1 & 1 & 04/26/94 & 4 & - \\ \hline 2 & 2 & 04/26/94 & 2 & 2 \\ \hline 3 & 3 & 04/26/94 & 6 & - \\ \hline 4 & 4 & 04/28/94 & 8 & 10 \\ \hline 5 & 5 & 05/12/94 & 3 & 4 \\ \hline 6 & 6 & 05/12/94 & 8 & - \\ \hline 7 & 7 & 05/12/94 & 2 & 2 \\ \hline 8 & 8 & 05/12/94 & 9 & 8 \\ \hline 9 & 6 & 06/26/94 & 1 & - \\ \hline 10 & 9 & 06/26/94 & 7 & 3 \\ \hline 11 & 10 & 06/26/94 & 10 & - \\ \hline 12 & 11 & 07/11/94 & 6 & 6 \\ \hline 13 & 12 & 08/02/94 & 4 & - \\ \hline 14 & 6 & 08/02/94 & 5 & - \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|} \hline DIRNUMB & DIRNAME & DIRBORN & DIRDIED \\ \hline 1 & Allen,Woody & 1935 & - \\ \hline 2 & Hitchcock,Alfred & 1899 & 1980 \\ \hline 3 & DeMille,CecilB. & 1881 & 1959 \\ \hline 4 & Kramer,Stanley & 1913 & - \\ \hline 5 & Kubrick,Stanley & 1928 & - \\ \hline 6 & Preminger,Otto & 1906 & - \\ \hline 7 & Ford,John & 1895 & 1973 \\ \hline \end{tabular} STAR MOVSTAR \begin{tabular}{|c|c|} \hline MVNUMB & STARNUMB \\ \hline 1 & 1 \\ \hline 1 & 2 \\ \hline 2 & 3 \\ \hline 2 & 4 \\ \hline 3 & 5 \\ \hline 4 & 6 \\ \hline 4 & 7 \\ \hline 5 & 8 \\ \hline 6 & 9 \\ \hline 6 & 10 \\ \hline 7 & 11 \\ \hline 8 & 12 \\ \hline 3 & 8 \\ \hline 3 & 12 \\ \hline 5 & 2 \\ \hline \end{tabular} MEMBER MOVIE TAPE \begin{tabular}{|c|c|c|c|c|} \hline TPNUMB & MVNUMB & PURDATE & TMSRNT & MMBNUMB \\ \hline 1 & 1 & 04/26/94 & 4 & - \\ \hline 2 & 2 & 04/26/94 & 2 & 2 \\ \hline 3 & 3 & 04/26/94 & 6 & - \\ \hline 4 & 4 & 04/28/94 & 8 & 10 \\ \hline 5 & 5 & 05/12/94 & 3 & 4 \\ \hline 6 & 6 & 05/12/94 & 8 & - \\ \hline 7 & 7 & 05/12/94 & 2 & 2 \\ \hline 8 & 8 & 05/12/94 & 9 & 8 \\ \hline 9 & 6 & 06/26/94 & 1 & - \\ \hline 10 & 9 & 06/26/94 & 7 & 3 \\ \hline 11 & 10 & 06/26/94 & 10 & - \\ \hline 12 & 11 & 07/11/94 & 6 & 6 \\ \hline 13 & 12 & 08/02/94 & 4 & - \\ \hline 14 & 6 & 08/02/94 & 5 & - \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|} \hline DIRNUMB & DIRNAME & DIRBORN & DIRDIED \\ \hline 1 & Allen,Woody & 1935 & - \\ \hline 2 & Hitchcock,Alfred & 1899 & 1980 \\ \hline 3 & DeMille,CecilB. & 1881 & 1959 \\ \hline 4 & Kramer,Stanley & 1913 & - \\ \hline 5 & Kubrick,Stanley & 1928 & - \\ \hline 6 & Preminger,Otto & 1906 & - \\ \hline 7 & Ford,John & 1895 & 1973 \\ \hline \end{tabular} STAR MOVSTAR \begin{tabular}{|c|c|} \hline MVNUMB & STARNUMB \\ \hline 1 & 1 \\ \hline 1 & 2 \\ \hline 2 & 3 \\ \hline 2 & 4 \\ \hline 3 & 5 \\ \hline 4 & 6 \\ \hline 4 & 7 \\ \hline 5 & 8 \\ \hline 6 & 9 \\ \hline 6 & 10 \\ \hline 7 & 11 \\ \hline 8 & 12 \\ \hline 3 & 8 \\ \hline 3 & 12 \\ \hline 5 & 2 \\ \hline \end{tabular}