( Version 0.4 ) 1

Size: px

Start display at page:

Download "( Version 0.4 ) 1"

闲巴
7 years ago
Views:

1 ( Version 0.4 ) 1

2 Entities-Relationship Model

3 ( ) version 0.3 Int TextVarchar byte byte byte 3

4 Id Int 20 Name Surname Varchar 20 Forename Varchar 20 Alternate Type Varchar 10 Other Names Varchar 20 reference Title Varchar 100 Volume Varchar 20 Pages Varchar 20 (1) Country Varchar 10 B&D C Begin Dynasty Varchar 10 (1) Calendar Emperor Varchar 20 (1) Period Varchar 20 Year Varchar 20 Month Varchar 20 Day Varchar 20 End Dynasty Varchar 10 (1) Emperor Varchar 20 (1) Period Varchar 20 Year Varchar 20 Month Varchar 20 Day Varchar 20 W Begin Dynasty Varchar 10 Calendar Begin Varchar 20 2 End Dynasty Varchar 10 End Varchar 20 2 Native place Original Varchar 40 Contemporary Varchar 40 Biography Content Text - Reference Title Varchar 100 Volume Varchar 20 Pages Varchar 20 Education Period Varchar 20 Education Varchar 20 Remarks Varchar 40 Specialty Varchar 60 Title Title Varchar 80 Daterange Varchar 80 Reference Title Varchar 100 Volume Varchar 20 Pages Varchar 20 Works Works Varchar 80 Version Varchar 80 multimedia Path Varchar 40 Electronic name Varchar 20 Type Varchar 10 Relationship Related Persons Varchar 20 Relation Varchar 8 URI Varchar 60 Cataloging Cataloger Name Varchar 10 History Cataloging Date Varchar 30 4

5 Modifier Name Varchar 10 Modified Date Varchar [ ] ( 4 ) ( 4 ) ( 4 ) 4 Chicago Chicago 5

6 Chicago ( 75) ( ) ( 17) ( 1997) ( 1980) ( 75) ( 75) ( 1991) ( 75) ( 1999) () ( 1982). ( 1988) ( 1959) ( 1961) ( ) ( 5 ) ( ) ( 5 ) ( ) ( 5 ) 5 Chicago Chicago : Chicago

7 [ ] ( 6 ) ( ) ( 6 ) ( 6 ) 6 Chicago Chicago Chicago () 1998 () : 1979 () 1989 () :, 1992 () : 1985 : 1985 : 1980 : : 1985,,,,,

8 [ ]. ( 7 ). ( 7 ). ( 7 ) 7 Chicago Chicago Chicago ,1966,1959,1980,1968 8

9 62,1979,1988, ,1987,1965, ,1991,1982,1985,1988,1986,1986..,1987,1983,1971,1970,1969 ISAARCDWA Creator IdentificationMARC21 MARC 21 MARC standard MARC Standard mapping MARC 21 Format for Authority Data 001 CONTROL NUMBER 100 HEADING--PERSONAL NAME 1#$a surname 100 HEADING--PERSONAL NAME 0#$a forename 400 SEE FROM TRACING PERSONAL NAME 0#$a forename 670 SOURCE DATA FOUND $a Source citation,, 400 SEE FROM TRACING PERSONAL NAME $e Relator term 100 HEADINGPERSONAL NAME $z Geographic subdivision 100 HEADING--PERSONAL NAME $d Dates associated with a name $d,, 100 HEADING--PERSONAL NAME $z Geographic subdivision $z ( ) 678 BIOGRAPHICAL OR HISTORICAL DATA $a Biographical or historical data 670 SOURCE DATA FOUND $a Source citation,, 9

10 MARC 21 Format for Authority Data 100 HEADING--PERSONAL NAME $c titles and other words associated with a name 100 $c,, 100 HEADING--PERSONAL NAME $g Miscellaneous information 100 HEADING PERSONAL NAME $c titles and other words associated with a name 100 $c, 670 SOURCE DATA FOUND $a Source citation,, 100 HEADING--PERSON AL NAME $t Title of a work 100 HEADING--PERSON AL NAME $s Version 856 ELECTRONIC LOCATION AND ACCESS $d path 856 ELECTRONIC LOCATION AND ACCESS $f electronic name 856 ELECTRONIC LOCATION AND ACCESS $q electronic format type 500 SEE ALSO FROM TRACING PERSONAL NAME $a Personal name 500 SEE ALSO FROM TRACING--PERSONAL NAME $j Attribution qualifier 856 ELECTRONIC LOCATION AND ACCESS $u Uniform Resource Identifier 040 CATALOGING SOURCE $a Original cataloging agency 008 FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION Date entered on file 040 CATALOGING SOURCE $d Modifying agency 005 DATE AND TIME OF LATEST TRANSACTION I L L A A H D D S S X 10

11 I L A H D S X ( 8 ) ( 8) ( 8 ) ( 9 ) ( 9 ) ( 9 ) 8 surname other names authority access table

12 Entities-Relationship Model URI N 1 1 ( ) 12

13 E-R model 1. single-value entity 2. multi-valued entity GIS relationship of entities GIS 5. (N) (1) 6. (primary key) key dependent of N

14 14

「人名權威檔」資料庫欄位建置表

「人名權威檔」資料庫欄位建置表 ( version 0.2) 1 3 3 3 3 5 6 9.... 11 Entities - Relationship Model..... 12 13 14 16 2 ( ) Int Varchar Text byte byte byte Id Int 20 Name Surname Varchar 20 Forename Varchar 20 Alternate Type Varchar 10