1 / 14

# 資料庫系統導論第一組報告 - PowerPoint PPT Presentation

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' 資料庫系統導論第一組報告' - titus

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

• 成員

• 第一條「個體整合限制」

b.確定該個體是一個完全確定的個體。

c.為了查詢處理上的方便性與務實性。

• 確保不會是虛值的屬性
• 不要用會造成困惑的編號鍵值
• 儘量以單一的屬性來代表整筆值組

Student(student_no,dept,class,name,phone)

Course(course_no,dept,course_name)

Teacher(teacher_no,dept,rank,name,office,phone

Teach(tecaher_no,course_no)

Enroll(student_no,course_no,makeup,credits,required

m

n

m

1

1

n

Student(student_no,dept,class,name,phone,teacher_no)

Teacher(teacher_no,dept,rank,name,office,phone)

Course(course_no,dept,course_name,teacher_no)

Enroll(student_no,course_no,makeup,credits,required)

Course

course_no

dept

course_name

teacher_no(FK)

Teacher

Student

teacher_no

dept

rank

name

office

phone

student_no

dept

class

name

phone

teacher_no(FK)

Enroll

Student_no(FK)

Course_no(FK)

Markup

Credit

Required

• 10 人一組
• E-R Model (要有 1-n, n-m relationships)。
• 由E-R Model圖maps to base tables (指明Foreign Key關係)。
• 不要有redundant data (要做normalization)。
• 至少要有3個entities，2個relationships，要有Foreign Key關係(注意Referential Constraint)。

n

m

1

m

→一對多→可合併於多方之實體關聯表