Question: 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

Using the format of the sample data dictionary given below,create a data dictionary for this database.

Sample Data Dictionary:

data dictionary for this database. Sample Data Dictionary: Table: CUSTOMER Column Name

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) Xoooooox

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!