Create the following element descriptions. Use the values supplied in the table. Create any alternate names and definitions based on your understanding of the element.

What will be an ideal response?

Purchase Order NumberData Element
Description:
University Purchase Order Number—Unique for each order placed.
Data element attributes
Storage Type: Character
Length: 7
Picture: 9999999
Allow Null:
Notes:
The purchase order number is sequentially assigned.

Problem DescriptionData Element
Description:
Describes a computer problem that has been reported.
Data element attributes
Storage Type: Character
Length: 70
Picture: X(70)
Allow Null: Y

Total Computer Cost Data Element
Description:
This is the total cost of all computers in inventory.
Data element attributes
Storage Type: Numeric
Length:9,2
Picture: Z,ZZZ,ZZ9.99
Allow Null:

Next Preventive Maintenance Date Data Element
Description:
This is the calculated date that the next preventive maintenance should be performed on a given computer.
Data element attributes
Storage Type: Date
Length: 8
Picture: Z9/99/9999
Allow Null:
Notes:
The Next Preventive Maintenance Date is calculated by adding the Maintenance Interval to the Last Preventive Maintenance Date.

Phone Number Data Element
Description:
Any phone number.
Data element attributes
Storage Type: Character
Length: 7
Picture: 999-9999
Allow Null:

Repair StatusData Element
Description:
The status of a repair.
Data element attributes
Storage Type: Character
Length: 1
Picture: X
Default: N
Allow Null:
Notes:
Table of Codes: Repair Table

Computer Science & Information Technology

You might also like to view...

Which of these is located on the motherboard?

a. SSD drive b. RAM c. Hard drive d. DVD drive

Computer Science & Information Technology

The doctype is used by ______, which are programs that examine document code to ensure that it meets all the syntax requirements of the specified language.

A. testers B. quantifiers C. validators D. endorsers

Computer Science & Information Technology