Dada la tabla HAB_ROOM(planta_floor,num,tipo_type) siendo su primary key planta_...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Dada la tabla HAB_ROOM(planta_floor,num,tipo_type) siendo su primary key planta_floor y num, con num el número de habitación. Escribe una sentencia SQL que añada una restriccion al atributo planta_floor para que solo admita valores entre 0 y 9. Recuerda que es necesario completar todos los huecos.Given HAB_ROOM(planta_floor,num,tipo_type) with its primary key being planta_floor and num, with num being the room number. Write a SQL statement that adds a new constraint to the attribute planta_floor to allow only values between 0 and 9. Remember to fill n all the fields.