Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Sample Data Dictionary:

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions