140k views
1 vote
Draw data models for the following entities:

a. Movie (title, producer, length, director, genre)
b. Ticket (price, adult or child, showtime, movie)
c. Patron (name, adult or child, age)

User Kingdango
by
7.9k points

1 Answer

6 votes

Final answer:

To draw data models for the given entities, each entity can be represented as a table with its attributes as columns.

Step-by-step explanation:

To draw data models for the given entities, we can represent each entity as a table with its attributes as columns. Here are the data models for the given entities:

a. Movie

Table: Movie

+--------------+-------------------+

| title | producer |

+--------------+-------------------+

| length | director |

+--------------+-------------------+

| genre | |

+--------------+-------------------+

b. Ticket

Table: Ticket

+--------------+-----------------+

| price | adult_or_child |

+--------------+-----------------+

| showtime | movie |

+--------------+-----------------+

c. Patron

Table: Patron

+-----------+-----------------+

| name | adult_or_child |

+-----------+-----------------+

| age | |

+-----------+-----------------+

User Ashok Dey
by
7.3k points