Consider the following tables: CLIENT(CL_ID, CL_LNAME, CL_FNAME, CL_PHONE)
PROJECT(PR_CODE, PR_DESCRIPTION, PR_PRICE, CL_ID)
For the tables given above, work on the problems below:
For each table, identify the primary key. - CL _ID is the primary key for the client table.
- PR_Code is the primary key for the project table.
2. For each table, identify the foreign key(s).