MySQL Data Types

For questions $13,$ please use the logical entity$-$relationship $($ER$)$ model in Figure $1$ to answer the questions.

Figure $1.$ Bank Accounts ER Model

Figure $1.$ Bank Accounts ER Model

F

QUESTION $1$

What would need to change in the above model if the bank $($that uses this model$)$ wanted to also differentiate between account types $($e$.$g$.,$ checking, savings, etc.$)?$

For the toolbar, press ALT$+$F$10($PC$)$ or ALT$+$FN$+$F$10($Mac$).$

P

$0$ WORDS

POWERED BY TINY

$0$ points

QUESTION $2$

Create a logical ER model $($using Lucidchart, draw.io$,$ etc.$)$ that is based on the model above that includes the suggested changes you made in Question $1.$

After creating your model, to submit it you will need to upload a file containing your model from your computer. To save the model you created to your computer, you will need to export it as an image file. To do this in Lucidchart, go to File $-->$ Download As $-->$ PNG$,$ and then save it using a descriptive title. To do this in draw.io$,$ go to File $-->$ Export as $-->$ PNG$,$ and likewise save it using a descriptive title.

Attach FileNo file chosen

$0$ points

QUESTION $3$

Using the model you created in Question $2$ as a reference, create a physical ER model $($using Lucidchart, draw.io$,$ etc.$)$ that includes MySQL data types for each attribute.