tegory description HEQUEST Column Type DECIMAL 4 DECIMAL 4 Length Decimal places
ID: 3757575 • Letter: T
Question
tegory description HEQUEST Column Type DECIMAL 4 DECIMAL 4 Length Decimal places Nulls SERVICE ID No Service ID (primary key) CONDO ID Condo ID of the condo for which service is requested CATEGORY NUM DECIMAL4 Category number of the requested service DESCRIPTION CHAR 255 Description of specific service requested for condo STATUS CHAR Description of status of service request 255 Estimated number of hours required to complete the service EST HOURS DECIMAL 4 SPENT HOURS DECIMAL4 Hours already spent on the service Next scheduled date for work on this service (or null if no NEXTSERVICEDATE DATE - - next service date is specified) FIGURE 3-40 Table layouts for the Solmaris Condominium Group database (continued) The SERVICE_REQUEST table uses the CHAR data type for the DESCRIPTION and STATUS fields. Is there an alternate data type that could be used to store the values in these fields? Justify your reason for choosing an alternate data type or for leaving the data type as CHAR. 7.Explanation / Answer
I have studied your table and i would prefer the following things for the mentioned attributes(as per my knowledge of SQL and databases)
For DESCRIPTION, you can use VARCHAR as it allows a variable length string with maximum characters limit upto 255 as the description of the required service will be of variable length
For the similar reason,you should chose VARCHAR for STATUS as well as it also contains a variable length description of the status
The rest of the fields and their values seems to be correct
Hope i have answered your question satisfactorily.Leave doubts in comment section if any
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.