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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started