Write the CREATE TABLE statements needed to implement the following design in th
ID: 3549313 • Letter: W
Question
Write the CREATE TABLE statements needed to implement the following design in the EX schema:
These tables provide for members of an association, and each member can be registered in one or more groups within the association. There should be one row for each member in the Members table and one row for each group in the Groups table. The member ID and group ID columns are the primary keys for the Members and Groups tables. And the Members_Groups table relates each member to one or more groups.
When you create the tables, be sure to include the key constraints. Also, include any null or default constraints that you think are necessary.
Write the CREATE TABLE statements needed to implement the following design in the EX schema: These tables provide for members of an association, and each member can be registered in one or more groups within the association. There should be one row for each member in the Members table and one row for each group in the Groups table. The member ID and group ID columns are the primary keys for the Members and Groups tables. And the Members_Groups table relates each member to one or more groups. When you create the tables, be sure to include the key constraints. Also, include any null or default constraints that you think are necessary.Explanation / Answer
create table members(member_id number(10)primary key,first_name varchar2(10),last_name varchar2(10),address varchar2(10),city varchar2(10),state varchar2(10),phone number(10));
create table members_groups(member_id number(10)not null,CONSTRAINT fk_members Foreign key(member_id) References members(member_id),group_id number(10) primary key));
create table groups(group_id number(10)not null,CONSTRAINT fk_members_groups Foriegn key(group_id) references members_groups(group_id),group_name varchar2(10));
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.