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...

What are the two symbols on a use case diagram and what do they represent?

What will be an ideal response?

Computer Science & Information Technology

Your IDS has triggered an alert that someone has logged on at 1 a.m. with one of the intern's accounts used only during the day. What is your IDS type?

a. Pattern matching b. Protocol decoding c. Anomaly matching d. Behavior matching

Computer Science & Information Technology

Fire extinguishers are classified in one of four types based on the type of fires they can put out

Indicate whether the statement is true or false.

Computer Science & Information Technology

A(n) ____ query adds records form existing tables or queries to the end of another table.

A. make-table B. SQL C. delete D. append

Computer Science & Information Technology