데이터베이스입문 database processing kroenke auer 1장 2장 3장 5장 6장 문제풀이
- 최초 등록일
- 2017.03.02
- 최종 저작일
- 2014.04
- 25페이지/ 한컴오피스
- 가격 2,500원
목차
없음
본문내용
STAFF_MEETING (EmployeeName, ProjectName, Date)
The rows of this table record the fact that an employee from a particular project
attended a meeting on a given date. Assume that a project meets at most once per day. Also, assume that only one employee represents a given project, but that employees can be assigned to multiple projects.
A. State the functional dependencies in STAFF_MEETING. ☞ ProjectName determine EmployeeName. (ProjectName)→(EmployeeName)
B. Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.
☞ I made two tables. PROJECT_DATE(Date, Project), PROJECT(Project, EmployeeName) The primary Keys(candidate keys) are (Date, Project) in PROJECT_DATE and Project in PROJECT. In PROJECT_DATE Project is foreign key to PROJECT.
C. Is your design in part B an improvement over the original table? What advantages and disadvantages does it have?
참고 자료
데이터베이스입문 database processing kroenke auer