Data Dictionaries - Data Dictionaries Data Flow: Customer...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Dictionaries Data Flow: Customer Field Name Data Type Description Field Size Key Cust_ID Auto Number Random Number 6 Primary Key Cust_L_Name Text Customer’s Last Name 10 Cust_F_Name Text Customer’s First Name 10 Cust_Address Text Customer’s Street Address 20 Cust_City Text Customer’s City 20 Cust_Zip Text Customer’s Postal Code 5 Cust_Enroll_date date Customer’s date of enrollment 8 Cust_Renew_dat e date Customer’s date of renewal 8 Cust_Status_ID Auto Number Number assigned to show customer’s status 1 Foreign Key Data Flow: Customer Status Field Name Data Type Description Field Size Key Cust_Status_I D Auto Number Number that identifies the status of customer’s account 6 Primary Key Cust_Status Text The status of customer’s account 20
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Flow: Movie Field Name Data Type Description Field Size Key Movie_ID Auto Number Random Number 6 Primary Key Movie_Name Text Title of movie 20 MovieRating_ID Auto Number Number assigned to show movie’s ratings 6 Movie_Genre_I
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/07/2012 for the course INFORMATIO IT-520 taught by Professor N/a during the Spring '10 term at Kaplan University.

Page1 / 4

Data Dictionaries - Data Dictionaries Data Flow: Customer...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online