Question
please do all parts A and B
1. (40 points) 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 lassigned |working solved reassigned] (20 points) Describe the difference between a structure and an element using the above diagram A structure is a whole set that is composed of structural records. A structure would usually represent an entity which is composed of various attributes. On the other hand, a element is a subset or a composition of a structure. An element consists of attributes that define a structure (20 points) 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 a. b.
Explanation / Answer
Solution:
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
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)