Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the format of the sample data dictionary given below,create a data dictionary for this database. Sample Data Dictionary: Table: CUSTOMER Column Name CUST CODE
Using the format of the sample data dictionary given below,create a data dictionary for this database.
Sample Data Dictionary:
Table: CUSTOMER Column Name CUST CODE CUST TITLE Size Text Text Text Text CUST FNAME CUST INITIAL CUST ADDRESS Text 15 35 15 Text CUST AREACODE Text Text Table: INVOICE Column Name T INV NUMBER CUST CODE Size Integer me INV TOTAL Table: LINE Column Name T INV NUMBER PROD CODE LINE UNITS LINE PRICE N/A 10 N/A N/A INE AMOU Table: PRODUCT Column Name T PROD CODE PROD DE PROD INDATE PROD PROD MIN PROD PRI Size Required Text 10 me N/A Table: VENDOR Column Name T VEND CODE VEND NAME Size Required N/A Y VEND PHONE Text TABLE NAME ATTRIBUTE NAME CONTENTS PE FORMAT RANGE REQUIRED OR REFERENCED FK PK TABLE 10000-99999 Y Customer account code Customer last name Customer first name Customer initial Customer insurance renewal date CUSTOMER CUS CODE CHAR(5) CUS LNAME CUS FNAME CUS INITIAL CUS RENEW DATE VARCHAR(20) XOODoox VARCHARI20) Xooooocx CHAR(1) DATE FK AGENT CODE PK AGENT CODE gent code AGENT_CODE AGENT AREACODEAgent area code AGENT PHONE Agent telephone number CHAR(8) AGENT LNAME AGENT YTD SLS Agent year-to-date sales UMBE92) 9,999,999.99 CHAR3) AGENT Agent code CHAR(3) 999-9999 Agent last name VARCHAR(20) XooooooxStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started