问题 问答题

现有员工和项目两个实体,员工有属性员工号、员工姓名、年龄,项目有属性项目号、项目名称。假设一个员工可以参加多个项目,一个项目也可以有多个员工。员工可以同名。员工参与一个项目主要记录所完成工作。

试画出E-R图,并注明属性和联系类型。并将所得到的E-R图转换成关系模式,并给出各关系模式的关键字。

答案

参考答案:

E-R图如下所示。

将所得到的E-R图转换成关系模式且各关系模式的关键字如下所示:

员工(员工号,员工姓名,年龄),关键字是员工号

项目(项目号,项目名称),关键字是项目号

参加(员工号,项目号,所完成工作),关键字是(员工号,项目号)。

解析:

建立相应的E-R图的过程如下:

a.确定实体类型。本问题有两个实体类型,即员工实体、项目实体。

b.确定联系类型。员工实体与项目实体之间是多对多联系,即参加关系。

c.把实体类型和联系类型组合成E-R图。

d.确定实体类型和联系类型的属性。

员工实体属性:员工号、员工姓名、年龄。

项目实体属性:项目号、项目名称。

参加联系属性:所完成工作。

根据E-R图向逻辑模式转换的规则,将实体、属性和联系转换成关系模式。转换的原则请参照上题分析说明。一个实体就是一个关系,实体的属性就是关系的属性,实体的关键字就是关系的关键字。一个M:N的联系转换成一个关系模式,与该联系相连的各实体的关键字以及联系本身的属性均转换为关系的属性,关系的关键字为各实体的关键字的组合。

选择题

                                                 LIDAC MAYNARD

11 Windrift Circle

Methuen, MA

978 – 555 – 4539

JOB OBJECTIVE

Seek special education, primary school, or middle school math teaching position.

EDUCATION

Rivier College, Nashua, NH

Bachelor of Arts in Education – May, 2006

Major: Elementary Education

Have successfully completed PRAXIS I and PRAXIS II. Meet highly qualified testing requirements for Massachusetts and New Hampshire.

TEACHING EXPERIENCE

November, 2005 – January, 2006

Wilkins Elementary School, Amherst, NH

Student Teacher

· Developed and completed student–centered lessons in all subject areas for various groups of fifth grade special and regular education students.

· Adapted lessons to meet student’s needs by reviewing their backgrounds and learning needs through IEPs.

· Communicated with parents on a regular basis via newsletters, daily or weekly progress reports, phone calls, and email, resulting in increased parental participation at home.

August, 2005 – November, 2005

Charlotte Avenue Elementary School, Nashua, NH

Student Teacher

· Taught reading and writing through Language Experience Approach methods.

· Introduced a Writer’s Workshop appropriate for first grade students to help them to develop their writing skills.

· Developed learning stations in reading and science, enabling students to be more independent learners.

Spring, 2005

Wilkins Elementary School, Amherst, NH

Designed and taught a unit on Insects and Spiders, based on New Hampshire Standards to 23 self-contained, third and fourth grade students with disabilities.

Fall, 2004

Amherst Street Elementary School, Nashua, NH

Taught a class of 24 third grade students with a wide range of abilities.

ADDITIONAL EXPERIENCE

· After–School Aid, Amherst School District, Amherst, NH (2004 – 2005)

· Summer Camp advisor, YMCA, Nashua, NH (Summers, 2002 and 2003)

· Big Brother / Big Sister Volunteer, Nashua, NH (2002 – 2005)

小题1:

What kind of job does Linda want to get?

A.A Big Brother / Big Sister Volunteer.

B.A middle school math teacher.

C.A special education advisor.

D.A summer camp advisor.小题2:

Linda has worked for the following schools EXCEPT ___________.

A.Rivier College, Nashua, NH

B.Wilkins Elementary School, Amherst, NH

C.Charlotte Avenue Elementary School, Nashua, NH

D.Amherst Street Elementary School, Nashua, NH小题3:

What can we know about Linda according to the passage?

A.She is merely interested in developing student’s math abilities.

B.She is not active in participating in after–school activities.

C.She is permitted to teach in any of the high schools of New York.

D.She has some teaching experiences in several elementary schools.

单项选择题