TASK $1$: External Schemas $60$ Points

Create a new Draw.IO file and give it a meaningful name $($i$.$e$.$ Theater$).$ Develop an E$-$R Diagram as detailed on

the following pages of this document using ER notation. You will need a minimum of six $(6)$ logical External

Schemas in your model as described on the following pages. You may develop additional External Schemas if

desired. Be sure to change the names of the sub$-$views for clarity.

Each external schema description below includes both business rules and a screenshot of a webpage. Your data

model must include data items from both the screenshot and the business rules.

External Schema $1$: Theater Home $-10$ Points

The theater home page, Figure $1$ below, shows information about movies at the theaters.

The website stores information about multiple theaters

Many movies may be shown at many theaters

Movies may be shown on many dates at many times

At least $3$ special feature$/$theater description images must be available for display on the main$/$home page. $($Near

bottom of page$)$

IMPORTANT: Although data types will not be assigned until Part $2$ of this project, actual Images and Videos will

not be stored in the database. Instead, a path to a file will be stored as a text $($VARCHAR$)$ attribute in tables that

require images. An example of a relative path to an image would be: "images$/$the$355.$jpg$"$ or

"videos$/$the$355.$mp$4".$

Figure $1-$ Theater Home Page $-$ Screenshot Sub$-$view $1$: pls make task one and draw the E$-$R Diagram