Please do a Data Dictionary for the INVENTORY MANAGEMENT DATABASE SYSTEM above like the data dictionary below:
Customer Customer 16 - First Name + C001 Wei Quan Mohd Rashid bin # C003 Tay Jun + C004 Subatera # C005 Safiyya Aliaa C002 Last Name Ali Lee Vasuthevan Binti Abu Bakar Gender Male Male Male Female Female Address 48A, Jalan Besar 71, Kg Sg Ramal 10, Jln SSJ 3/1 Taman Indah 7, Kg Kempas Baru Lorong Meranti 10, Jalan Rengas Southern Park Postcode State - Phone Num - 42000 Selangor 016-2898889 43000 Selangor 016-3536102 47630 Selangor 018-2199295 81200 Johor 017-6487881 55200 Wilayah Persekutuan Kuala Lun 017-2534642 0 Car Plates WPG3122 PGF4896 WEY9905 BEX7782 WRA5513 * Employee Employee ID - First Name - Last Name - E101 Zalina Ahmad + E102 Fred Brown + E103 Amin Ali + E104 Sally Lee + E105 Wei Hao Tan Gender Female Male Address 15, Tmn Harmoni, Bangi 4, Kajang Hill, Kajang 51, Megan Avenue, TTDI 41, TTDI Jaya, Shah Alam 1 2732 Ckt Permata Taman Permata Hulu Male Postcode State Phone Number - 43050 Selangor 012-4562340 43500 Selangor 019-2176588 50000 Wilayah Persekutuan Kuala Lumpur 016-8976533 50510 Selangor 013-4578124 53300 Selangor 019-3354949 0 Female Male Order Details ID Quantity Order ID 10101 2 0102 3 0103 4 0104 5 0105 6 0106 7 0107 (New) Product ID 1 P103 4 P109 4 4 P108 1 P105 4 P109 2 P110 1 P103 * 0 Purchase Order Order ID + 0101 + 0102 + 0103 + 0104 + 0105 + 0106 + 0107 * o Order Date Employee ID Employee ID - Supplier ID - 04-Jan-21 E102 B101 05-Jan-21 E105 T103 06-Jan-21 E103 T102 07-Jan-21 E101 B101 08-Jan-21 E104 T103 09-Jan-21 E102 - T104 10-Jan-21 E103 - B101 Sales ID Quantity 1 2 Employee ID E102 E102 E105 E103 E103 4 1 Product ID P103 3 P109 4 P108 5 P105 6 P109 7 P110 8 P103 9 P102 10 P107 11 P101 (New) Sales Date 16-Nov-20 16-Nov-20 28-Nov-20 07-Dec-20 07-Dec-20 23-Dec-20 23-Dec-20 02-Jan-21 02-Jan-21 06-Jan-21 Time - Customer IC- 10:00 AM C003 10:00 AM C003 2:00 PM C001 3:10 PM C002 3:10 PM C002 11:00 AM C004 11:00 AM C004 5:20 PM C005 5:20 PM C005 3:30 PM C001 E101 E101 E104 E104 E105 O NW NW N Supplier Supplier ID - + B101 + T101 + T102 + T103 # T104 Supplier Name - Phone Num- Address Skyace (M) Sdn Bhd +603-78452282 13, Jalan Saujana Indah 6, Taman Perindustrian Saujana Indah, Seksyen 12, Apollo Tyres (Malaysia) Sdn Bhd +603-77355555 Unit 1504 Level-15; Uptown-1; 1 Jalan SS21/58 Damansara Uptown; Goodyear Malaysia Berhad +603-55203200 Lot 51, Persiaran Selangor, Seksyen 15, Toyo Tyre Sales And Marketing Mal +603-55683188 No, 37, Jalan Pelukis 01/46, Temasya Industrial Park Glenmarie, Continental Tyre (PJ) Malaysia Sdn. +603-77878888 2, Lorong Tandang 51/204b, Seksyen 51, Postcode State 40150 Selangor 47400 Selangor 40200 Selangor 40150 Selangor 46050 Selangor 0 Email skyacesb@yahoo.com customerservice.my@apollotyres.com goodyear@gmail.com toyotyre@gmail.com continentaltyre@gmail.com Category Category ID - Category Name Battery + CO2 Tyre * +001 A Sample Data Dictionary TABLE 3.6 A SAMPLE DATA DICTIONARY TABLE NAME ATTRIBUTE NAME CONTENTS TYPE FORMAT RANGE REQUIRED PK Dr FK IK REFERENCED TABLE CUSTOMER PK 99999 10000-99999 100-999 Y Y Y CUS CODE CUINAME CUS FNAME CUS INITIAL CUS RENEW DATE AGENT CODE CHAR:5) VCCHARI20 VCHAR 20 CHARITI DATE CHAR3) dd-mm- 999 AGENT Customer acc. code Customer last name Customer first name Customer initial Customer insurance newal date Agent code Agent code Agent area code Agent telephone number Agent last name Agent year to-date sales AGENT 999 PK 0.00-9.999,999.99 Copyright Ari Yusnita Abdul Rahman 2020 NGENT CODE AGENT AREACODE AGENT PHONE NGENT INAME NGENT YTD SALES CHARBY CHARD CHARIB) VCHARY 200 NUMBER:9,21 999.9999 9,999,999.99 Y Y Y Y EX = Foreign by PK = Primary key CHAR Fred charader length data (1-255 characters VARCHAR = Variable character length data 1-2,000 characters NUMBER - Numerk data. NUMBER 9,2) is used to specify numbers with two decimal places and up to nine digts, including the decimal places Some RDBMS permit the use of a MONEY or CURRENCY data type
