1. Assume you are creating a database for RE/MAX Reality. Suppose you have created the following tables:

Buyer:

BID

AID

BNAME

STREET

CITY

STATE

Seller

SID

AID

SNAME

STREET

CITY

STATE

Agent:

AID

ANAME

STREET

CITY

STATE

1. Please identify primary keys and foreign keys from these tables.

2. Please explain how you can find the name of the agent hired by seller John.

2. Transform the follow ER diagram into relations, please specify tables, columns, the primary and foreign keys

Student

Student ID

Enrollment_year

Student_Name (First, Middle, Last)

Student_Addresses (Street, City, State, Zipcode)

{Course (Course_ID, Course_Description, Grade)}