1. Consider the following data structure and answer the following questions Cust
ID: 3731900 • Letter: 1
Question
1. Consider the following data structure and answer the following questions
Customer = Customer ID +
Customer name +
Building
Building = Building name
Street address
City
State
Zip
Technician = Technician ID +
Technician Name +
Building +
{Problems}
Problem = Problem ID +
Problem Definition +
Status +
Customer +
{Technician}
Status= [created|assigned|working|solved|reassigned]
a. Describe the difference between a structure and an element using the above diagram.
b. Choose two elements from the above diagram and define the elements in terms of (base/derived), element length, type of data, validation criteria, and defaults.
Explanation / Answer
a.) a structure is composed of elements. From the above diagram, we can say that 'Customer' is a structure composed of three elements 'Customer ID','Customer name','building'
b.) Customer ID:- base, element length =10, type of data = Number, Validation criteria = should not be blank
Status:- base, element length = 1, type of data = character, Validation criteria = should not be blank, default value = initial state
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.