NEED HELP ASAP!!

Question

1. ER Diagram for a movie theater company. It has the registered number & name of the company. The company may own many theaters, each theater has a unique id, name, and address.
2. Every theater must be owned by 1 or more companies. In each theater, multiple movies can be played. But, each movie may be played in one theater only.
3. A movie can be played on one or multiple screens; every screen has an id and seating capacity and each screen must display exactly one movie.
4. ER diagram for a real estate firm. The firm has multiple offices. The office is identified by a unique business #, address, and description.
5. Each office offers house listings, a house can only be listed in one office but an office can have multiple house listings. The house has an address, area, number of rooms, and number of bathrooms. Each office has an agent working for it.
6. A sales agent can work for multiple offices and an office can contain multiple sales agents. An agent can be assigned to sell multiple houses but a house can be sold by only one agent.
7. Agents are identified by employees if and their attributes are name and salary.

Answer 1

Table TheatreCompany

reg# (primary key)

name

Table Theatre

id (primary key)

name

address

Table CompanyXTheatre

reg# (foregin key references TheatreCompany)

theatreID (foriegn key reference Theatre)

Table Movie

id (primary key)

nameTitle

theatreID (foriegnKey)

Table MovieScreen

theatreID (foreignKey)

id

maxSeatingCapacity

movieId (foreignKey)

----------------------------------------------------------------

table RealEstateOffice

businessID# (primary key)

address

description

table HouseListing

RealEstateOfficeBusinessID# (foreign key)

address

area

# of rooms

# of bathrooms

# of bedrooms

agentID# (foreign key)

table RealEstateAgent

agentID# (primary key)

name

salary

table RealEstateAgentXOffice

businessID# (foreign key)

agentID (foreign Key)