운전면허 - ER diagram, RI diagram, normalisation(정규화), BCNF를 각각 단계별로 상세설명, 구성
- 최초 등록일
- 2009.03.25
- 최종 저작일
- 2008.05
- 20페이지/
압축파일
- 가격 6,000원
소개글
이번 assignment는 relational database design시간때 작성한 것이구요.
A 받았던 과제입니다. "운전면허"에 관련된 entities를 ER diagram으로 작성한후 다대다 관계인경우 다시 association을 만들어 final version으로 순서대로 작성했구요. 각각 entity에 대한 상세한 설명도 덧붙였습니다. 그런후 normalisation을 통하여 1NF를 2NF로 그리고 BCNF로 변화하는 과정을 설명과 함께 그림으로 표현했습니다. 마지막으로 통합적인 relation을 RI diagram으로 나타냈습니다.
영국대학 재학시 작성했구요. 가장 높은 점수를 받았습니다. 당연히 영어로 작성되었구요.
많은 도움 되었으면 합니다.
목차
1.1 Objectives
: This preface document describe the simple information of this main document, and describe the structure of the document.
1.2 Structure of the document
: This document has three parts of our project and produces documentation in the following format.
1.2.1
Introduction - This part provides two main information.
1.2.1.1
Background
: describes a brief statement of the background of the entities.
1.2.1.2
Objectives
: describes the overall objectives.
1.2.2
Tasks
1.2.2.1
Task 1
: draw Logical Data model using the EAR approach.
1.2.2.2
Task 2
: identify primary keys and foreign keys and represent the data model.
1.2.2.3
Task 3
: identify functional dependencies and normalise all relations to BCNF.
1.2.2.4
Task 4
: describe the Referential-Integrity diagram.
1.2.3
References
본문내용
This Logical Data model will be based on the Driving Licence Databases which is including the following entities.
① CANDIDATE - details about each person registering for a driving test and course.
② EXAMINER - examiners` details and qualifications that include qualification name
and result grading
③ DRIVER - candidates who have passed the appropriate driving test for the driving
licence of various categories.
④ LICENCE - details of driving licence categories
⑤ COURSE - details of courses delivered for the candidates by licensed
organizations. Licensed organizations include organization name,
address & phone number.
⑥ TEST-DESCRIPTION - skills and knowledge required for various categories of
driving licence test.
⑦ TEST-RESULTS - record of individual attempts of the candidates.
참고 자료
없음
