Johns Hopkins University Data Modeling Discussion

Q:How consistent is the model with the enterprise?

Q:How well does the metadata match the data?

Total score
How
consistent
is the
model
with the
enterprise
?
How well
does the
metadata
match the
data?
Model
score
%
Comments
Strengt Improve
hs
ments
dala model.
Intellectual Unit
Title Name CHAR(100) NOT NULL
Subtitle Name CHAR(100) NOT NULL
Edition
Title Name (FK)
Edition Number
Exist as
Edition Primary Author Full Name CHAR(100)
Edition Publication Date
DATE
Medium
Medium Code
CHAR(100) NOT NULL
INTEGER
NOT NULL
Be released as
Publication
Publication Number
Publication ISBN
Title Name (FK)
Edition Number (FK)
Medium Code (FK)
Language Code
CHAR(100)
INTEGER
CHAR(2)
CHAR(2)
Publication Alternate Identifier Value CHAR(4)
Publication Length Count
CHAR(30)
Medium Length Timna
NOT NULL
NULL
Describe:
INTEGER
NOT NULL
CHAR(13) NOT NULL (AK1:1)
NOT NULL (AK2:1)
NOT NULL (AK2:2)
NOT NULL (AK2:3)
Describe
Medium Name
Medium Length Type Code (FK) CHAR(1) NOT NULL
Agency ID (FK)
INTEGER
NULL
T
CHAR(2) NOT NULL
CHAR(30) NOT NULL (AK1:1)
Author
Author ID
Contribution
Author ID (FK)
Title Name (FK)
Be written by Edition Number (FK)
NOT NULL (AK2:4) (IE1:1)
NOT NULL
NULL
Bo
HR Payroll System Internal ID INTEGER
Author Birth Date
Social Security Number
CHAR(18)
CHAR(10)
Write
Agongy
INTEGER NOT NULL
Author Sequence Number CHAR(1)
INTEGER
CHAR(100)
INTEGER
NULL
NULL
NULL
Assign an ID for
NOT NULL
NOT NULL
NOT NULL
NULL
Person
(Author ID (FK) INTEGER NOT NULL
Person Last Name CHAR(30)
Person First Name CHAR(30)
NULL
NULL
Organization
Author ID (FK) INTEGER NOT NULL
Organization CHAR (30) NULL