For this lesson we will be designing a RDBMS plan. In this plan you will create

Question

For this lesson we will be designing a RDBMS plan. In this plan you will create the following forms: List of Reports Table Development form Schema and Table Characteristics (Data Dictionary) Computer Club Database You are a database designer for the Computer Club. You want to computerize the club's membership list. You have the name, address, telephone number, and e-mail address for each member. You also would like to add the committee name to which each member is assigned, and when the committee meets. You want to create a report listing all members' information such as name and e-mail addresses, and a form that lists all information for each member. What makes this tricky is that a club member could be on more than one committee. Hint: this is best done as a three table operation -- one table has member information, another has the committee information, and a third connects the two. Plan an RDBMS for this problem using the list of requirement above and the above information.

Explanation / Answer

firstly we create a table for each member detail

create table m.member(m_id INT PRIMARY KEY,m_name varchar(255),address varchar(255),mobile char(10),email varchar(255));

then create second table for committee

create table m.comm(c_id INT PRIMARY KEY,c_name varchar(255),

cc_id INT FOREIGN KEY REFERENCES m.member(m.id));

Now add record in tables:-

insert into m.member values(1,'sonu','rohtak',9456732145,'s@mail.com');

insert into m.member values(2,'monu','delhi',9996732141,'m@mail.com');

GO

insert into m.comm values(101,'abcd',1);

insert into m.comm values(102,'xyz',1);

insert into m.comm values(103,'pqr',1);

insert into m.comm values(104,'xx',2);

insert into m.comm values(105,'yy',2);

GO

select * from m.member ;

select * from m.comm;

Now it will display the following tables:

We can easily see that a member sonu whose id is 1 have three committee abc,xyz and pqr and

member monu whose id is 2 have two committee xx and yy.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.