Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

UML CLASS DIAGRAM FOR THIS: Category begin{tabular}{|c|l|} hline CategorylD & CategoryDeso hline 1 & New Release hline 2 & Action hline 3

UML CLASS DIAGRAM FOR THIS:

image text in transcribed

Category \begin{tabular}{|c|l|} \hline CategorylD & CategoryDeso \\ \hline 1 & New Release \\ \hline 2 & Action \\ \hline 3 & Horror \\ \hline 4 & Comedy \\ \hline 5 & Children's \\ \hline \end{tabular} Format \begin{tabular}{|c|l|} \hline FORMATID & FDRMATDESC \\ \hline 1 & VCR \\ \hline 2 & DVD \\ \hline 3 & Playstation \\ \hline 4 & Nintendo 64 \\ \hline 5 & Sega \\ \hline \end{tabular} Customer Rentals \begin{tabular}{|c|c|c|c|l|c|c|c|c|} \hline RENTALID & DATEDUT & DATEDUE & DATEIN & DELIVERYSTATUS & COST & LATEFEE & CUSTDMERID & VIDEDID \\ \hline 1 & 22Sep02 & 24Sep02 & 24Sep02 & pickup & $2.00 & $0.00 & 1 & 3 \\ \hline 2 & 23Sep02 & 25Sep02 & & delivery & $3.00 & $1.00 & 2 & 4 \\ \hline 3 & 25Sep02 & 27Sep02 & 26Sep02 & pickup & $2.00 & $0.00 & 2 & 2 \\ \hline 4 & 25Sep02 & 27Feb02 & 26Sep02 & pickup & $2.00 & $0.00 & 2 & 5 \\ \hline 5 & 27 epp 02 & 28Sep02 & & delivery & $1.00 & $0.00 & 4 & 6 \\ \hline \end{tabular} Videos \begin{tabular}{|r|l|c|c|c|} \hline \multicolumn{1}{|c|}{ VIDEDID } & \multicolumn{1}{|c|}{ TITLE } & FORMATID & COST & CATEGORYID \\ \hline 2 & The Matris & 1 & $2.00 & 2 \\ \hline 3 & The Evil & 1 & $2.00 & 3 \\ \hline 4 & Super Mario & 4 & $1.00 & 5 \\ \hline 5 & Bride & 1 & $2.00 & 5 \\ \hline 6 & Men ln Tights & 2 & $2.00 & 4 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Repairing And Querying Databases Under Aggregate Constraints

Authors: Sergio Flesca ,Filippo Furfaro ,Francesco Parisi

2011th Edition

146141640X, 978-1461416401

Students also viewed these Databases questions

Question

What is eavesdropping in a computer security sense?

Answered: 1 week ago