please do all parts A and B 1. (40 points) Consider the following data structure

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

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.