50.1K

Verified Solution

Link Copied!

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.

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

Answer & Explanation Solved by verified expert

See Answer