***PLEASE USE THE STYLE OF THE TEMPLATE PROVIDED***

I am attempting to do one of these of my own and I need to see the data in the template correctly. Thank you.

(1) Using the suggested ERD solution construct the relation schema to implement the ER diagram).

For each relation, underline the PK and list:

1. all candidate keys: e.g. [1] FacultyId, [2] {FirstName, LastName, DepartmentNumber}

2. all foreign key references: e.g. [1] ChairFacultyId references Faculty[FacultyId], [2] StudentId references Student[StudentId]

3. Attributes known for sure that can be null [i.e. Nullable]: e.g. [1] MiddleInitial, [2] Phone

WM_Member GroupAdmin -serves as a-- follows ISACreator Since + Description # Memberld FirstName LastName EMail Phone Since Group Member JoinTime Comment RoleNote posted by in the group of owns of a group of Meet # Account Accountld Username Password PassSince Group Groupid GroupName Created on Description Purpose ..on--- makes Date Title Description StartTime End Time Location classified as OldPassword Category Password Since Comment Categorvid Name CommentOn Body Time HO Solution for HW #4 You may have a different number of tables. Adjust accordingly. The relation schema: 1 Table1(Table1 id, col_1, col_2, col_3, col_4) Candidate Keys [1] Table1_Id, [2] col_1, col_4 Foreign Keys [1] col_1 references Table2(col_1), [2] col_4 references Table3(Table3_id) Nullable Attributes col 2 Notes [1] In this design, a surrogate key Table1_id is created. 2 And so on... Candidate Keys Foreign Keys Nullable Attributes Notes [1] You may copy, paste, or delete to adjust for the right number of relations. 3 Candidate Keys Foreign Keys Nullable Attributes Notes 4 Candidate Keys Foreign Keys Nullable Attributes Notes 5 Candidate Keys Foreign Keys Nullable Attributes Notes 6 Candidate Keys Foreign Keys Nullable Attributes Notes 7 Candidate Keys Foreign Keys Nullable Attributes Notes 8 Candidate Keys Foreign Keys Nullable Attributes Notes 9 Candidate Keys Foreign Keys Nullable Attributes Notes 10 Candidate Keys Foreign Keys Nullable Attributes Notes 11 Candidate Keys Foreign Keys Nullable Attributes Notes 12 Candidate Keys Foreign Keys Nullable Attributes Notes 13 Candidate Keys Foreign Keys Nullable Attributes Notes 14 Candidate Keys Foreign Keys Nullable Attributes Notes 15 Candidate Keys Foreign Keys Nullable Attributes Notes