Question: 1. Consider the following data structure and answer the following questions Customer = Customer ID + Customer name + Building Building = Building name Street
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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help