Test Your Understanding 1 in sql



Question:

Test Your Understanding 1

Refer the below schema, and modify the given query appropriately in order to create the product table.

COLUMN NAMEDATATYPESIZECONSTRAINT
prod_idnumber4Primary key
prod_namevarchar225 
Prod_expiry_datedate Not null

CODE:

create TABLE product
 ( prod_id number(4),
  prod_name varchar(25),
  prod_expiry_date date NOT NULL,
  primary key(prod_id)
); 


 rdbms programs | rdbms database program | relational database management system software |  rdbms lab programs | rdbms lab programs pdf |  dbms programs | database management software | database management system software |  examples of database software| list of database applications | database system applications | examples of database | application database application software | database management application

best dbms software |  software that is used to create | manipulate and maintain a relational database | database management system application

Tags:- rdbms programs with output | rdbms programs pdf  | dbms programs examples | rdbms lab programs | rdbms lab programs pdf | rdbms practical programs | rdbms practical programs pdf | rdbms sample programs | rdbms program | rdbms system| rdbms lab programs madras university | rdbms online programs | rdbms lab programs with output | rdbms procedure program | rdbms sql programs | last pirates code | 2021 | codechef | leetcode  |

Previous
Next Post »